ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 20, fips = 18111 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
904969 | 904969 | 2021-01-07 | Newton | Indiana | 18111 | 855 | 20 |
901724 | 901724 | 2021-01-06 | Newton | Indiana | 18111 | 847 | 20 |
898479 | 898479 | 2021-01-05 | Newton | Indiana | 18111 | 846 | 20 |
895234 | 895234 | 2021-01-04 | Newton | Indiana | 18111 | 845 | 20 |
891987 | 891987 | 2021-01-03 | Newton | Indiana | 18111 | 840 | 20 |
888741 | 888741 | 2021-01-02 | Newton | Indiana | 18111 | 837 | 20 |
885495 | 885495 | 2021-01-01 | Newton | Indiana | 18111 | 833 | 20 |
882250 | 882250 | 2020-12-31 | Newton | Indiana | 18111 | 831 | 20 |
879005 | 879005 | 2020-12-30 | Newton | Indiana | 18111 | 822 | 20 |
875760 | 875760 | 2020-12-29 | Newton | Indiana | 18111 | 817 | 20 |
872515 | 872515 | 2020-12-28 | Newton | Indiana | 18111 | 813 | 20 |
869270 | 869270 | 2020-12-27 | Newton | Indiana | 18111 | 810 | 20 |
866025 | 866025 | 2020-12-26 | Newton | Indiana | 18111 | 810 | 20 |
862780 | 862780 | 2020-12-25 | Newton | Indiana | 18111 | 808 | 20 |
859535 | 859535 | 2020-12-24 | Newton | Indiana | 18111 | 805 | 20 |
856290 | 856290 | 2020-12-23 | Newton | Indiana | 18111 | 801 | 20 |
853045 | 853045 | 2020-12-22 | Newton | Indiana | 18111 | 792 | 20 |
849800 | 849800 | 2020-12-21 | Newton | Indiana | 18111 | 791 | 20 |
846555 | 846555 | 2020-12-20 | Newton | Indiana | 18111 | 780 | 20 |
843309 | 843309 | 2020-12-19 | Newton | Indiana | 18111 | 776 | 20 |
840064 | 840064 | 2020-12-18 | Newton | Indiana | 18111 | 770 | 20 |
836819 | 836819 | 2020-12-17 | Newton | Indiana | 18111 | 763 | 20 |
833573 | 833573 | 2020-12-16 | Newton | Indiana | 18111 | 751 | 20 |
830326 | 830326 | 2020-12-15 | Newton | Indiana | 18111 | 745 | 20 |
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);