city-big-leads.sql

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)