ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 7657 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- North Carolina 6
- Ohio 3
- Pennsylvania 3
- Texas 3
- Michigan 2
- New Jersey 2
- Arkansas 1
- California 1
- Georgia 1
- Indiana 1
- Maryland 1
- Minnesota 1
- Montana 1
- Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2355806 | 2355806 | 2022-03-29 | Hockley | Texas | 48219 | 7657 | 161 |
2256706 | 2256706 | 2022-02-27 | Dorchester | Maryland | 24019 | 7657 | 105 |
2189179 | 2189179 | 2022-02-06 | Pasquotank | North Carolina | 37139 | 7657 | 111 |
2185926 | 2185926 | 2022-02-05 | Pasquotank | North Carolina | 37139 | 7657 | 111 |
2182674 | 2182674 | 2022-02-04 | Pasquotank | North Carolina | 37139 | 7657 | 111 |
2150447 | 2150447 | 2022-01-25 | Clarion | Pennsylvania | 42031 | 7657 | 184 |
2055969 | 2055969 | 2021-12-27 | Logan | Ohio | 39091 | 7657 | 124 |
2026700 | 2026700 | 2021-12-18 | Fulton | Ohio | 39051 | 7657 | 126 |
1975548 | 1975548 | 2021-12-02 | Campbell | Virginia | 51031 | 7657 | 149 |
1828170 | 1828170 | 2021-10-18 | Salem | New Jersey | 34033 | 7657 | 202 |
1812915 | 1812915 | 2021-10-13 | Nacogdoches | Texas | 48347 | 7657 | 217 |
1767855 | 1767855 | 2021-09-29 | Campbell | Wyoming | 56005 | 7657 | 77 |
1729045 | 1729045 | 2021-09-18 | Mississippi | Arkansas | 5093 | 7657 | 123 |
1671737 | 1671737 | 2021-08-31 | Van Buren | Michigan | 26159 | 7657 | 139 |
1668490 | 1668490 | 2021-08-30 | Van Buren | Michigan | 26159 | 7657 | 139 |
1425920 | 1425920 | 2021-06-16 | Lawrence | Pennsylvania | 42073 | 7657 | 214 |
1323531 | 1323531 | 2021-05-16 | Walker | Georgia | 13295 | 7657 | 87 |
1236724 | 1236724 | 2021-04-19 | Rice | Minnesota | 27131 | 7657 | 102 |
1154870 | 1154870 | 2021-03-25 | Hancock | Indiana | 18059 | 7657 | 139 |
1065213 | 1065213 | 2021-02-25 | Orange | North Carolina | 37135 | 7657 | 93 |
1061618 | 1061618 | 2021-02-24 | Cascade | Montana | 30013 | 7657 | 150 |
990702 | 990702 | 2021-02-02 | Marion | Ohio | 39101 | 7657 | 113 |
744667 | 744667 | 2020-11-18 | Hays | Texas | 48209 | 7657 | 93 |
715041 | 715041 | 2020-11-09 | Lehigh | Pennsylvania | 42077 | 7657 | 372 |
620601 | 620601 | 2020-10-11 | Forsyth | North Carolina | 37067 | 7657 | 105 |
576728 | 576728 | 2020-09-28 | Kings | California | 6031 | 7657 | 80 |
565490 | 565490 | 2020-09-24 | Durham | North Carolina | 37063 | 7657 | 94 |
279376 | 279376 | 2020-06-27 | Mercer | New Jersey | 34021 | 7657 | 578 |
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);