ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 6788 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Georgia 10
- Florida 8
- Louisiana 7
- Kentucky 5
- North Carolina 5
- Virginia 5
- Ohio 3
- Arkansas 2
- Indiana 2
- Kansas 2
- Minnesota 2
- Texas 2
- West Virginia 2
- California 1
- Illinois 1
- Maine 1
- Mississippi 1
- Nebraska 1
- New Mexico 1
- New York 1
- North Dakota 1
- Pennsylvania 1
- Puerto Rico 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395139 | 2395139 | 2022-04-10 | Orange | Virginia | 51137 | 6788 | 84 |
2391883 | 2391883 | 2022-04-09 | Orange | Virginia | 51137 | 6788 | 84 |
2388627 | 2388627 | 2022-04-08 | Orange | Virginia | 51137 | 6788 | 84 |
2330442 | 2330442 | 2022-03-22 | Johnson | Arkansas | 5071 | 6788 | 81 |
2301540 | 2301540 | 2022-03-13 | Sumter | Georgia | 13261 | 6788 | 162 |
2298288 | 2298288 | 2022-03-12 | Sumter | Georgia | 13261 | 6788 | 162 |
2295036 | 2295036 | 2022-03-11 | Sumter | Georgia | 13261 | 6788 | 162 |
2291784 | 2291784 | 2022-03-10 | Sumter | Georgia | 13261 | 6788 | 161 |
2293966 | 2293966 | 2022-03-10 | Fannin | Texas | 48147 | 6788 | 181 |
2271447 | 2271447 | 2022-03-03 | Caroline | Virginia | 51033 | 6788 | 78 |
2262540 | 2262540 | 2022-03-01 | White | Georgia | 13311 | 6788 | 152 |
2262790 | 2262790 | 2022-03-01 | White | Indiana | 18181 | 6788 | 92 |
2214407 | 2214407 | 2022-02-14 | Union | Louisiana | 22111 | 6788 | 121 |
2210506 | 2210506 | 2022-02-13 | Toombs | Georgia | 13279 | 6788 | 184 |
2207253 | 2207253 | 2022-02-12 | Toombs | Georgia | 13279 | 6788 | 184 |
2204000 | 2204000 | 2022-02-11 | Toombs | Georgia | 13279 | 6788 | 184 |
2205537 | 2205537 | 2022-02-11 | Adams | Ohio | 39001 | 6788 | 134 |
2194859 | 2194859 | 2022-02-08 | Jefferson Davis | Louisiana | 22053 | 6788 | 142 |
2196048 | 2196048 | 2022-02-08 | Aguadilla | Puerto Rico | 72005 | 6788 | |
2155714 | 2155714 | 2022-01-27 | Grayson | Kentucky | 21085 | 6788 | 113 |
2109000 | 2109000 | 2022-01-12 | Logan | West Virginia | 54045 | 6788 | 155 |
2065925 | 2065925 | 2021-12-30 | Perry | Pennsylvania | 42099 | 6788 | 150 |
2040533 | 2040533 | 2021-12-22 | Rutland | Vermont | 50021 | 6788 | 39 |
2020114 | 2020114 | 2021-12-16 | Yadkin | North Carolina | 37197 | 6788 | 82 |
2009513 | 2009513 | 2021-12-13 | Natchitoches | Louisiana | 22069 | 6788 | 137 |
1983534 | 1983534 | 2021-12-05 | Webster | Louisiana | 22119 | 6788 | 150 |
1980284 | 1980284 | 2021-12-04 | Webster | Louisiana | 22119 | 6788 | 150 |
1977034 | 1977034 | 2021-12-03 | Webster | Louisiana | 22119 | 6788 | 150 |
1969748 | 1969748 | 2021-12-01 | Baldwin | Georgia | 13009 | 6788 | 197 |
1946738 | 1946738 | 2021-11-24 | Independence | Arkansas | 5063 | 6788 | 161 |
1873323 | 1873323 | 2021-11-01 | Pontotoc | Mississippi | 28115 | 6788 | 106 |
1873774 | 1873774 | 2021-11-01 | Chatham | North Carolina | 37037 | 6788 | 91 |
1854415 | 1854415 | 2021-10-26 | Williams | North Dakota | 38105 | 6788 | 51 |
1815230 | 1815230 | 2021-10-14 | Genesee | New York | 36037 | 6788 | 132 |
1801475 | 1801475 | 2021-10-10 | Shelby | Kentucky | 21211 | 6788 | 98 |
1798226 | 1798226 | 2021-10-09 | Shelby | Kentucky | 21211 | 6788 | 98 |
1794977 | 1794977 | 2021-10-08 | Shelby | Kentucky | 21211 | 6788 | 98 |
1788538 | 1788538 | 2021-10-06 | St. Bernard | Louisiana | 22087 | 6788 | 96 |
1715295 | 1715295 | 2021-09-13 | Burnet | Texas | 48053 | 6788 | 94 |
1700287 | 1700287 | 2021-09-09 | Grundy | Illinois | 17063 | 6788 | 84 |
1654898 | 1654898 | 2021-08-26 | Dubois | Indiana | 18037 | 6788 | 120 |
1449963 | 1449963 | 2021-06-24 | Putnam | Florida | 12107 | 6788 | 160 |
1446718 | 1446718 | 2021-06-23 | Putnam | Florida | 12107 | 6788 | 160 |
1443473 | 1443473 | 2021-06-22 | Putnam | Florida | 12107 | 6788 | 160 |
1440228 | 1440228 | 2021-06-21 | Putnam | Florida | 12107 | 6788 | 160 |
1436981 | 1436981 | 2021-06-20 | Putnam | Florida | 12107 | 6788 | 160 |
1433734 | 1433734 | 2021-06-19 | Putnam | Florida | 12107 | 6788 | 160 |
1430488 | 1430488 | 2021-06-18 | Putnam | Florida | 12107 | 6788 | 160 |
1382773 | 1382773 | 2021-06-03 | Crow Wing | Minnesota | 27035 | 6788 | 92 |
1379527 | 1379527 | 2021-06-02 | Crow Wing | Minnesota | 27035 | 6788 | 92 |
1351058 | 1351058 | 2021-05-24 | Geauga | Ohio | 39055 | 6788 | 149 |
1343555 | 1343555 | 2021-05-22 | McCracken | Kentucky | 21145 | 6788 | 127 |
1266686 | 1266686 | 2021-04-28 | Ross | Ohio | 39141 | 6788 | 150 |
1263130 | 1263130 | 2021-04-27 | Eddy | New Mexico | 35015 | 6788 | 127 |
1193447 | 1193447 | 2021-04-06 | Flagler | Florida | 12035 | 6788 | 102 |
1014343 | 1014343 | 2021-02-09 | Roanoke | Virginia | 51161 | 6788 | 85 |
1006530 | 1006530 | 2021-02-07 | Hall | Nebraska | 31079 | 6788 | 107 |
993751 | 993751 | 2021-02-03 | Brunswick | North Carolina | 37019 | 6788 | 102 |
932131 | 932131 | 2021-01-15 | Lincoln | North Carolina | 37109 | 6788 | 42 |
924884 | 924884 | 2021-01-13 | York | Maine | 23031 | 6788 | 85 |
920905 | 920905 | 2021-01-12 | Jackson | Georgia | 13157 | 6788 | 79 |
915864 | 915864 | 2021-01-10 | Caldwell | North Carolina | 37027 | 6788 | 31 |
819699 | 819699 | 2020-12-11 | Kanawha | West Virginia | 54039 | 6788 | 164 |
505510 | 505510 | 2020-09-06 | Kings | California | 6031 | 6788 | 76 |
451309 | 451309 | 2020-08-20 | Johnson | Kansas | 20091 | 6788 | 110 |
448081 | 448081 | 2020-08-19 | Johnson | Kansas | 20091 | 6788 | 108 |
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);