ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where cases = 5040 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 12
- Kentucky 9
- Missouri 6
- North Carolina 6
- South Carolina 6
- Ohio 5
- Texas 5
- Arkansas 4
- Tennessee 4
- Virginia 4
- Washington 4
- Wisconsin 4
- Minnesota 3
- Utah 3
- Maine 2
- Massachusetts 2
- Michigan 2
- Oklahoma 2
- Pennsylvania 2
- Alabama 1
- California 1
- Illinois 1
- Indiana 1
- Louisiana 1
- Maryland 1
- Mississippi 1
- New Hampshire 1
- New Mexico 1
- New York 1
- North Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393220 | 2393220 | 2022-04-10 | Rockcastle | Kentucky | 21203 | 5040 | 58 |
2389964 | 2389964 | 2022-04-09 | Rockcastle | Kentucky | 21203 | 5040 | 58 |
2386708 | 2386708 | 2022-04-08 | Rockcastle | Kentucky | 21203 | 5040 | 58 |
2383453 | 2383453 | 2022-04-07 | Rockcastle | Kentucky | 21203 | 5040 | 58 |
2380198 | 2380198 | 2022-04-06 | Rockcastle | Kentucky | 21203 | 5040 | 58 |
2376943 | 2376943 | 2022-04-05 | Rockcastle | Kentucky | 21203 | 5040 | 58 |
2373691 | 2373691 | 2022-04-04 | Rockcastle | Kentucky | 21203 | 5040 | 58 |
2360773 | 2360773 | 2022-03-31 | Sagadahoc | Maine | 23023 | 5040 | 29 |
2337278 | 2337278 | 2022-03-24 | Jones | Georgia | 13169 | 5040 | 108 |
2337291 | 2337291 | 2022-03-24 | McDuffie | Georgia | 13189 | 5040 | 94 |
2334037 | 2334037 | 2022-03-23 | McDuffie | Georgia | 13189 | 5040 | 94 |
2285956 | 2285956 | 2022-03-08 | Lincoln | Maine | 23015 | 5040 | 31 |
2265173 | 2265173 | 2022-03-01 | Green Lake | Wisconsin | 55047 | 5040 | 58 |
2258799 | 2258799 | 2022-02-28 | Randolph | Alabama | 1111 | 5040 | 74 |
2229007 | 2229007 | 2022-02-18 | Limestone | Texas | 48293 | 5040 | 118 |
2221320 | 2221320 | 2022-02-16 | Ray | Missouri | 29177 | 5040 | 88 |
2218582 | 2218582 | 2022-02-15 | Holmes | Ohio | 39075 | 5040 | 172 |
2177251 | 2177251 | 2022-02-02 | Waynesboro city | Virginia | 51820 | 5040 | 56 |
2164559 | 2164559 | 2022-01-30 | Conway | Arkansas | 5029 | 5040 | 50 |
2161304 | 2161304 | 2022-01-29 | Conway | Arkansas | 5029 | 5040 | 50 |
2158048 | 2158048 | 2022-01-28 | Conway | Arkansas | 5029 | 5040 | 50 |
2157719 | 2157719 | 2022-01-27 | Staunton city | Virginia | 51790 | 5040 | 91 |
2084241 | 2084241 | 2022-01-05 | Allen | Louisiana | 22003 | 5040 | 119 |
2062821 | 2062821 | 2021-12-29 | Union | South Carolina | 45087 | 5040 | 113 |
1894425 | 1894425 | 2021-11-07 | Kittitas | Washington | 53037 | 5040 | 56 |
1891175 | 1891175 | 2021-11-06 | Kittitas | Washington | 53037 | 5040 | 56 |
1887925 | 1887925 | 2021-11-05 | Kittitas | Washington | 53037 | 5040 | 56 |
1861756 | 1861756 | 2021-10-28 | Uintah | Utah | 49047 | 5040 | 43 |
1858507 | 1858507 | 2021-10-27 | Uintah | Utah | 49047 | 5040 | 43 |
1838538 | 1838538 | 2021-10-21 | Clarendon | South Carolina | 45027 | 5040 | 135 |
1773843 | 1773843 | 2021-10-01 | Grimes | Texas | 48185 | 5040 | 97 |
1763919 | 1763919 | 2021-09-28 | Claiborne | Tennessee | 47025 | 5040 | 90 |
1759142 | 1759142 | 2021-09-27 | Boyle | Kentucky | 21021 | 5040 | 80 |
1717309 | 1717309 | 2021-09-14 | Alcorn | Mississippi | 28003 | 5040 | 85 |
1717763 | 1717763 | 2021-09-14 | Livingston | New York | 36051 | 5040 | 63 |
1711859 | 1711859 | 2021-09-12 | Williamsburg | South Carolina | 45089 | 5040 | 114 |
1708612 | 1708612 | 2021-09-11 | Williamsburg | South Carolina | 45089 | 5040 | 114 |
1705365 | 1705365 | 2021-09-10 | Williamsburg | South Carolina | 45089 | 5040 | 114 |
1693337 | 1693337 | 2021-09-07 | Union | Arkansas | 5139 | 5040 | 120 |
1672478 | 1672478 | 2021-08-31 | Ashland | Ohio | 39005 | 5040 | 105 |
1646337 | 1646337 | 2021-08-23 | Alexander | North Carolina | 37003 | 5040 | 88 |
1608356 | 1608356 | 2021-08-11 | Wasatch | Utah | 49051 | 5040 | 22 |
1603207 | 1603207 | 2021-08-10 | Barren | Kentucky | 21009 | 5040 | 106 |
1581507 | 1581507 | 2021-08-03 | Stark | North Dakota | 38089 | 5040 | 52 |
1576865 | 1576865 | 2021-08-02 | Macoupin | Illinois | 17117 | 5040 | 119 |
1553673 | 1553673 | 2021-07-26 | Humboldt | California | 6023 | 5040 | 53 |
1540183 | 1540183 | 2021-07-21 | Campbell | Virginia | 51031 | 5040 | 103 |
1477614 | 1477614 | 2021-07-02 | Auglaize | Ohio | 39011 | 5040 | 87 |
1446837 | 1446837 | 2021-06-23 | Murray | Georgia | 13213 | 5040 | 93 |
1440347 | 1440347 | 2021-06-21 | Murray | Georgia | 13213 | 5040 | 93 |
1437100 | 1437100 | 2021-06-20 | Murray | Georgia | 13213 | 5040 | 93 |
1433853 | 1433853 | 2021-06-19 | Murray | Georgia | 13213 | 5040 | 93 |
1430607 | 1430607 | 2021-06-18 | Murray | Georgia | 13213 | 5040 | 92 |
1427362 | 1427362 | 2021-06-17 | Murray | Georgia | 13213 | 5040 | 92 |
1424117 | 1424117 | 2021-06-16 | Murray | Georgia | 13213 | 5040 | 92 |
1397489 | 1397489 | 2021-06-07 | Lewis | Washington | 53041 | 5040 | 74 |
1332145 | 1332145 | 2021-05-18 | Chambers | Texas | 48071 | 5040 | 49 |
1315547 | 1315547 | 2021-05-13 | Huntingdon | Pennsylvania | 42061 | 5040 | 129 |
1289833 | 1289833 | 2021-05-05 | Fayette | Tennessee | 47047 | 5040 | 75 |
1188574 | 1188574 | 2021-04-04 | McDowell | North Carolina | 37111 | 5040 | 63 |
1185327 | 1185327 | 2021-04-03 | McDowell | North Carolina | 37111 | 5040 | 63 |
1182080 | 1182080 | 2021-04-02 | McDowell | North Carolina | 37111 | 5040 | 63 |
1178833 | 1178833 | 2021-04-01 | McDowell | North Carolina | 37111 | 5040 | 63 |
1155397 | 1155397 | 2021-03-25 | Chippewa | Michigan | 26033 | 5040 | 46 |
1129392 | 1129392 | 2021-03-17 | Berkshire | Massachusetts | 25003 | 5040 | 267 |
1123248 | 1123248 | 2021-03-15 | Pettis | Missouri | 29159 | 5040 | 77 |
1120001 | 1120001 | 2021-03-14 | Pettis | Missouri | 29159 | 5040 | 77 |
1102650 | 1102650 | 2021-03-09 | Habersham | Georgia | 13137 | 5040 | 145 |
1103531 | 1103531 | 2021-03-09 | Chisago | Minnesota | 27025 | 5040 | 47 |
1088039 | 1088039 | 2021-03-04 | Darke | Ohio | 39037 | 5040 | 114 |
1084910 | 1084910 | 2021-03-03 | McClain | Oklahoma | 40087 | 5040 | 50 |
1049196 | 1049196 | 2021-02-20 | Kay | Oklahoma | 40071 | 5040 | 72 |
1026855 | 1026855 | 2021-02-13 | Hawkins | Tennessee | 47073 | 5040 | 91 |
1014982 | 1014982 | 2021-02-10 | Coffee | Georgia | 13069 | 5040 | 135 |
941143 | 941143 | 2021-01-18 | Hampshire | Massachusetts | 25015 | 5040 | 219 |
926281 | 926281 | 2021-01-13 | Roane | Tennessee | 47145 | 5040 | 76 |
926680 | 926680 | 2021-01-13 | Lynchburg city | Virginia | 51680 | 5040 | 60 |
886070 | 886070 | 2021-01-01 | Blue Earth | Minnesota | 27013 | 5040 | 28 |
887895 | 887895 | 2021-01-01 | Calumet | Wisconsin | 55015 | 5040 | 37 |
882825 | 882825 | 2020-12-31 | Blue Earth | Minnesota | 27013 | 5040 | 28 |
873602 | 873602 | 2020-12-28 | Valencia | New Mexico | 35061 | 5040 | 66 |
849747 | 849747 | 2020-12-21 | Bartholomew | Indiana | 18005 | 5040 | 83 |
844066 | 844066 | 2020-12-19 | Cass | Missouri | 29037 | 5040 | 48 |
840821 | 840821 | 2020-12-18 | Cass | Missouri | 29037 | 5040 | 48 |
819440 | 819440 | 2020-12-11 | Walker | Texas | 48471 | 5040 | 74 |
806813 | 806813 | 2020-12-07 | St. Croix | Wisconsin | 55109 | 5040 | 22 |
792154 | 792154 | 2020-12-03 | Franklin | Missouri | 29071 | 5040 | 86 |
740800 | 740800 | 2020-11-17 | Lorain | Ohio | 39093 | 5040 | 95 |
696120 | 696120 | 2020-11-03 | Taylor | Texas | 48441 | 5040 | 76 |
668648 | 668648 | 2020-10-26 | Ottawa | Michigan | 26139 | 5040 | 72 |
636669 | 636669 | 2020-10-16 | Hillsborough | New Hampshire | 33011 | 5040 | 310 |
610920 | 610920 | 2020-10-08 | Robeson | North Carolina | 37155 | 5040 | 84 |
571256 | 571256 | 2020-09-26 | Howard | Maryland | 24027 | 5040 | 122 |
546584 | 546584 | 2020-09-18 | York | South Carolina | 45091 | 5040 | 65 |
404274 | 404274 | 2020-08-05 | Chester | Pennsylvania | 42029 | 5040 | 349 |
157197 | 157197 | 2020-05-18 | Milwaukee | Wisconsin | 55079 | 5040 | 256 |
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);