ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 11498 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Iowa 7
- Kentucky 5
- Texas 5
- Georgia 3
- North Carolina 3
- Washington 3
- Ohio 2
- Alabama 1
- Indiana 1
- Kansas 1
- Michigan 1
- Minnesota 1
- New York 1
- North Dakota 1
- Oregon 1
- Pennsylvania 1
- Rhode Island 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453791 | 2453791 | 2022-04-28 | Clallam | Washington | 53009 | 11498 | 140 |
2450535 | 2450535 | 2022-04-27 | Clallam | Washington | 53009 | 11498 | 140 |
2353563 | 2353563 | 2022-03-29 | Murray | Georgia | 13213 | 11498 | 183 |
2330791 | 2330791 | 2022-03-22 | Murray | Georgia | 13213 | 11498 | 180 |
2331115 | 2331115 | 2022-03-22 | Clinton | Iowa | 19045 | 11498 | 143 |
2327863 | 2327863 | 2022-03-21 | Clinton | Iowa | 19045 | 11498 | 143 |
2324610 | 2324610 | 2022-03-20 | Clinton | Iowa | 19045 | 11498 | 143 |
2321356 | 2321356 | 2022-03-19 | Clinton | Iowa | 19045 | 11498 | 143 |
2318102 | 2318102 | 2022-03-18 | Clinton | Iowa | 19045 | 11498 | 143 |
2314849 | 2314849 | 2022-03-17 | Clinton | Iowa | 19045 | 11498 | 143 |
2311596 | 2311596 | 2022-03-16 | Clinton | Iowa | 19045 | 11498 | 143 |
2286633 | 2286633 | 2022-03-08 | Livingston | New York | 36051 | 11498 | 113 |
2266170 | 2266170 | 2022-03-02 | Finney | Kansas | 20055 | 11498 | 106 |
2244815 | 2244815 | 2022-02-23 | Union | Pennsylvania | 42119 | 11498 | 148 |
2225033 | 2225033 | 2022-02-17 | Stark | North Dakota | 38089 | 11498 | 84 |
2131379 | 2131379 | 2022-01-19 | Hood | Texas | 48221 | 11498 | 223 |
2109542 | 2109542 | 2022-01-13 | Catoosa | Georgia | 13047 | 11498 | 128 |
2051692 | 2051692 | 2021-12-26 | McCracken | Kentucky | 21145 | 11498 | 202 |
2048442 | 2048442 | 2021-12-25 | McCracken | Kentucky | 21145 | 11498 | 202 |
2045192 | 2045192 | 2021-12-24 | McCracken | Kentucky | 21145 | 11498 | 202 |
2041943 | 2041943 | 2021-12-23 | McCracken | Kentucky | 21145 | 11498 | 202 |
2038693 | 2038693 | 2021-12-22 | McCracken | Kentucky | 21145 | 11498 | 202 |
1920218 | 1920218 | 2021-11-15 | Wise | Texas | 48497 | 11498 | 205 |
1916968 | 1916968 | 2021-11-14 | Wise | Texas | 48497 | 11498 | 205 |
1913718 | 1913718 | 2021-11-13 | Wise | Texas | 48497 | 11498 | 205 |
1834848 | 1834848 | 2021-10-20 | Stanly | North Carolina | 37167 | 11498 | 180 |
1714765 | 1714765 | 2021-09-13 | Muskingum | Ohio | 39119 | 11498 | 145 |
1630099 | 1630099 | 2021-08-18 | Brunswick | North Carolina | 37019 | 11498 | 171 |
1537084 | 1537084 | 2021-07-20 | Thurston | Washington | 53067 | 11498 | 118 |
1429107 | 1429107 | 2021-06-17 | Jackson | Oregon | 41029 | 11498 | 146 |
1296596 | 1296596 | 2021-05-07 | Rockwall | Texas | 48397 | 11498 | 156 |
1143276 | 1143276 | 2021-03-21 | Portage | Ohio | 39133 | 11498 | 190 |
1107851 | 1107851 | 2021-03-10 | Unknown | Rhode Island | 11498 | 25 | |
1008780 | 1008780 | 2021-02-08 | Clark | Indiana | 18019 | 11498 | 174 |
910743 | 910743 | 2021-01-09 | Lee | Alabama | 1081 | 11498 | 79 |
908852 | 908852 | 2021-01-08 | Scott | Minnesota | 27139 | 11498 | 91 |
889905 | 889905 | 2021-01-02 | Catawba | North Carolina | 37035 | 11498 | 160 |
743206 | 743206 | 2020-11-18 | Genesee | Michigan | 26049 | 11498 | 378 |
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);