ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

17,792 rows where deaths = 28 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2499845 2499845 2022-05-13 Grand Colorado 8049 3599 28
2499881 2499881 2022-05-13 Washington Colorado 8121 1066 28
2500147 2500147 2022-05-13 Caribou Idaho 16029 1495 28
2500154 2500154 2022-05-13 Fremont Idaho 16043 2158 28
2500212 2500212 2022-05-13 Henderson Illinois 17071 1166 28
2500520 2500520 2022-05-13 Kingman Kansas 20095 1967 28
2500526 2500526 2022-05-13 Linn Kansas 20107 2827 28
2500536 2500536 2022-05-13 Morris Kansas 20127 1513 28
2500569 2500569 2022-05-13 Thomas Kansas 20193 2394 28
2500666 2500666 2022-05-13 Morgan Kentucky 21175 5272 28
2500697 2500697 2022-05-13 Wolfe Kentucky 21237 2531 28
2500942 2500942 2022-05-13 Lake Minnesota 27075 2138 28
2501164 2501164 2022-05-13 Ralls Missouri 29173 2470 28
2501197 2501197 2022-05-13 Carbon Montana 30009 2080 28
2501228 2501228 2022-05-13 Phillips Montana 30071 1060 28
2501554 2501554 2022-05-13 Pamlico North Carolina 37137 2630 28
2501622 2501622 2022-05-13 Ransom North Dakota 38073 1515 28
2502083 2502083 2022-05-13 Lake South Dakota 46079 2335 28
2502094 2502094 2022-05-13 Moody South Dakota 46101 1386 28
2502211 2502211 2022-05-13 Archer Texas 48009 2213 28
2502291 2502291 2022-05-13 Garza Texas 48169 1279 28
2502325 2502325 2022-05-13 Jack Texas 48237 1523 28
2502469 2502469 2022-05-13 Emery Utah 49015 2486 28
2502664 2502664 2022-05-13 Lincoln Washington 53043 2224 28
2502749 2502749 2022-05-13 Crawford Wisconsin 55023 4299 28
2496587 2496587 2022-05-12 Grand Colorado 8049 3599 28
2496623 2496623 2022-05-12 Washington Colorado 8121 1065 28
2496889 2496889 2022-05-12 Caribou Idaho 16029 1495 28
2496896 2496896 2022-05-12 Fremont Idaho 16043 2158 28
2496954 2496954 2022-05-12 Henderson Illinois 17071 1165 28
2497262 2497262 2022-05-12 Kingman Kansas 20095 1966 28
2497268 2497268 2022-05-12 Linn Kansas 20107 2825 28
2497278 2497278 2022-05-12 Morris Kansas 20127 1512 28
2497311 2497311 2022-05-12 Thomas Kansas 20193 2393 28
2497408 2497408 2022-05-12 Morgan Kentucky 21175 5272 28
2497439 2497439 2022-05-12 Wolfe Kentucky 21237 2531 28
2497684 2497684 2022-05-12 Lake Minnesota 27075 2135 28
2497906 2497906 2022-05-12 Ralls Missouri 29173 2463 28
2497939 2497939 2022-05-12 Carbon Montana 30009 2076 28
2497970 2497970 2022-05-12 Phillips Montana 30071 1060 28
2498296 2498296 2022-05-12 Pamlico North Carolina 37137 2630 28
2498364 2498364 2022-05-12 Ransom North Dakota 38073 1504 28
2498825 2498825 2022-05-12 Lake South Dakota 46079 2335 28
2498836 2498836 2022-05-12 Moody South Dakota 46101 1386 28
2498953 2498953 2022-05-12 Archer Texas 48009 2212 28
2499033 2499033 2022-05-12 Garza Texas 48169 1279 28
2499067 2499067 2022-05-12 Jack Texas 48237 1522 28
2499211 2499211 2022-05-12 Emery Utah 49015 2486 28
2499406 2499406 2022-05-12 Lincoln Washington 53043 2219 28
2499491 2499491 2022-05-12 Crawford Wisconsin 55023 4291 28
2493329 2493329 2022-05-11 Grand Colorado 8049 3596 28
2493365 2493365 2022-05-11 Washington Colorado 8121 1063 28
2493631 2493631 2022-05-11 Caribou Idaho 16029 1495 28
2493638 2493638 2022-05-11 Fremont Idaho 16043 2158 28
2493696 2493696 2022-05-11 Henderson Illinois 17071 1163 28
2494004 2494004 2022-05-11 Kingman Kansas 20095 1966 28
2494010 2494010 2022-05-11 Linn Kansas 20107 2825 28
2494020 2494020 2022-05-11 Morris Kansas 20127 1512 28
2494053 2494053 2022-05-11 Thomas Kansas 20193 2393 28
2494150 2494150 2022-05-11 Morgan Kentucky 21175 5272 28
2494181 2494181 2022-05-11 Wolfe Kentucky 21237 2531 28
2494286 2494286 2022-05-11 Unknown Maryland   0 28
2494426 2494426 2022-05-11 Lake Minnesota 27075 2127 28
2494648 2494648 2022-05-11 Ralls Missouri 29173 2463 28
2494681 2494681 2022-05-11 Carbon Montana 30009 2076 28
2494712 2494712 2022-05-11 Phillips Montana 30071 1060 28
2495038 2495038 2022-05-11 Pamlico North Carolina 37137 2630 28
2495106 2495106 2022-05-11 Ransom North Dakota 38073 1504 28
2495567 2495567 2022-05-11 Lake South Dakota 46079 2335 28
2495578 2495578 2022-05-11 Moody South Dakota 46101 1386 28
2495695 2495695 2022-05-11 Archer Texas 48009 2206 28
2495775 2495775 2022-05-11 Garza Texas 48169 1277 28
2495809 2495809 2022-05-11 Jack Texas 48237 1519 28
2495953 2495953 2022-05-11 Emery Utah 49015 2486 28
2496148 2496148 2022-05-11 Lincoln Washington 53043 2219 28
2496233 2496233 2022-05-11 Crawford Wisconsin 55023 4286 28
2490071 2490071 2022-05-10 Grand Colorado 8049 3593 28
2490107 2490107 2022-05-10 Washington Colorado 8121 1063 28
2490373 2490373 2022-05-10 Caribou Idaho 16029 1495 28
2490380 2490380 2022-05-10 Fremont Idaho 16043 2157 28
2490438 2490438 2022-05-10 Henderson Illinois 17071 1160 28
2490746 2490746 2022-05-10 Kingman Kansas 20095 1966 28
2490752 2490752 2022-05-10 Linn Kansas 20107 2825 28
2490762 2490762 2022-05-10 Morris Kansas 20127 1512 28
2490795 2490795 2022-05-10 Thomas Kansas 20193 2393 28
2490892 2490892 2022-05-10 Morgan Kentucky 21175 5272 28
2490923 2490923 2022-05-10 Wolfe Kentucky 21237 2531 28
2491168 2491168 2022-05-10 Lake Minnesota 27075 2123 28
2491390 2491390 2022-05-10 Ralls Missouri 29173 2463 28
2491423 2491423 2022-05-10 Carbon Montana 30009 2076 28
2491454 2491454 2022-05-10 Phillips Montana 30071 1060 28
2491780 2491780 2022-05-10 Pamlico North Carolina 37137 2616 28
2491848 2491848 2022-05-10 Ransom North Dakota 38073 1504 28
2492309 2492309 2022-05-10 Lake South Dakota 46079 2333 28
2492320 2492320 2022-05-10 Moody South Dakota 46101 1380 28
2492437 2492437 2022-05-10 Archer Texas 48009 2206 28
2492517 2492517 2022-05-10 Garza Texas 48169 1277 28
2492551 2492551 2022-05-10 Jack Texas 48237 1518 28
2492695 2492695 2022-05-10 Emery Utah 49015 2485 28
2492884 2492884 2022-05-10 Jefferson Washington 53031 3159 28

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);