ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Madison" and state = "Missouri" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
36888 | 36888 | 2020-04-06 | Madison | Missouri | 29123 | 1 | 0 |
39401 | 39401 | 2020-04-07 | Madison | Missouri | 29123 | 1 | 0 |
41955 | 41955 | 2020-04-08 | Madison | Missouri | 29123 | 1 | 0 |
44532 | 44532 | 2020-04-09 | Madison | Missouri | 29123 | 1 | 0 |
47141 | 47141 | 2020-04-10 | Madison | Missouri | 29123 | 1 | 0 |
49789 | 49789 | 2020-04-11 | Madison | Missouri | 29123 | 1 | 0 |
52462 | 52462 | 2020-04-12 | Madison | Missouri | 29123 | 1 | 0 |
55144 | 55144 | 2020-04-13 | Madison | Missouri | 29123 | 1 | 0 |
57842 | 57842 | 2020-04-14 | Madison | Missouri | 29123 | 1 | 0 |
60555 | 60555 | 2020-04-15 | Madison | Missouri | 29123 | 1 | 0 |
63277 | 63277 | 2020-04-16 | Madison | Missouri | 29123 | 1 | 0 |
66017 | 66017 | 2020-04-17 | Madison | Missouri | 29123 | 1 | 0 |
68770 | 68770 | 2020-04-18 | Madison | Missouri | 29123 | 1 | 0 |
71537 | 71537 | 2020-04-19 | Madison | Missouri | 29123 | 1 | 0 |
74310 | 74310 | 2020-04-20 | Madison | Missouri | 29123 | 1 | 0 |
77091 | 77091 | 2020-04-21 | Madison | Missouri | 29123 | 1 | 0 |
79877 | 79877 | 2020-04-22 | Madison | Missouri | 29123 | 1 | 0 |
82673 | 82673 | 2020-04-23 | Madison | Missouri | 29123 | 1 | 0 |
85477 | 85477 | 2020-04-24 | Madison | Missouri | 29123 | 1 | 0 |
88287 | 88287 | 2020-04-25 | Madison | Missouri | 29123 | 1 | 0 |
91103 | 91103 | 2020-04-26 | Madison | Missouri | 29123 | 1 | 0 |
93924 | 93924 | 2020-04-27 | Madison | Missouri | 29123 | 1 | 0 |
96760 | 96760 | 2020-04-28 | Madison | Missouri | 29123 | 1 | 0 |
99606 | 99606 | 2020-04-29 | Madison | Missouri | 29123 | 1 | 0 |
102458 | 102458 | 2020-04-30 | Madison | Missouri | 29123 | 1 | 0 |
105319 | 105319 | 2020-05-01 | Madison | Missouri | 29123 | 1 | 0 |
108184 | 108184 | 2020-05-02 | Madison | Missouri | 29123 | 1 | 0 |
111056 | 111056 | 2020-05-03 | Madison | Missouri | 29123 | 1 | 0 |
113935 | 113935 | 2020-05-04 | Madison | Missouri | 29123 | 1 | 0 |
116817 | 116817 | 2020-05-05 | Madison | Missouri | 29123 | 2 | 0 |
119777 | 119777 | 2020-05-06 | Madison | Missouri | 29123 | 2 | 0 |
122751 | 122751 | 2020-05-07 | Madison | Missouri | 29123 | 2 | 0 |
125733 | 125733 | 2020-05-08 | Madison | Missouri | 29123 | 2 | 0 |
128721 | 128721 | 2020-05-09 | Madison | Missouri | 29123 | 3 | 0 |
131711 | 131711 | 2020-05-10 | Madison | Missouri | 29123 | 3 | 0 |
134702 | 134702 | 2020-05-11 | Madison | Missouri | 29123 | 3 | 0 |
137692 | 137692 | 2020-05-12 | Madison | Missouri | 29123 | 3 | 0 |
140686 | 140686 | 2020-05-13 | Madison | Missouri | 29123 | 3 | 0 |
143681 | 143681 | 2020-05-14 | Madison | Missouri | 29123 | 3 | 0 |
146682 | 146682 | 2020-05-15 | Madison | Missouri | 29123 | 3 | 0 |
149687 | 149687 | 2020-05-16 | Madison | Missouri | 29123 | 3 | 0 |
152698 | 152698 | 2020-05-17 | Madison | Missouri | 29123 | 3 | 0 |
155712 | 155712 | 2020-05-18 | Madison | Missouri | 29123 | 3 | 0 |
158730 | 158730 | 2020-05-19 | Madison | Missouri | 29123 | 3 | 0 |
161756 | 161756 | 2020-05-20 | Madison | Missouri | 29123 | 3 | 0 |
164785 | 164785 | 2020-05-21 | Madison | Missouri | 29123 | 3 | 0 |
167821 | 167821 | 2020-05-22 | Madison | Missouri | 29123 | 3 | 0 |
170860 | 170860 | 2020-05-23 | Madison | Missouri | 29123 | 3 | 0 |
173902 | 173902 | 2020-05-24 | Madison | Missouri | 29123 | 3 | 0 |
176945 | 176945 | 2020-05-25 | Madison | Missouri | 29123 | 3 | 0 |
179989 | 179989 | 2020-05-26 | Madison | Missouri | 29123 | 3 | 0 |
183035 | 183035 | 2020-05-27 | Madison | Missouri | 29123 | 3 | 0 |
186091 | 186091 | 2020-05-28 | Madison | Missouri | 29123 | 3 | 0 |
189149 | 189149 | 2020-05-29 | Madison | Missouri | 29123 | 3 | 0 |
192213 | 192213 | 2020-05-30 | Madison | Missouri | 29123 | 3 | 0 |
195282 | 195282 | 2020-05-31 | Madison | Missouri | 29123 | 3 | 0 |
198353 | 198353 | 2020-06-01 | Madison | Missouri | 29123 | 3 | 0 |
201426 | 201426 | 2020-06-02 | Madison | Missouri | 29123 | 3 | 0 |
204503 | 204503 | 2020-06-03 | Madison | Missouri | 29123 | 3 | 0 |
207584 | 207584 | 2020-06-04 | Madison | Missouri | 29123 | 3 | 0 |
210665 | 210665 | 2020-06-05 | Madison | Missouri | 29123 | 3 | 0 |
213749 | 213749 | 2020-06-06 | Madison | Missouri | 29123 | 3 | 0 |
216837 | 216837 | 2020-06-07 | Madison | Missouri | 29123 | 3 | 0 |
219929 | 219929 | 2020-06-08 | Madison | Missouri | 29123 | 3 | 0 |
223024 | 223024 | 2020-06-09 | Madison | Missouri | 29123 | 3 | 0 |
226123 | 226123 | 2020-06-10 | Madison | Missouri | 29123 | 3 | 0 |
229226 | 229226 | 2020-06-11 | Madison | Missouri | 29123 | 3 | 0 |
232330 | 232330 | 2020-06-12 | Madison | Missouri | 29123 | 3 | 0 |
235436 | 235436 | 2020-06-13 | Madison | Missouri | 29123 | 3 | 0 |
238543 | 238543 | 2020-06-14 | Madison | Missouri | 29123 | 3 | 0 |
241653 | 241653 | 2020-06-15 | Madison | Missouri | 29123 | 3 | 0 |
244764 | 244764 | 2020-06-16 | Madison | Missouri | 29123 | 3 | 0 |
247877 | 247877 | 2020-06-17 | Madison | Missouri | 29123 | 3 | 0 |
250990 | 250990 | 2020-06-18 | Madison | Missouri | 29123 | 3 | 0 |
254105 | 254105 | 2020-06-19 | Madison | Missouri | 29123 | 3 | 0 |
257225 | 257225 | 2020-06-20 | Madison | Missouri | 29123 | 3 | 0 |
260351 | 260351 | 2020-06-21 | Madison | Missouri | 29123 | 3 | 0 |
263479 | 263479 | 2020-06-22 | Madison | Missouri | 29123 | 3 | 0 |
266605 | 266605 | 2020-06-23 | Madison | Missouri | 29123 | 3 | 0 |
269738 | 269738 | 2020-06-24 | Madison | Missouri | 29123 | 3 | 0 |
272877 | 272877 | 2020-06-25 | Madison | Missouri | 29123 | 3 | 0 |
276020 | 276020 | 2020-06-26 | Madison | Missouri | 29123 | 3 | 0 |
279168 | 279168 | 2020-06-27 | Madison | Missouri | 29123 | 4 | 0 |
282316 | 282316 | 2020-06-28 | Madison | Missouri | 29123 | 5 | 0 |
285461 | 285461 | 2020-06-29 | Madison | Missouri | 29123 | 6 | 0 |
288611 | 288611 | 2020-06-30 | Madison | Missouri | 29123 | 6 | 0 |
291762 | 291762 | 2020-07-01 | Madison | Missouri | 29123 | 6 | 0 |
294916 | 294916 | 2020-07-02 | Madison | Missouri | 29123 | 6 | 0 |
298074 | 298074 | 2020-07-03 | Madison | Missouri | 29123 | 6 | 0 |
301237 | 301237 | 2020-07-04 | Madison | Missouri | 29123 | 7 | 0 |
304401 | 304401 | 2020-07-05 | Madison | Missouri | 29123 | 7 | 0 |
307568 | 307568 | 2020-07-06 | Madison | Missouri | 29123 | 7 | 0 |
310736 | 310736 | 2020-07-07 | Madison | Missouri | 29123 | 7 | 0 |
313907 | 313907 | 2020-07-08 | Madison | Missouri | 29123 | 7 | 0 |
317081 | 317081 | 2020-07-09 | Madison | Missouri | 29123 | 7 | 0 |
320256 | 320256 | 2020-07-10 | Madison | Missouri | 29123 | 7 | 0 |
323435 | 323435 | 2020-07-11 | Madison | Missouri | 29123 | 7 | 0 |
326618 | 326618 | 2020-07-12 | Madison | Missouri | 29123 | 7 | 0 |
329804 | 329804 | 2020-07-13 | Madison | Missouri | 29123 | 7 | 0 |
332991 | 332991 | 2020-07-14 | Madison | Missouri | 29123 | 7 | 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);