ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 13418 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- North Carolina 4
- Illinois 3
- Mississippi 3
- New Mexico 3
- Ohio 3
- California 2
- New York 2
- Alabama 1
- Delaware 1
- Kentucky 1
- Minnesota 1
- Missouri 1
- North Dakota 1
- Pennsylvania 1
- Tennessee 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422779 | 2422779 | 2022-04-19 | Kandiyohi | Minnesota | 27067 | 13418 | 138 |
2359796 | 2359796 | 2022-03-31 | San Benito | California | 6069 | 13418 | 98 |
2322440 | 2322440 | 2022-03-19 | Warren | New York | 36113 | 13418 | 123 |
2319919 | 2319919 | 2022-03-18 | Atascosa | Texas | 48013 | 13418 | 230 |
2309464 | 2309464 | 2022-03-15 | Edgecombe | North Carolina | 37065 | 13418 | 141 |
2167927 | 2167927 | 2022-01-31 | Tehama | California | 6103 | 13418 | 145 |
2169758 | 2169758 | 2022-01-31 | Athens | Ohio | 39009 | 13418 | 111 |
2155695 | 2155695 | 2022-01-27 | Christian | Kentucky | 21047 | 13418 | 182 |
2147187 | 2147187 | 2022-01-24 | Bradford | Pennsylvania | 42015 | 13418 | 180 |
2072239 | 2072239 | 2022-01-01 | Pickaway | Ohio | 39129 | 13418 | 168 |
2068988 | 2068988 | 2021-12-31 | Pickaway | Ohio | 39129 | 13418 | 168 |
1945875 | 1945875 | 2021-11-23 | Anderson | Tennessee | 47001 | 13418 | 234 |
1870520 | 1870520 | 2021-10-31 | Caldwell | North Carolina | 37027 | 13418 | 214 |
1867271 | 1867271 | 2021-10-30 | Caldwell | North Carolina | 37027 | 13418 | 214 |
1864022 | 1864022 | 2021-10-29 | Caldwell | North Carolina | 37027 | 13418 | 214 |
1766173 | 1766173 | 2021-09-29 | Jasper | Missouri | 29097 | 13418 | 184 |
1711230 | 1711230 | 2021-09-12 | McKinley | New Mexico | 35031 | 13418 | 491 |
1707983 | 1707983 | 2021-09-11 | McKinley | New Mexico | 35031 | 13418 | 491 |
1704736 | 1704736 | 2021-09-10 | McKinley | New Mexico | 35031 | 13418 | 491 |
1688118 | 1688118 | 2021-09-05 | Madison | Mississippi | 28089 | 13418 | 256 |
1684868 | 1684868 | 2021-09-04 | Madison | Mississippi | 28089 | 13418 | 256 |
1681617 | 1681617 | 2021-09-03 | Madison | Mississippi | 28089 | 13418 | 256 |
1641832 | 1641832 | 2021-08-22 | LaSalle | Illinois | 17099 | 13418 | 319 |
1638582 | 1638582 | 2021-08-21 | LaSalle | Illinois | 17099 | 13418 | 319 |
1635332 | 1635332 | 2021-08-20 | LaSalle | Illinois | 17099 | 13418 | 319 |
1034083 | 1034083 | 2021-02-16 | Morgan | Alabama | 1103 | 13418 | 234 |
1011631 | 1011631 | 2021-02-09 | Kent | Delaware | 10001 | 13418 | 259 |
854298 | 854298 | 2020-12-22 | Burleigh | North Dakota | 38015 | 13418 | 161 |
766532 | 766532 | 2020-11-25 | Monroe | New York | 36055 | 13418 | 276 |
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);