ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 2037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Maryland 6
- New Jersey 5
- Alabama 4
- Connecticut 2
- Pennsylvania 2
- California 1
- Florida 1
- Massachusetts 1
- Nevada 1
- New York 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461709 | 2461709 | 2022-05-01 | Montgomery | Maryland | 24031 | 172800 | 2037 |
2458453 | 2458453 | 2022-04-30 | Montgomery | Maryland | 24031 | 172800 | 2037 |
2455197 | 2455197 | 2022-04-29 | Montgomery | Maryland | 24031 | 172800 | 2037 |
2451941 | 2451941 | 2022-04-28 | Montgomery | Maryland | 24031 | 172410 | 2037 |
2448685 | 2448685 | 2022-04-27 | Montgomery | Maryland | 24031 | 172042 | 2037 |
2128677 | 2128677 | 2022-01-19 | Jefferson | Alabama | 1073 | 157776 | 2037 |
2125424 | 2125424 | 2022-01-18 | Jefferson | Alabama | 1073 | 155617 | 2037 |
2122172 | 2122172 | 2022-01-17 | Jefferson | Alabama | 1073 | 154647 | 2037 |
2118920 | 2118920 | 2022-01-16 | Jefferson | Alabama | 1073 | 153340 | 2037 |
2104938 | 2104938 | 2022-01-11 | Montgomery | Pennsylvania | 42091 | 127060 | 2037 |
2094079 | 2094079 | 2022-01-08 | Baltimore | Maryland | 24005 | 110190 | 2037 |
1828173 | 1828173 | 2021-10-18 | Union | New Jersey | 34039 | 79343 | 2037 |
1614214 | 1614214 | 2021-08-13 | Allegheny | Pennsylvania | 42003 | 105207 | 2037 |
1214404 | 1214404 | 2021-04-12 | Ocean | New Jersey | 34029 | 71927 | 2037 |
1078624 | 1078624 | 2021-03-01 | Unknown | Puerto Rico | 4421 | 2037 | |
1057060 | 1057060 | 2021-02-23 | Fairfield | Connecticut | 9001 | 79237 | 2037 |
1012545 | 1012545 | 2021-02-09 | Essex | Massachusetts | 25009 | 79820 | 2037 |
949956 | 949956 | 2021-01-21 | Hartford | Connecticut | 9003 | 59573 | 2037 |
940280 | 940280 | 2021-01-18 | Palm Beach | Florida | 12099 | 98065 | 2037 |
930396 | 930396 | 2021-01-15 | San Diego | California | 6073 | 206933 | 2037 |
831333 | 831333 | 2020-12-15 | Clark | Nevada | 32003 | 144834 | 2037 |
503859 | 503859 | 2020-09-05 | Bergen | New Jersey | 34003 | 21997 | 2037 |
410232 | 410232 | 2020-08-07 | Bergen | New Jersey | 34003 | 20945 | 2037 |
407012 | 407012 | 2020-08-06 | Bergen | New Jersey | 34003 | 20920 | 2037 |
317381 | 317381 | 2020-07-09 | Suffolk | New York | 36103 | 41849 | 2037 |
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);