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

18 rows where county = "Montgomery" and date = "2021-06-04" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

fips 18

county 1

  • Montgomery · 18 ✖
Link rowid date ▲ county state fips cases deaths
1384726 1384726 2021-06-04 Montgomery Alabama 1101 25015 606
1384834 1384834 2021-06-04 Montgomery Arkansas 5097 759 33
1385168 1385168 2021-06-04 Montgomery Georgia 13209 900 22
1385343 1385343 2021-06-04 Montgomery Illinois 17135 3780 80
1385432 1385432 2021-06-04 Montgomery Indiana 18107 4306 91
1385539 1385539 2021-06-04 Montgomery Iowa 19137 1036 38
1385633 1385633 2021-06-04 Montgomery Kansas 20125 3475 82
1385762 1385762 2021-06-04 Montgomery Kentucky 21173 2819 30
1385892 1385892 2021-06-04 Montgomery Maryland 24031 71009 1606
1386137 1386137 2021-06-04 Montgomery Mississippi 28097 1286 43
1386242 1386242 2021-06-04 Montgomery Missouri 29139 1048 12
1386546 1386546 2021-06-04 Montgomery New York 36057 4251 124
1386639 1386639 2021-06-04 Montgomery North Carolina 37123 3355 96
1386790 1386790 2021-06-04 Montgomery Ohio 39113 52326 1033
1386982 1386982 2021-06-04 Montgomery Pennsylvania 42091 70163 1720
1387263 1387263 2021-06-04 Montgomery Tennessee 47125 20753 229
1387466 1387466 2021-06-04 Montgomery Texas 48339 54643 590
1387680 1387680 2021-06-04 Montgomery Virginia 51121 9412 96

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