ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 29143 and state = "Missouri" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
27300 | 27300 | 2020-04-02 | New Madrid | Missouri | 29143 | 1 | 0 |
29621 | 29621 | 2020-04-03 | New Madrid | Missouri | 29143 | 1 | 0 |
32001 | 32001 | 2020-04-04 | New Madrid | Missouri | 29143 | 1 | 0 |
34429 | 34429 | 2020-04-05 | New Madrid | Missouri | 29143 | 1 | 0 |
36894 | 36894 | 2020-04-06 | New Madrid | Missouri | 29143 | 2 | 0 |
39407 | 39407 | 2020-04-07 | New Madrid | Missouri | 29143 | 5 | 0 |
41961 | 41961 | 2020-04-08 | New Madrid | Missouri | 29143 | 5 | 0 |
44538 | 44538 | 2020-04-09 | New Madrid | Missouri | 29143 | 6 | 0 |
47147 | 47147 | 2020-04-10 | New Madrid | Missouri | 29143 | 6 | 0 |
49795 | 49795 | 2020-04-11 | New Madrid | Missouri | 29143 | 6 | 0 |
52468 | 52468 | 2020-04-12 | New Madrid | Missouri | 29143 | 8 | 0 |
55150 | 55150 | 2020-04-13 | New Madrid | Missouri | 29143 | 8 | 0 |
57848 | 57848 | 2020-04-14 | New Madrid | Missouri | 29143 | 8 | 0 |
60562 | 60562 | 2020-04-15 | New Madrid | Missouri | 29143 | 8 | 0 |
63284 | 63284 | 2020-04-16 | New Madrid | Missouri | 29143 | 8 | 0 |
66024 | 66024 | 2020-04-17 | New Madrid | Missouri | 29143 | 8 | 0 |
68778 | 68778 | 2020-04-18 | New Madrid | Missouri | 29143 | 8 | 0 |
71545 | 71545 | 2020-04-19 | New Madrid | Missouri | 29143 | 9 | 0 |
74318 | 74318 | 2020-04-20 | New Madrid | Missouri | 29143 | 9 | 0 |
77099 | 77099 | 2020-04-21 | New Madrid | Missouri | 29143 | 9 | 0 |
79886 | 79886 | 2020-04-22 | New Madrid | Missouri | 29143 | 9 | 0 |
82682 | 82682 | 2020-04-23 | New Madrid | Missouri | 29143 | 9 | 0 |
85486 | 85486 | 2020-04-24 | New Madrid | Missouri | 29143 | 9 | 0 |
88296 | 88296 | 2020-04-25 | New Madrid | Missouri | 29143 | 9 | 0 |
91112 | 91112 | 2020-04-26 | New Madrid | Missouri | 29143 | 9 | 0 |
93933 | 93933 | 2020-04-27 | New Madrid | Missouri | 29143 | 9 | 0 |
96769 | 96769 | 2020-04-28 | New Madrid | Missouri | 29143 | 9 | 0 |
99615 | 99615 | 2020-04-29 | New Madrid | Missouri | 29143 | 9 | 0 |
102467 | 102467 | 2020-04-30 | New Madrid | Missouri | 29143 | 9 | 0 |
105328 | 105328 | 2020-05-01 | New Madrid | Missouri | 29143 | 9 | 0 |
108193 | 108193 | 2020-05-02 | New Madrid | Missouri | 29143 | 10 | 0 |
111065 | 111065 | 2020-05-03 | New Madrid | Missouri | 29143 | 10 | 0 |
113944 | 113944 | 2020-05-04 | New Madrid | Missouri | 29143 | 11 | 0 |
116826 | 116826 | 2020-05-05 | New Madrid | Missouri | 29143 | 11 | 0 |
119786 | 119786 | 2020-05-06 | New Madrid | Missouri | 29143 | 11 | 0 |
122760 | 122760 | 2020-05-07 | New Madrid | Missouri | 29143 | 11 | 0 |
125742 | 125742 | 2020-05-08 | New Madrid | Missouri | 29143 | 11 | 0 |
128730 | 128730 | 2020-05-09 | New Madrid | Missouri | 29143 | 12 | 0 |
131720 | 131720 | 2020-05-10 | New Madrid | Missouri | 29143 | 12 | 0 |
134711 | 134711 | 2020-05-11 | New Madrid | Missouri | 29143 | 12 | 0 |
137701 | 137701 | 2020-05-12 | New Madrid | Missouri | 29143 | 13 | 0 |
140695 | 140695 | 2020-05-13 | New Madrid | Missouri | 29143 | 13 | 0 |
143690 | 143690 | 2020-05-14 | New Madrid | Missouri | 29143 | 13 | 0 |
146691 | 146691 | 2020-05-15 | New Madrid | Missouri | 29143 | 13 | 0 |
149696 | 149696 | 2020-05-16 | New Madrid | Missouri | 29143 | 14 | 0 |
152707 | 152707 | 2020-05-17 | New Madrid | Missouri | 29143 | 14 | 0 |
155721 | 155721 | 2020-05-18 | New Madrid | Missouri | 29143 | 14 | 1 |
158739 | 158739 | 2020-05-19 | New Madrid | Missouri | 29143 | 14 | 1 |
161765 | 161765 | 2020-05-20 | New Madrid | Missouri | 29143 | 14 | 1 |
164794 | 164794 | 2020-05-21 | New Madrid | Missouri | 29143 | 14 | 1 |
167830 | 167830 | 2020-05-22 | New Madrid | Missouri | 29143 | 15 | 1 |
170869 | 170869 | 2020-05-23 | New Madrid | Missouri | 29143 | 17 | 1 |
173911 | 173911 | 2020-05-24 | New Madrid | Missouri | 29143 | 17 | 1 |
176954 | 176954 | 2020-05-25 | New Madrid | Missouri | 29143 | 17 | 1 |
179998 | 179998 | 2020-05-26 | New Madrid | Missouri | 29143 | 17 | 1 |
183045 | 183045 | 2020-05-27 | New Madrid | Missouri | 29143 | 17 | 1 |
186101 | 186101 | 2020-05-28 | New Madrid | Missouri | 29143 | 19 | 1 |
189159 | 189159 | 2020-05-29 | New Madrid | Missouri | 29143 | 20 | 1 |
192223 | 192223 | 2020-05-30 | New Madrid | Missouri | 29143 | 21 | 1 |
195293 | 195293 | 2020-05-31 | New Madrid | Missouri | 29143 | 21 | 1 |
198364 | 198364 | 2020-06-01 | New Madrid | Missouri | 29143 | 21 | 1 |
201437 | 201437 | 2020-06-02 | New Madrid | Missouri | 29143 | 21 | 1 |
204514 | 204514 | 2020-06-03 | New Madrid | Missouri | 29143 | 21 | 1 |
207595 | 207595 | 2020-06-04 | New Madrid | Missouri | 29143 | 21 | 1 |
210676 | 210676 | 2020-06-05 | New Madrid | Missouri | 29143 | 21 | 1 |
213760 | 213760 | 2020-06-06 | New Madrid | Missouri | 29143 | 21 | 1 |
216848 | 216848 | 2020-06-07 | New Madrid | Missouri | 29143 | 21 | 1 |
219940 | 219940 | 2020-06-08 | New Madrid | Missouri | 29143 | 22 | 1 |
223035 | 223035 | 2020-06-09 | New Madrid | Missouri | 29143 | 23 | 1 |
226134 | 226134 | 2020-06-10 | New Madrid | Missouri | 29143 | 24 | 1 |
229237 | 229237 | 2020-06-11 | New Madrid | Missouri | 29143 | 28 | 1 |
232341 | 232341 | 2020-06-12 | New Madrid | Missouri | 29143 | 32 | 1 |
235447 | 235447 | 2020-06-13 | New Madrid | Missouri | 29143 | 35 | 1 |
238554 | 238554 | 2020-06-14 | New Madrid | Missouri | 29143 | 35 | 1 |
241664 | 241664 | 2020-06-15 | New Madrid | Missouri | 29143 | 35 | 1 |
244775 | 244775 | 2020-06-16 | New Madrid | Missouri | 29143 | 34 | 1 |
247888 | 247888 | 2020-06-17 | New Madrid | Missouri | 29143 | 34 | 2 |
251001 | 251001 | 2020-06-18 | New Madrid | Missouri | 29143 | 34 | 2 |
254116 | 254116 | 2020-06-19 | New Madrid | Missouri | 29143 | 34 | 2 |
257236 | 257236 | 2020-06-20 | New Madrid | Missouri | 29143 | 34 | 1 |
260362 | 260362 | 2020-06-21 | New Madrid | Missouri | 29143 | 36 | 1 |
263490 | 263490 | 2020-06-22 | New Madrid | Missouri | 29143 | 34 | 1 |
266616 | 266616 | 2020-06-23 | New Madrid | Missouri | 29143 | 36 | 1 |
269749 | 269749 | 2020-06-24 | New Madrid | Missouri | 29143 | 36 | 1 |
272888 | 272888 | 2020-06-25 | New Madrid | Missouri | 29143 | 36 | 1 |
276031 | 276031 | 2020-06-26 | New Madrid | Missouri | 29143 | 36 | 1 |
279179 | 279179 | 2020-06-27 | New Madrid | Missouri | 29143 | 38 | 1 |
282327 | 282327 | 2020-06-28 | New Madrid | Missouri | 29143 | 42 | 1 |
285472 | 285472 | 2020-06-29 | New Madrid | Missouri | 29143 | 43 | 1 |
288622 | 288622 | 2020-06-30 | New Madrid | Missouri | 29143 | 43 | 1 |
291773 | 291773 | 2020-07-01 | New Madrid | Missouri | 29143 | 42 | 1 |
294927 | 294927 | 2020-07-02 | New Madrid | Missouri | 29143 | 43 | 1 |
298085 | 298085 | 2020-07-03 | New Madrid | Missouri | 29143 | 44 | 1 |
301248 | 301248 | 2020-07-04 | New Madrid | Missouri | 29143 | 44 | 1 |
304412 | 304412 | 2020-07-05 | New Madrid | Missouri | 29143 | 44 | 1 |
307579 | 307579 | 2020-07-06 | New Madrid | Missouri | 29143 | 45 | 1 |
310747 | 310747 | 2020-07-07 | New Madrid | Missouri | 29143 | 45 | 1 |
313918 | 313918 | 2020-07-08 | New Madrid | Missouri | 29143 | 46 | 1 |
317092 | 317092 | 2020-07-09 | New Madrid | Missouri | 29143 | 47 | 1 |
320267 | 320267 | 2020-07-10 | New Madrid | Missouri | 29143 | 49 | 1 |
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);