ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 29097 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387477 | 387477 | 2020-07-31 | Jasper | Missouri | 29097 | 1190 | 4 |
384259 | 384259 | 2020-07-30 | Jasper | Missouri | 29097 | 1176 | 4 |
381043 | 381043 | 2020-07-29 | Jasper | Missouri | 29097 | 1166 | 4 |
377826 | 377826 | 2020-07-28 | Jasper | Missouri | 29097 | 1161 | 4 |
374611 | 374611 | 2020-07-27 | Jasper | Missouri | 29097 | 1132 | 4 |
371399 | 371399 | 2020-07-26 | Jasper | Missouri | 29097 | 1106 | 4 |
368188 | 368188 | 2020-07-25 | Jasper | Missouri | 29097 | 1092 | 4 |
364980 | 364980 | 2020-07-24 | Jasper | Missouri | 29097 | 1046 | 3 |
361773 | 361773 | 2020-07-23 | Jasper | Missouri | 29097 | 997 | 3 |
358568 | 358568 | 2020-07-22 | Jasper | Missouri | 29097 | 967 | 2 |
355365 | 355365 | 2020-07-21 | Jasper | Missouri | 29097 | 950 | 2 |
352163 | 352163 | 2020-07-20 | Jasper | Missouri | 29097 | 937 | 1 |
348963 | 348963 | 2020-07-19 | Jasper | Missouri | 29097 | 923 | 1 |
345762 | 345762 | 2020-07-18 | Jasper | Missouri | 29097 | 908 | 1 |
342562 | 342562 | 2020-07-17 | Jasper | Missouri | 29097 | 877 | 1 |
339366 | 339366 | 2020-07-16 | Jasper | Missouri | 29097 | 840 | 1 |
336170 | 336170 | 2020-07-15 | Jasper | Missouri | 29097 | 823 | 1 |
332977 | 332977 | 2020-07-14 | Jasper | Missouri | 29097 | 807 | 1 |
329790 | 329790 | 2020-07-13 | Jasper | Missouri | 29097 | 778 | 1 |
326604 | 326604 | 2020-07-12 | Jasper | Missouri | 29097 | 772 | 1 |
323421 | 323421 | 2020-07-11 | Jasper | Missouri | 29097 | 761 | 1 |
320242 | 320242 | 2020-07-10 | Jasper | Missouri | 29097 | 748 | 1 |
317067 | 317067 | 2020-07-09 | Jasper | Missouri | 29097 | 733 | 2 |
313893 | 313893 | 2020-07-08 | Jasper | Missouri | 29097 | 692 | 1 |
310722 | 310722 | 2020-07-07 | Jasper | Missouri | 29097 | 652 | 1 |
307554 | 307554 | 2020-07-06 | Jasper | Missouri | 29097 | 611 | 1 |
304387 | 304387 | 2020-07-05 | Jasper | Missouri | 29097 | 587 | 1 |
301223 | 301223 | 2020-07-04 | Jasper | Missouri | 29097 | 582 | 1 |
298060 | 298060 | 2020-07-03 | Jasper | Missouri | 29097 | 515 | 1 |
294902 | 294902 | 2020-07-02 | Jasper | Missouri | 29097 | 481 | 1 |
291748 | 291748 | 2020-07-01 | Jasper | Missouri | 29097 | 474 | 1 |
288597 | 288597 | 2020-06-30 | Jasper | Missouri | 29097 | 449 | 1 |
285447 | 285447 | 2020-06-29 | Jasper | Missouri | 29097 | 398 | 1 |
282302 | 282302 | 2020-06-28 | Jasper | Missouri | 29097 | 368 | 1 |
279154 | 279154 | 2020-06-27 | Jasper | Missouri | 29097 | 356 | 1 |
276006 | 276006 | 2020-06-26 | Jasper | Missouri | 29097 | 338 | 1 |
272863 | 272863 | 2020-06-25 | Jasper | Missouri | 29097 | 311 | 1 |
269725 | 269725 | 2020-06-24 | Jasper | Missouri | 29097 | 309 | 0 |
266592 | 266592 | 2020-06-23 | Jasper | Missouri | 29097 | 303 | 0 |
263466 | 263466 | 2020-06-22 | Jasper | Missouri | 29097 | 260 | 0 |
260338 | 260338 | 2020-06-21 | Jasper | Missouri | 29097 | 260 | 0 |
257212 | 257212 | 2020-06-20 | Jasper | Missouri | 29097 | 235 | 0 |
254092 | 254092 | 2020-06-19 | Jasper | Missouri | 29097 | 195 | 0 |
250977 | 250977 | 2020-06-18 | Jasper | Missouri | 29097 | 191 | 0 |
247864 | 247864 | 2020-06-17 | Jasper | Missouri | 29097 | 168 | 0 |
244751 | 244751 | 2020-06-16 | Jasper | Missouri | 29097 | 163 | 0 |
241640 | 241640 | 2020-06-15 | Jasper | Missouri | 29097 | 131 | 0 |
238530 | 238530 | 2020-06-14 | Jasper | Missouri | 29097 | 115 | 0 |
235423 | 235423 | 2020-06-13 | Jasper | Missouri | 29097 | 115 | 0 |
232317 | 232317 | 2020-06-12 | Jasper | Missouri | 29097 | 103 | 0 |
229213 | 229213 | 2020-06-11 | Jasper | Missouri | 29097 | 80 | 0 |
226110 | 226110 | 2020-06-10 | Jasper | Missouri | 29097 | 73 | 0 |
223012 | 223012 | 2020-06-09 | Jasper | Missouri | 29097 | 65 | 0 |
219917 | 219917 | 2020-06-08 | Jasper | Missouri | 29097 | 58 | 0 |
216825 | 216825 | 2020-06-07 | Jasper | Missouri | 29097 | 50 | 0 |
213737 | 213737 | 2020-06-06 | Jasper | Missouri | 29097 | 45 | 0 |
210653 | 210653 | 2020-06-05 | Jasper | Missouri | 29097 | 40 | 0 |
207572 | 207572 | 2020-06-04 | Jasper | Missouri | 29097 | 39 | 0 |
204491 | 204491 | 2020-06-03 | Jasper | Missouri | 29097 | 36 | 0 |
201414 | 201414 | 2020-06-02 | Jasper | Missouri | 29097 | 35 | 0 |
198341 | 198341 | 2020-06-01 | Jasper | Missouri | 29097 | 32 | 0 |
195270 | 195270 | 2020-05-31 | Jasper | Missouri | 29097 | 32 | 0 |
192201 | 192201 | 2020-05-30 | Jasper | Missouri | 29097 | 32 | 0 |
189137 | 189137 | 2020-05-29 | Jasper | Missouri | 29097 | 32 | 0 |
186079 | 186079 | 2020-05-28 | Jasper | Missouri | 29097 | 30 | 0 |
183023 | 183023 | 2020-05-27 | Jasper | Missouri | 29097 | 30 | 0 |
179977 | 179977 | 2020-05-26 | Jasper | Missouri | 29097 | 30 | 0 |
176933 | 176933 | 2020-05-25 | Jasper | Missouri | 29097 | 30 | 0 |
173890 | 173890 | 2020-05-24 | Jasper | Missouri | 29097 | 30 | 0 |
170848 | 170848 | 2020-05-23 | Jasper | Missouri | 29097 | 29 | 0 |
167809 | 167809 | 2020-05-22 | Jasper | Missouri | 29097 | 29 | 0 |
164773 | 164773 | 2020-05-21 | Jasper | Missouri | 29097 | 28 | 0 |
161744 | 161744 | 2020-05-20 | Jasper | Missouri | 29097 | 27 | 0 |
158718 | 158718 | 2020-05-19 | Jasper | Missouri | 29097 | 27 | 0 |
155700 | 155700 | 2020-05-18 | Jasper | Missouri | 29097 | 27 | 0 |
152686 | 152686 | 2020-05-17 | Jasper | Missouri | 29097 | 27 | 0 |
149675 | 149675 | 2020-05-16 | Jasper | Missouri | 29097 | 27 | 0 |
146670 | 146670 | 2020-05-15 | Jasper | Missouri | 29097 | 27 | 0 |
143669 | 143669 | 2020-05-14 | Jasper | Missouri | 29097 | 27 | 0 |
140674 | 140674 | 2020-05-13 | Jasper | Missouri | 29097 | 27 | 0 |
137680 | 137680 | 2020-05-12 | Jasper | Missouri | 29097 | 27 | 0 |
134690 | 134690 | 2020-05-11 | Jasper | Missouri | 29097 | 26 | 0 |
131699 | 131699 | 2020-05-10 | Jasper | Missouri | 29097 | 26 | 0 |
128709 | 128709 | 2020-05-09 | Jasper | Missouri | 29097 | 26 | 0 |
125722 | 125722 | 2020-05-08 | Jasper | Missouri | 29097 | 24 | 0 |
122740 | 122740 | 2020-05-07 | Jasper | Missouri | 29097 | 24 | 0 |
119766 | 119766 | 2020-05-06 | Jasper | Missouri | 29097 | 24 | 0 |
116806 | 116806 | 2020-05-05 | Jasper | Missouri | 29097 | 24 | 0 |
113924 | 113924 | 2020-05-04 | Jasper | Missouri | 29097 | 24 | 0 |
111045 | 111045 | 2020-05-03 | Jasper | Missouri | 29097 | 24 | 0 |
108174 | 108174 | 2020-05-02 | Jasper | Missouri | 29097 | 24 | 0 |
105309 | 105309 | 2020-05-01 | Jasper | Missouri | 29097 | 24 | 0 |
102448 | 102448 | 2020-04-30 | Jasper | Missouri | 29097 | 24 | 0 |
99596 | 99596 | 2020-04-29 | Jasper | Missouri | 29097 | 23 | 0 |
96750 | 96750 | 2020-04-28 | Jasper | Missouri | 29097 | 23 | 0 |
93914 | 93914 | 2020-04-27 | Jasper | Missouri | 29097 | 23 | 0 |
91093 | 91093 | 2020-04-26 | Jasper | Missouri | 29097 | 23 | 0 |
88277 | 88277 | 2020-04-25 | Jasper | Missouri | 29097 | 22 | 0 |
85467 | 85467 | 2020-04-24 | Jasper | Missouri | 29097 | 22 | 0 |
82663 | 82663 | 2020-04-23 | Jasper | Missouri | 29097 | 22 | 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);