ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 1, fips = 29167 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
146702 | 146702 | 2020-05-15 | Polk | Missouri | 29167 | 1 | 0 |
143701 | 143701 | 2020-05-14 | Polk | Missouri | 29167 | 1 | 0 |
140706 | 140706 | 2020-05-13 | Polk | Missouri | 29167 | 1 | 0 |
137712 | 137712 | 2020-05-12 | Polk | Missouri | 29167 | 1 | 0 |
134722 | 134722 | 2020-05-11 | Polk | Missouri | 29167 | 1 | 0 |
131731 | 131731 | 2020-05-10 | Polk | Missouri | 29167 | 1 | 0 |
128741 | 128741 | 2020-05-09 | Polk | Missouri | 29167 | 1 | 0 |
125753 | 125753 | 2020-05-08 | Polk | Missouri | 29167 | 1 | 0 |
122771 | 122771 | 2020-05-07 | Polk | Missouri | 29167 | 1 | 0 |
119797 | 119797 | 2020-05-06 | Polk | Missouri | 29167 | 1 | 0 |
116837 | 116837 | 2020-05-05 | Polk | Missouri | 29167 | 1 | 0 |
113955 | 113955 | 2020-05-04 | Polk | Missouri | 29167 | 1 | 0 |
111076 | 111076 | 2020-05-03 | Polk | Missouri | 29167 | 1 | 0 |
108204 | 108204 | 2020-05-02 | Polk | Missouri | 29167 | 1 | 0 |
105339 | 105339 | 2020-05-01 | Polk | Missouri | 29167 | 1 | 0 |
102478 | 102478 | 2020-04-30 | Polk | Missouri | 29167 | 1 | 0 |
99626 | 99626 | 2020-04-29 | Polk | Missouri | 29167 | 1 | 0 |
96780 | 96780 | 2020-04-28 | Polk | Missouri | 29167 | 1 | 0 |
93944 | 93944 | 2020-04-27 | Polk | Missouri | 29167 | 1 | 0 |
91123 | 91123 | 2020-04-26 | Polk | Missouri | 29167 | 1 | 0 |
88307 | 88307 | 2020-04-25 | Polk | Missouri | 29167 | 1 | 0 |
85497 | 85497 | 2020-04-24 | Polk | Missouri | 29167 | 1 | 0 |
82693 | 82693 | 2020-04-23 | Polk | Missouri | 29167 | 1 | 0 |
79897 | 79897 | 2020-04-22 | Polk | Missouri | 29167 | 1 | 0 |
77110 | 77110 | 2020-04-21 | Polk | Missouri | 29167 | 1 | 0 |
74329 | 74329 | 2020-04-20 | Polk | Missouri | 29167 | 1 | 0 |
71556 | 71556 | 2020-04-19 | Polk | Missouri | 29167 | 1 | 0 |
68789 | 68789 | 2020-04-18 | Polk | Missouri | 29167 | 1 | 0 |
66035 | 66035 | 2020-04-17 | Polk | Missouri | 29167 | 1 | 0 |
63295 | 63295 | 2020-04-16 | Polk | Missouri | 29167 | 1 | 0 |
60573 | 60573 | 2020-04-15 | Polk | Missouri | 29167 | 1 | 0 |
57859 | 57859 | 2020-04-14 | Polk | Missouri | 29167 | 1 | 0 |
55161 | 55161 | 2020-04-13 | Polk | Missouri | 29167 | 1 | 0 |
52479 | 52479 | 2020-04-12 | Polk | Missouri | 29167 | 1 | 0 |
49806 | 49806 | 2020-04-11 | Polk | Missouri | 29167 | 1 | 0 |
47158 | 47158 | 2020-04-10 | Polk | Missouri | 29167 | 1 | 0 |
44549 | 44549 | 2020-04-09 | Polk | Missouri | 29167 | 1 | 0 |
41972 | 41972 | 2020-04-08 | Polk | Missouri | 29167 | 1 | 0 |
39418 | 39418 | 2020-04-07 | Polk | Missouri | 29167 | 1 | 0 |
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);