ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 12202 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Iowa 6
- Minnesota 4
- New York 3
- South Carolina 3
- Arizona 2
- California 2
- Alabama 1
- Alaska 1
- Maine 1
- Ohio 1
- Pennsylvania 1
- Puerto Rico 1
- Tennessee 1
- Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2416810 | 2416810 | 2022-04-17 | Washington | New York | 36115 | 12202 | 113 |
2237400 | 2237400 | 2022-02-21 | Winona | Minnesota | 27169 | 12202 | 70 |
2234149 | 2234149 | 2022-02-20 | Winona | Minnesota | 27169 | 12202 | 70 |
2230898 | 2230898 | 2022-02-19 | Winona | Minnesota | 27169 | 12202 | 70 |
2227647 | 2227647 | 2022-02-18 | Winona | Minnesota | 27169 | 12202 | 70 |
2187445 | 2187445 | 2022-02-06 | Tuolumne | California | 6109 | 12202 | 163 |
2184192 | 2184192 | 2022-02-05 | Tuolumne | California | 6109 | 12202 | 163 |
2179850 | 2179850 | 2022-02-03 | Toa Baja | Puerto Rico | 72137 | 12202 | |
2157906 | 2157906 | 2022-01-27 | Fremont | Wyoming | 56013 | 12202 | 169 |
1988915 | 1988915 | 2021-12-07 | Walker | Alabama | 1127 | 12202 | 380 |
1952280 | 1952280 | 2021-11-25 | Darlington | South Carolina | 45031 | 12202 | 232 |
1949029 | 1949029 | 2021-11-24 | Darlington | South Carolina | 45031 | 12202 | 232 |
1945778 | 1945778 | 2021-11-23 | Darlington | South Carolina | 45031 | 12202 | 232 |
1928280 | 1928280 | 2021-11-18 | Androscoggin | Maine | 23001 | 12202 | 113 |
1928947 | 1928947 | 2021-11-18 | Chemung | New York | 36015 | 12202 | 169 |
1870484 | 1870484 | 2021-10-31 | Oswego | New York | 36075 | 12202 | 120 |
1585638 | 1585638 | 2021-08-04 | Alexandria city | Virginia | 51510 | 12202 | 141 |
1579539 | 1579539 | 2021-08-03 | Matanuska-Susitna Borough | Alaska | 2170 | 12202 | 59 |
1465910 | 1465910 | 2021-06-29 | Cochise | Arizona | 4003 | 12202 | 293 |
1462665 | 1462665 | 2021-06-28 | Cochise | Arizona | 4003 | 12202 | 293 |
1250590 | 1250590 | 2021-04-23 | Blair | Pennsylvania | 42013 | 12202 | 319 |
1060823 | 1060823 | 2021-02-24 | Dubuque | Iowa | 19061 | 12202 | 194 |
1057577 | 1057577 | 2021-02-23 | Dubuque | Iowa | 19061 | 12202 | 192 |
1054331 | 1054331 | 2021-02-22 | Dubuque | Iowa | 19061 | 12202 | 192 |
1051084 | 1051084 | 2021-02-21 | Dubuque | Iowa | 19061 | 12202 | 191 |
1047837 | 1047837 | 2021-02-20 | Dubuque | Iowa | 19061 | 12202 | 191 |
1044592 | 1044592 | 2021-02-19 | Dubuque | Iowa | 19061 | 12202 | 191 |
925787 | 925787 | 2021-01-13 | Licking | Ohio | 39089 | 12202 | 127 |
673135 | 673135 | 2020-10-27 | Hamilton | Tennessee | 47065 | 12202 | 110 |
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);