ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 1892 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Massachusetts 8
- Florida 7
- Pennsylvania 7
- California 5
- Minnesota 4
- Ohio 3
- Texas 2
- Georgia 1
- Indiana 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490174 | 2490174 | 2022-05-10 | Pasco | Florida | 12101 | 123993 | 1892 |
2486917 | 2486917 | 2022-05-09 | Pasco | Florida | 12101 | 123993 | 1892 |
2483659 | 2483659 | 2022-05-08 | Pasco | Florida | 12101 | 123993 | 1892 |
2480215 | 2480215 | 2022-05-07 | Alameda | California | 6001 | 279755 | 1892 |
2480401 | 2480401 | 2022-05-07 | Pasco | Florida | 12101 | 123993 | 1892 |
2476957 | 2476957 | 2022-05-06 | Alameda | California | 6001 | 279755 | 1892 |
2477143 | 2477143 | 2022-05-06 | Pasco | Florida | 12101 | 123993 | 1892 |
2473699 | 2473699 | 2022-05-05 | Alameda | California | 6001 | 278392 | 1892 |
2473885 | 2473885 | 2022-05-05 | Pasco | Florida | 12101 | 122821 | 1892 |
2470628 | 2470628 | 2022-05-04 | Pasco | Florida | 12101 | 122821 | 1892 |
2468240 | 2468240 | 2022-05-03 | Norfolk | Massachusetts | 25021 | 137557 | 1892 |
2453000 | 2453000 | 2022-04-28 | Bucks | Pennsylvania | 42017 | 124730 | 1892 |
2449744 | 2449744 | 2022-04-27 | Bucks | Pennsylvania | 42017 | 124613 | 1892 |
2446487 | 2446487 | 2022-04-26 | Bucks | Pennsylvania | 42017 | 124498 | 1892 |
2443232 | 2443232 | 2022-04-25 | Bucks | Pennsylvania | 42017 | 124397 | 1892 |
2439976 | 2439976 | 2022-04-24 | Bucks | Pennsylvania | 42017 | 124322 | 1892 |
2436720 | 2436720 | 2022-04-23 | Bucks | Pennsylvania | 42017 | 124245 | 1892 |
2225077 | 2225077 | 2022-02-17 | Hamilton | Ohio | 39061 | 184925 | 1892 |
2221826 | 2221826 | 2022-02-16 | Hamilton | Ohio | 39061 | 184793 | 1892 |
2218575 | 2218575 | 2022-02-15 | Hamilton | Ohio | 39061 | 184652 | 1892 |
2148110 | 2148110 | 2022-01-24 | Milwaukee | Wisconsin | 55079 | 256499 | 1892 |
2064060 | 2064060 | 2021-12-30 | Fulton | Georgia | 13121 | 158760 | 1892 |
1983591 | 1983591 | 2021-12-05 | Norfolk | Massachusetts | 25021 | 70012 | 1892 |
1980341 | 1980341 | 2021-12-04 | Norfolk | Massachusetts | 25021 | 70012 | 1892 |
1977091 | 1977091 | 2021-12-03 | Norfolk | Massachusetts | 25021 | 70012 | 1892 |
1899077 | 1899077 | 2021-11-09 | Bristol | Massachusetts | 25005 | 82672 | 1892 |
1804971 | 1804971 | 2021-10-11 | Hennepin | Minnesota | 27053 | 148887 | 1892 |
1801722 | 1801722 | 2021-10-10 | Hennepin | Minnesota | 27053 | 148439 | 1892 |
1798473 | 1798473 | 2021-10-09 | Hennepin | Minnesota | 27053 | 148439 | 1892 |
1795224 | 1795224 | 2021-10-08 | Hennepin | Minnesota | 27053 | 148439 | 1892 |
1778866 | 1778866 | 2021-10-03 | Suffolk | Massachusetts | 25025 | 104467 | 1892 |
1775616 | 1775616 | 2021-10-02 | Suffolk | Massachusetts | 25025 | 104467 | 1892 |
1772366 | 1772366 | 2021-10-01 | Suffolk | Massachusetts | 25025 | 104467 | 1892 |
1742082 | 1742082 | 2021-09-22 | Fresno | California | 6019 | 136665 | 1892 |
1654396 | 1654396 | 2021-08-26 | Sacramento | California | 6067 | 133044 | 1892 |
1602954 | 1602954 | 2021-08-10 | Marion | Indiana | 18097 | 108682 | 1892 |
942749 | 942749 | 2021-01-18 | Tarrant | Texas | 48439 | 195518 | 1892 |
685861 | 685861 | 2020-10-31 | Philadelphia | Pennsylvania | 42101 | 44505 | 1892 |
634367 | 634367 | 2020-10-15 | Hidalgo | Texas | 48215 | 33975 | 1892 |
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);