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

55 rows where deaths = 1318 sorted by date descending

✎ View and edit SQL

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

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2398153 2398153 2022-04-11 Lubbock Texas 48303 93499 1318
2394898 2394898 2022-04-10 Lubbock Texas 48303 93492 1318
2391642 2391642 2022-04-09 Lubbock Texas 48303 93491 1318
2388386 2388386 2022-04-08 Lubbock Texas 48303 93485 1318
2385131 2385131 2022-04-07 Lubbock Texas 48303 93465 1318
2381876 2381876 2022-04-06 Lubbock Texas 48303 93458 1318
2332875 2332875 2022-03-22 Knox Tennessee 47093 127369 1318
2329622 2329622 2022-03-21 Knox Tennessee 47093 127369 1318
2326370 2326370 2022-03-20 Knox Tennessee 47093 127369 1318
2323117 2323117 2022-03-19 Knox Tennessee 47093 127369 1318
2319863 2319863 2022-03-18 Knox Tennessee 47093 127369 1318
2316609 2316609 2022-03-17 Knox Tennessee 47093 127369 1318
2313356 2313356 2022-03-16 Knox Tennessee 47093 127369 1318
2287068 2287068 2022-03-08 Luzerne Pennsylvania 42079 73044 1318
2271587 2271587 2022-03-03 Pierce Washington 53053 188086 1318
2268335 2268335 2022-03-02 Pierce Washington 53053 188086 1318
2259066 2259066 2022-02-28 District of Columbia District of Columbia 11001 134564 1318
2241569 2241569 2022-02-22 Westmoreland Pennsylvania 42129 78672 1318
2238318 2238318 2022-02-21 Westmoreland Pennsylvania 42129 78579 1318
2235067 2235067 2022-02-20 Westmoreland Pennsylvania 42129 78579 1318
2065881 2065881 2021-12-30 Berks Pennsylvania 42011 75542 1318
1964657 1964657 2021-11-29 Morris New Jersey 34027 61163 1318
1961406 1961406 2021-11-28 Morris New Jersey 34027 61007 1318
1958155 1958155 2021-11-27 Morris New Jersey 34027 60883 1318
1954904 1954904 2021-11-26 Morris New Jersey 34027 60734 1318
1951653 1951653 2021-11-25 Morris New Jersey 34027 60620 1318
1948402 1948402 2021-11-24 Morris New Jersey 34027 60443 1318
1808075 1808075 2021-10-12 Baltimore city Maryland 24510 60367 1318
1754484 1754484 2021-09-25 Travis Texas 48453 114060 1318
1737480 1737480 2021-09-20 Hamilton Ohio 39061 96791 1318
1734230 1734230 2021-09-19 Hamilton Ohio 39061 96550 1318
1730980 1730980 2021-09-18 Hamilton Ohio 39061 96279 1318
1727730 1727730 2021-09-17 Hamilton Ohio 39061 95838 1318
1429137 1429137 2021-06-17 Bucks Pennsylvania 42017 60756 1318
1412431 1412431 2021-06-12 Camden New Jersey 34007 55725 1318
1409186 1409186 2021-06-11 Camden New Jersey 34007 55714 1318
1395466 1395466 2021-06-07 Jefferson Kentucky 21111 82942 1318
1225534 1225534 2021-04-15 Milwaukee Wisconsin 55079 112634 1318
1222287 1222287 2021-04-14 Milwaukee Wisconsin 55079 112451 1318
1219039 1219039 2021-04-13 Milwaukee Wisconsin 55079 112254 1318
1199942 1199942 2021-04-08 Duval Florida 12031 93616 1318
1187233 1187233 2021-04-04 DuPage Illinois 17043 82864 1318
1183986 1183986 2021-04-03 DuPage Illinois 17043 82635 1318
1126121 1126121 2021-03-16 Baltimore Maryland 24005 52970 1318
1090445 1090445 2021-03-05 Plymouth Massachusetts 25023 40758 1318
1008287 1008287 2021-02-08 Sacramento California 6067 88918 1318
892467 892467 2021-01-03 Norfolk Massachusetts 25021 28388 1318
850395 850395 2020-12-21 Hennepin Minnesota 27053 83133 1318
807161 807161 2020-12-08 New Haven Connecticut 9009 35321 1318
791914 791914 2020-12-03 Macomb Michigan 26099 40060 1318
708931 708931 2020-11-07 Dallas Texas 48113 108631 1318
632870 632870 2020-10-15 Essex Massachusetts 25009 21619 1318
588879 588879 2020-10-01 Bexar Texas 48029 57948 1318
398284 398284 2020-08-03 Harris Texas 48201 78105 1318
282524 282524 2020-06-28 Middlesex New Jersey 34023 16964 1318

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