ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 3600 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Indiana 9
- Missouri 9
- Nebraska 7
- Georgia 6
- Illinois 6
- Alabama 5
- Kentucky 5
- Puerto Rico 5
- West Virginia 5
- Arkansas 4
- California 4
- Louisiana 4
- Tennessee 4
- Minnesota 3
- Mississippi 3
- Pennsylvania 3
- Idaho 2
- Iowa 2
- Massachusetts 2
- Michigan 2
- New Mexico 2
- Ohio 2
- Oklahoma 2
- Oregon 2
- Virginia 2
- Wisconsin 2
- Arizona 1
- Colorado 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484051 | 2484051 | 2022-05-08 | Parke | Indiana | 18121 | 3600 | 46 |
2480793 | 2480793 | 2022-05-07 | Parke | Indiana | 18121 | 3600 | 46 |
2477535 | 2477535 | 2022-05-06 | Parke | Indiana | 18121 | 3600 | 46 |
2474277 | 2474277 | 2022-05-05 | Parke | Indiana | 18121 | 3600 | 46 |
2471020 | 2471020 | 2022-05-04 | Parke | Indiana | 18121 | 3600 | 46 |
2429824 | 2429824 | 2022-04-21 | Schuyler | New York | 36097 | 3600 | 25 |
2413991 | 2413991 | 2022-04-16 | Aibonito | Puerto Rico | 72009 | 3600 | |
2410735 | 2410735 | 2022-04-15 | Aibonito | Puerto Rico | 72009 | 3600 | |
2407479 | 2407479 | 2022-04-14 | Aibonito | Puerto Rico | 72009 | 3600 | |
2384989 | 2384989 | 2022-04-07 | Bandera | Texas | 48019 | 3600 | 75 |
2381734 | 2381734 | 2022-04-06 | Bandera | Texas | 48019 | 3600 | 75 |
2378479 | 2378479 | 2022-04-05 | Bandera | Texas | 48019 | 3600 | 75 |
2354629 | 2354629 | 2022-03-29 | Madison | Missouri | 29123 | 3600 | 57 |
2289573 | 2289573 | 2022-03-09 | Macon | Missouri | 29121 | 3600 | 52 |
2286321 | 2286321 | 2022-03-08 | Macon | Missouri | 29121 | 3600 | 52 |
2283069 | 2283069 | 2022-03-07 | Macon | Missouri | 29121 | 3600 | 50 |
2264036 | 2264036 | 2022-03-01 | Ramsey | North Dakota | 38071 | 3600 | 55 |
2265182 | 2265182 | 2022-03-01 | Lafayette | Wisconsin | 55065 | 3600 | 22 |
2257239 | 2257239 | 2022-02-27 | Saline | Nebraska | 31151 | 3600 | 8 |
2253988 | 2253988 | 2022-02-26 | Saline | Nebraska | 31151 | 3600 | 8 |
2250737 | 2250737 | 2022-02-25 | Saline | Nebraska | 31151 | 3600 | 8 |
2246776 | 2246776 | 2022-02-24 | Fleming | Kentucky | 21069 | 3600 | 44 |
2243525 | 2243525 | 2022-02-23 | Fleming | Kentucky | 21069 | 3600 | 44 |
2238922 | 2238922 | 2022-02-21 | Appomattox | Virginia | 51011 | 3600 | 50 |
2193570 | 2193570 | 2022-02-07 | Grant | West Virginia | 54023 | 3600 | 52 |
2187795 | 2187795 | 2022-02-06 | Minidoka | Idaho | 16067 | 3600 | 55 |
2184542 | 2184542 | 2022-02-05 | Minidoka | Idaho | 16067 | 3600 | 55 |
2154329 | 2154329 | 2022-01-26 | Addison | Vermont | 50001 | 3600 | 13 |
2104939 | 2104939 | 2022-01-11 | Montour | Pennsylvania | 42093 | 3600 | 82 |
2083742 | 2083742 | 2022-01-05 | Edgar | Illinois | 17045 | 3600 | 74 |
2059346 | 2059346 | 2021-12-28 | Crook | Oregon | 41013 | 3600 | 60 |
2050714 | 2050714 | 2021-12-26 | La Paz | Arizona | 4012 | 3600 | 107 |
2030396 | 2030396 | 2021-12-19 | Bledsoe | Tennessee | 47007 | 3600 | 27 |
2026189 | 2026189 | 2021-12-18 | Perry | Missouri | 29157 | 3600 | 40 |
2027145 | 2027145 | 2021-12-18 | Bledsoe | Tennessee | 47007 | 3600 | 27 |
2021531 | 2021531 | 2021-12-17 | Randolph | Arkansas | 5121 | 3600 | 65 |
2023894 | 2023894 | 2021-12-17 | Bledsoe | Tennessee | 47007 | 3600 | 27 |
1995841 | 1995841 | 2021-12-09 | McDuffie | Georgia | 13189 | 3600 | 78 |
1989470 | 1989470 | 2021-12-07 | Crawford | Illinois | 17033 | 3600 | 47 |
1989616 | 1989616 | 2021-12-07 | Owen | Indiana | 18119 | 3600 | 80 |
1988316 | 1988316 | 2021-12-06 | Gonzales | Texas | 48177 | 3600 | 85 |
1973686 | 1973686 | 2021-12-02 | Meade | Kentucky | 21163 | 3600 | 47 |
1973794 | 1973794 | 2021-12-02 | Hancock | Maine | 23009 | 3600 | 55 |
1968870 | 1968870 | 2021-11-30 | Lampasas | Texas | 48281 | 3600 | 69 |
1890916 | 1890916 | 2021-11-06 | Reeves | Texas | 48389 | 3600 | 56 |
1850593 | 1850593 | 2021-10-25 | Tishomingo | Mississippi | 28141 | 3600 | 92 |
1849010 | 1849010 | 2021-10-24 | Wyoming | West Virginia | 54109 | 3600 | 59 |
1784318 | 1784318 | 2021-10-05 | Del Norte | California | 6015 | 3600 | 39 |
1781069 | 1781069 | 2021-10-04 | Del Norte | California | 6015 | 3600 | 39 |
1756382 | 1756382 | 2021-09-26 | Audrain | Missouri | 29007 | 3600 | 63 |
1739044 | 1739044 | 2021-09-21 | Burke | Georgia | 13033 | 3600 | 70 |
1716042 | 1716042 | 2021-09-14 | Lincoln | Arkansas | 5079 | 3600 | 55 |
1711008 | 1711008 | 2021-09-12 | Washington | Missouri | 29221 | 3600 | 57 |
1677684 | 1677684 | 2021-09-02 | Scott | Indiana | 18143 | 3600 | 63 |
1631577 | 1631577 | 2021-08-19 | Jackson | Arkansas | 5067 | 3600 | 39 |
1628859 | 1628859 | 2021-08-18 | Perry | Illinois | 17145 | 3600 | 74 |
1600436 | 1600436 | 2021-08-09 | Tate | Mississippi | 28137 | 3600 | 88 |
1597040 | 1597040 | 2021-08-08 | Carlton | Minnesota | 27017 | 3600 | 58 |
1593791 | 1593791 | 2021-08-07 | Carlton | Minnesota | 27017 | 3600 | 58 |
1590542 | 1590542 | 2021-08-06 | Carlton | Minnesota | 27017 | 3600 | 58 |
1587566 | 1587566 | 2021-08-05 | Warren | Missouri | 29219 | 3600 | 39 |
1560673 | 1560673 | 2021-07-28 | Adams | Indiana | 18001 | 3600 | 57 |
1553335 | 1553335 | 2021-07-25 | Fayette | West Virginia | 54019 | 3600 | 82 |
1550088 | 1550088 | 2021-07-24 | Fayette | West Virginia | 54019 | 3600 | 82 |
1546841 | 1546841 | 2021-07-23 | Fayette | West Virginia | 54019 | 3600 | 82 |
1403463 | 1403463 | 2021-06-09 | Hardin | Tennessee | 47071 | 3600 | 69 |
1397265 | 1397265 | 2021-06-07 | Uvalde | Texas | 48463 | 3600 | 73 |
1391189 | 1391189 | 2021-06-06 | Dallas | Alabama | 1047 | 3600 | 154 |
1387944 | 1387944 | 2021-06-05 | Dallas | Alabama | 1047 | 3600 | 154 |
1384699 | 1384699 | 2021-06-04 | Dallas | Alabama | 1047 | 3600 | 154 |
1329665 | 1329665 | 2021-05-18 | St. Francis | Arkansas | 5123 | 3600 | 44 |
1310549 | 1310549 | 2021-05-12 | Wayne | Georgia | 13305 | 3600 | 88 |
1307303 | 1307303 | 2021-05-11 | Wayne | Georgia | 13305 | 3600 | 88 |
1304057 | 1304057 | 2021-05-10 | Wayne | Georgia | 13305 | 3600 | 88 |
1301408 | 1301408 | 2021-05-09 | Evangeline | Louisiana | 22039 | 3600 | 93 |
1302669 | 1302669 | 2021-05-09 | Trujillo Alto | Puerto Rico | 72139 | 3600 | |
1298161 | 1298161 | 2021-05-08 | Evangeline | Louisiana | 22039 | 3600 | 93 |
1294915 | 1294915 | 2021-05-07 | Evangeline | Louisiana | 22039 | 3600 | 93 |
1288141 | 1288141 | 2021-05-05 | Marion | Iowa | 19125 | 3600 | 75 |
1284895 | 1284895 | 2021-05-04 | Marion | Iowa | 19125 | 3600 | 75 |
1276550 | 1276550 | 2021-05-01 | Polk | Oregon | 41053 | 3600 | 52 |
1274224 | 1274224 | 2021-04-30 | Green | Wisconsin | 55045 | 3600 | 24 |
1244141 | 1244141 | 2021-04-21 | Pike | Pennsylvania | 42103 | 3600 | 52 |
1217627 | 1217627 | 2021-04-13 | Belknap | New Hampshire | 33001 | 3600 | 96 |
1177538 | 1177538 | 2021-04-01 | Montgomery | Illinois | 17135 | 3600 | 77 |
1153562 | 1153562 | 2021-03-24 | Cooke | Texas | 48097 | 3600 | 66 |
1094528 | 1094528 | 2021-03-06 | Crawford | Ohio | 39033 | 3600 | 98 |
1075825 | 1075825 | 2021-02-28 | Titus | Texas | 48449 | 3600 | 78 |
1043381 | 1043381 | 2021-02-18 | Washington | Texas | 48477 | 3600 | 80 |
1043598 | 1043598 | 2021-02-18 | Lewis | Washington | 53041 | 3600 | 47 |
993900 | 993900 | 2021-02-03 | Ashland | Ohio | 39005 | 3600 | 38 |
990785 | 990785 | 2021-02-02 | Mayes | Oklahoma | 40097 | 3600 | 34 |
986101 | 986101 | 2021-02-01 | Montgomery | Indiana | 18107 | 3600 | 57 |
977117 | 977117 | 2021-01-29 | Camden | Missouri | 29029 | 3600 | 74 |
971038 | 971038 | 2021-01-27 | Chatham | North Carolina | 37037 | 3600 | 69 |
961780 | 961780 | 2021-01-24 | Toa Baja | Puerto Rico | 72137 | 3600 | |
891887 | 891887 | 2021-01-03 | Marion | Illinois | 17121 | 3600 | 104 |
892920 | 892920 | 2021-01-03 | Dakota | Nebraska | 31043 | 3600 | 56 |
889674 | 889674 | 2021-01-02 | Dakota | Nebraska | 31043 | 3600 | 56 |
886428 | 886428 | 2021-01-01 | Dakota | Nebraska | 31043 | 3600 | 56 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);