ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 15610 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Ohio 10
- North Carolina 5
- New Jersey 3
- Georgia 2
- Alabama 1
- Indiana 1
- Maryland 1
- New Mexico 1
- North Dakota 1
- Pennsylvania 1
- Tennessee 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446486 | 2446486 | 2022-04-26 | Bradford | Pennsylvania | 42015 | 15610 | 205 |
2404028 | 2404028 | 2022-04-13 | Union | Ohio | 39159 | 15610 | 102 |
2400773 | 2400773 | 2022-04-12 | Union | Ohio | 39159 | 15610 | 102 |
2397518 | 2397518 | 2022-04-11 | Union | Ohio | 39159 | 15610 | 102 |
2394263 | 2394263 | 2022-04-10 | Union | Ohio | 39159 | 15610 | 102 |
2391007 | 2391007 | 2022-04-09 | Union | Ohio | 39159 | 15610 | 102 |
2387751 | 2387751 | 2022-04-08 | Union | Ohio | 39159 | 15610 | 102 |
2384496 | 2384496 | 2022-04-07 | Union | Ohio | 39159 | 15610 | 102 |
2168893 | 2168893 | 2022-01-31 | Allegany | Maryland | 24001 | 15610 | 322 |
2166437 | 2166437 | 2022-01-30 | Wilkes | North Carolina | 37193 | 15610 | 219 |
2163182 | 2163182 | 2022-01-29 | Wilkes | North Carolina | 37193 | 15610 | 219 |
2159927 | 2159927 | 2022-01-28 | Wilkes | North Carolina | 37193 | 15610 | 219 |
2088427 | 2088427 | 2022-01-06 | Ward | North Dakota | 38101 | 15610 | 235 |
2083177 | 2083177 | 2022-01-05 | Talladega | Alabama | 1121 | 15610 | 311 |
1992641 | 1992641 | 2021-12-08 | Walton | Georgia | 13297 | 15610 | 354 |
1968072 | 1968072 | 2021-11-30 | Nash | North Carolina | 37127 | 15610 | 237 |
1450025 | 1450025 | 2021-06-24 | Douglas | Georgia | 13097 | 15610 | 232 |
1435470 | 1435470 | 2021-06-19 | Medina | Ohio | 39103 | 15610 | 271 |
1432223 | 1432223 | 2021-06-18 | Medina | Ohio | 39103 | 15610 | 271 |
1418964 | 1418964 | 2021-06-14 | San Juan | New Mexico | 35045 | 15610 | 492 |
1169234 | 1169234 | 2021-03-29 | Licking | Ohio | 39089 | 15610 | 202 |
1084630 | 1084630 | 2021-03-03 | Buncombe | North Carolina | 37021 | 15610 | 302 |
1034766 | 1034766 | 2021-02-16 | Hendricks | Indiana | 18063 | 15610 | 309 |
744499 | 744499 | 2020-11-18 | Hamilton | Tennessee | 47065 | 15610 | 129 |
601875 | 601875 | 2020-10-05 | Collin | Texas | 48085 | 15610 | 152 |
189346 | 189346 | 2020-05-29 | Union | New Jersey | 34039 | 15610 | 1060 |
171048 | 171048 | 2020-05-23 | Passaic | New Jersey | 34031 | 15610 | 888 |
102620 | 102620 | 2020-04-30 | Bergen | New Jersey | 34003 | 15610 | 1136 |
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);