Skip to content

Instantly share code, notes, and snippets.

@zsan

zsan/

Created February 24, 2016 17:07
Show Gist options
  • Save zsan/c1e09a0c927d1c463c43 to your computer and use it in GitHub Desktop.
Save zsan/c1e09a0c927d1c463c43 to your computer and use it in GitHub Desktop.
Download ZIP
city-big-leads.sql
Raw

mysql> select * from cities where number_of_leads > 1000;
+------+----------------------+-------+------------+-----------------+---------+
| id | name | state | population | number_of_leads | scraped |
+------+----------------------+-------+------------+-----------------+---------+
| 1 | New York | NY | NULL | 6995 | f |
| 2 | Los Angeles | CA | NULL | 2530 | f |
| 3 | Chicago | IL | NULL | 2939 | f |
| 4 | Houston | TX | NULL | 1613 | f |
| 5 | Phoenix | AZ | NULL | 1808 | f |
| 8 | Dallas | TX | NULL | 1944 | f |
| 9 | San Diego | CA | NULL | 1074 | f |
| 11 | Detroit | MI | NULL | 1195 | f |
| 22 | Boston | MA | NULL | 1290 | f |
| 24 | Denver | CO | NULL | 1776 | f |
| 25 | Seattle | WA | NULL | 1628 | f |
| 27 | Washington | DC | NULL | 2671 | f |
| 28 | Las Vegas | NV | NULL | 1109 | f |
| 29 | Portland | OR | NULL | 1363 | f |
| 33 | Atlanta | GA | NULL | 1846 | f |
| 38 | Mesa | AZ | NULL | 1449 | f |
| 43 | Miami | FL | NULL | 1245 | f |
| 47 | Minneapolis | MN | NULL | 1033 | f |
| 52 | St. Louis | MO | NULL | 1163 | f |
| 53 | Tampa | FL | NULL | 1025 | f |
| 55 | Anaheim | CA | NULL | 2211 | f |
| 58 | Aurora | CO | NULL | 1656 | f |
| 66 | St. Paul | MN | NULL | 1038 | f |
| 74 | Glendale | AZ | NULL | 1547 | f |
| 78 | Jersey City | NJ | NULL | 3368 | f |
| 79 | Scottsdale | AZ | NULL | 1640 | f |
| 95 | Hialeah | FL | NULL | 1018 | f |
| 96 | Arlington | VA | NULL | 1269 | f |
| 106 | Yonkers | NY | NULL | 1298 | f |
| 107 | Irving | TX | NULL | 1160 | f |
| 143 | Vancouver | WA | NULL | 1315 | f |
| 145 | Peoria | AZ | NULL | 1461 | f |
| 164 | Alexandria | VA | NULL | 1643 | f |
| 172 | Lakewood | CO | NULL | 1079 | f |
| 191 | Carrollton | TX | NULL | 1129 | f |
| 195 | Bellevue | WA | NULL | 1048 | f |
| 231 | Miami Gardens | FL | NULL | 1001 | f |
| 233 | Miramar | FL | NULL | 1585 | f |
| 235 | Arvada | CO | NULL | 1014 | f |
| 261 | Richardson | TX | NULL | 1043 | f |
| 274 | Centennial | CO | NULL | 1536 | f |
| 359 | Sandy Springs | GA | NULL | 1127 | f |
| 407 | Missouri City | TX | NULL | 1270 | f |
| 468 | Marietta | GA | NULL | 1708 | f |
| 509 | Walnut Creek | CA | NULL | 1391 | f |
| 526 | Union City | NJ | NULL | 1441 | f |
| 743 | Kirkland | WA | NULL | 1119 | f |
| 828 | Sayreville | NJ | NULL | 4517 | f |
| 852 | Littleton | CO | NULL | 1565 | f |
| 1066 | Englewood | CO | NULL | 1202 | f |
| 1295 | Melrose | MA | NULL | 1300 | f |
| 1332 | Paramus | NJ | NULL | 1028 | f |
| 1968 | Belle Glade | FL | NULL | 1484 | f |
| 2094 | Hyattsville | MD | NULL | 1607 | f |
| 2157 | Vienna | VA | NULL | 1066 | f |
| 2232 | Greenwood Village | CO | NULL | 1190 | f |
| 2329 | Richmond | TX | NULL | 1077 | f |
| 2387 | Malibu | CA | NULL | 1169 | f |
| 2568 | Lincolnwood | IL | NULL | 1905 | f |
| 2571 | Picayune | MS | NULL | 1005 | f |
| 2679 | Falls Church | VA | NULL | 1850 | f |
| 2992 | London | OH | NULL | 1094 | f |
| 3086 | Wharton | TX | NULL | 1289 | f |
| 3771 | East Hills | NY | NULL | 1097 | f |
| 3827 | Glen Ridge | NJ | NULL | 1574 | f |
| 3852 | Pahokee | FL | NULL | 1270 | f |
| 3898 | Manorhaven | NY | NULL | 1314 | f |
| 3909 | Pelham | NY | NULL | 3204 | f |
| 3919 | Riverdale Park | MD | NULL | 1583 | f |
| 3935 | Cheverly | MD | NULL | 1550 | f |
| 3945 | Cherry Hills Village | CO | NULL | 1269 | f |
| 3964 | Glenarden | MD | NULL | 1239 | f |
| 4052 | Princeton | TX | NULL | 1070 | f |
| 4195 | Stickney | IL | NULL | 1874 | f |
| 4215 | Fort Meade | FL | NULL | 1410 | f |
| 4334 | Pelham Manor | NY | NULL | 3413 | f |
| 4367 | Kings Point | NY | NULL | 1516 | f |
| 4414 | Old Westbury | NY | NULL | 1057 | f |
| 4501 | Demarest | NJ | NULL | 1229 | f |
| 4634 | Harrington Park | NJ | NULL | 1039 | f |
| 4653 | Seat Pleasant | MD | NULL | 1490 | f |
| 4776 | Flower Hill | NY | NULL | 1285 | f |
| 4781 | North Hills | NY | NULL | 1271 | f |
| 4802 | Madison | IL | NULL | 1034 | f |
+------+----------------------+-------+------------+-----------------+---------+
84 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment