ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 1262 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- New Jersey 9
- Florida 7
- Massachusetts 4
- Texas 4
- California 3
- Maryland 3
- Colorado 2
- Washington 2
- Georgia 1
- Nevada 1
- New York 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2307862 | 2307862 | 2022-03-15 | Escambia | Florida | 12033 | 77709 | 1262 |
2304611 | 2304611 | 2022-03-14 | Escambia | Florida | 12033 | 77709 | 1262 |
2301359 | 2301359 | 2022-03-13 | Escambia | Florida | 12033 | 77709 | 1262 |
2298107 | 2298107 | 2022-03-12 | Escambia | Florida | 12033 | 77709 | 1262 |
2294855 | 2294855 | 2022-03-11 | Escambia | Florida | 12033 | 77709 | 1262 |
2291603 | 2291603 | 2022-03-10 | Escambia | Florida | 12033 | 77632 | 1262 |
2288351 | 2288351 | 2022-03-09 | Escambia | Florida | 12033 | 77632 | 1262 |
2268043 | 2268043 | 2022-03-02 | Montgomery | Texas | 48339 | 135419 | 1262 |
2219574 | 2219574 | 2022-02-15 | Spokane | Washington | 53063 | 120776 | 1262 |
2216324 | 2216324 | 2022-02-14 | Spokane | Washington | 53063 | 120776 | 1262 |
2190697 | 2190697 | 2022-02-07 | Tulare | California | 6107 | 124684 | 1262 |
2190702 | 2190702 | 2022-02-07 | Adams | Colorado | 8001 | 128319 | 1262 |
1984225 | 1984225 | 2021-12-05 | Monroe | New York | 36055 | 100650 | 1262 |
1969618 | 1969618 | 2021-12-01 | El Paso | Colorado | 8041 | 114989 | 1262 |
1871403 | 1871403 | 2021-10-31 | Nueces | Texas | 48355 | 61511 | 1262 |
1868154 | 1868154 | 2021-10-30 | Nueces | Texas | 48355 | 61511 | 1262 |
1864905 | 1864905 | 2021-10-29 | Nueces | Texas | 48355 | 61511 | 1262 |
1758366 | 1758366 | 2021-09-27 | Stanislaus | California | 6099 | 82039 | 1262 |
1714450 | 1714450 | 2021-09-13 | Morris | New Jersey | 34027 | 54654 | 1262 |
1677366 | 1677366 | 2021-09-02 | Gwinnett | Georgia | 13135 | 116664 | 1262 |
1541691 | 1541691 | 2021-07-22 | Baltimore city | Maryland | 24510 | 53398 | 1262 |
1538444 | 1538444 | 2021-07-21 | Baltimore city | Maryland | 24510 | 53380 | 1262 |
1266350 | 1266350 | 2021-04-28 | Camden | New Jersey | 34007 | 53565 | 1262 |
1263103 | 1263103 | 2021-04-27 | Camden | New Jersey | 34007 | 53423 | 1262 |
1009287 | 1009287 | 2021-02-08 | Prince George's | Maryland | 24033 | 69807 | 1262 |
985564 | 985564 | 2021-02-01 | Sacramento | California | 6067 | 86559 | 1262 |
987148 | 987148 | 2021-02-01 | Monmouth | New Jersey | 34025 | 49378 | 1262 |
983901 | 983901 | 2021-01-31 | Monmouth | New Jersey | 34025 | 49109 | 1262 |
863260 | 863260 | 2020-12-25 | Norfolk | Massachusetts | 25021 | 24655 | 1262 |
860015 | 860015 | 2020-12-24 | Norfolk | Massachusetts | 25021 | 24655 | 1262 |
691844 | 691844 | 2020-11-02 | Passaic | New Jersey | 34031 | 21524 | 1262 |
688600 | 688600 | 2020-11-01 | Passaic | New Jersey | 34031 | 21423 | 1262 |
685355 | 685355 | 2020-10-31 | Passaic | New Jersey | 34031 | 21296 | 1262 |
545361 | 545361 | 2020-09-18 | Essex | Massachusetts | 25009 | 18872 | 1262 |
542124 | 542124 | 2020-09-17 | Essex | Massachusetts | 25009 | 18815 | 1262 |
532945 | 532945 | 2020-09-14 | Clark | Nevada | 32003 | 62812 | 1262 |
260551 | 260551 | 2020-06-21 | Hudson | New Jersey | 34017 | 18744 | 1262 |
183710 | 183710 | 2020-05-27 | Philadelphia | Pennsylvania | 42101 | 21975 | 1262 |
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);