ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 1403 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- New Jersey 8
- Illinois 7
- Connecticut 4
- Pennsylvania 4
- Alabama 3
- Massachusetts 3
- Arizona 1
- California 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2265897 | 2265897 | 2022-03-02 | Lake | Illinois | 17097 | 147328 | 1403 |
2262646 | 2262646 | 2022-03-01 | Lake | Illinois | 17097 | 147185 | 1403 |
2205806 | 2205806 | 2022-02-11 | York | Pennsylvania | 42133 | 116225 | 1403 |
2202553 | 2202553 | 2022-02-10 | York | Pennsylvania | 42133 | 116070 | 1403 |
2199299 | 2199299 | 2022-02-09 | York | Pennsylvania | 42133 | 115909 | 1403 |
2135254 | 2135254 | 2022-01-21 | Pinal | Arizona | 4021 | 108340 | 1403 |
2134793 | 2134793 | 2022-01-20 | Salt Lake | Utah | 49035 | 303451 | 1403 |
1815638 | 1815638 | 2021-10-14 | Bucks | Pennsylvania | 42017 | 71400 | 1403 |
1772921 | 1772921 | 2021-10-01 | Camden | New Jersey | 34007 | 65164 | 1403 |
1440474 | 1440474 | 2021-06-21 | DuPage | Illinois | 17043 | 92413 | 1403 |
1417751 | 1417751 | 2021-06-14 | DuPage | Illinois | 17043 | 92318 | 1403 |
1414505 | 1414505 | 2021-06-13 | DuPage | Illinois | 17043 | 92309 | 1403 |
1411260 | 1411260 | 2021-06-12 | DuPage | Illinois | 17043 | 92297 | 1403 |
1408015 | 1408015 | 2021-06-11 | DuPage | Illinois | 17043 | 92281 | 1403 |
1349196 | 1349196 | 2021-05-24 | San Joaquin | California | 6077 | 73617 | 1403 |
1098983 | 1098983 | 2021-03-08 | Jefferson | Alabama | 1073 | 72082 | 1403 |
1095735 | 1095735 | 2021-03-07 | Jefferson | Alabama | 1073 | 72033 | 1403 |
1092489 | 1092489 | 2021-03-06 | Jefferson | Alabama | 1073 | 71995 | 1403 |
1015788 | 1015788 | 2021-02-10 | Bristol | Massachusetts | 25005 | 53011 | 1403 |
947638 | 947638 | 2021-01-20 | Norfolk | Massachusetts | 25021 | 36130 | 1403 |
743171 | 743171 | 2020-11-18 | Essex | Massachusetts | 25009 | 29983 | 1403 |
419903 | 419903 | 2020-08-10 | Middlesex | New Jersey | 34023 | 18136 | 1403 |
416683 | 416683 | 2020-08-09 | Middlesex | New Jersey | 34023 | 18123 | 1403 |
413462 | 413462 | 2020-08-08 | Middlesex | New Jersey | 34023 | 18088 | 1403 |
400585 | 400585 | 2020-08-04 | Middlesex | New Jersey | 34023 | 17971 | 1403 |
397370 | 397370 | 2020-08-03 | Middlesex | New Jersey | 34023 | 17941 | 1403 |
384503 | 384503 | 2020-07-30 | Middlesex | New Jersey | 34023 | 17832 | 1403 |
381285 | 381285 | 2020-07-29 | Middlesex | New Jersey | 34023 | 17821 | 1403 |
376594 | 376594 | 2020-07-28 | Fairfield | Connecticut | 9001 | 17494 | 1403 |
347734 | 347734 | 2020-07-19 | Hartford | Connecticut | 9003 | 12046 | 1403 |
344534 | 344534 | 2020-07-18 | Hartford | Connecticut | 9003 | 12046 | 1403 |
341335 | 341335 | 2020-07-17 | Hartford | Connecticut | 9003 | 12046 | 1403 |
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);