ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 29077 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535954 | 535954 | 2020-09-15 | Greene | Missouri | 29077 | 5034 | 46 |
532719 | 532719 | 2020-09-14 | Greene | Missouri | 29077 | 4904 | 44 |
529483 | 529483 | 2020-09-13 | Greene | Missouri | 29077 | 4833 | 44 |
526247 | 526247 | 2020-09-12 | Greene | Missouri | 29077 | 4748 | 44 |
523011 | 523011 | 2020-09-11 | Greene | Missouri | 29077 | 4575 | 43 |
519774 | 519774 | 2020-09-10 | Greene | Missouri | 29077 | 4466 | 43 |
516539 | 516539 | 2020-09-09 | Greene | Missouri | 29077 | 4369 | 39 |
513305 | 513305 | 2020-09-08 | Greene | Missouri | 29077 | 4255 | 39 |
510073 | 510073 | 2020-09-07 | Greene | Missouri | 29077 | 4193 | 37 |
506840 | 506840 | 2020-09-06 | Greene | Missouri | 29077 | 4109 | 37 |
503607 | 503607 | 2020-09-05 | Greene | Missouri | 29077 | 3989 | 37 |
500373 | 500373 | 2020-09-04 | Greene | Missouri | 29077 | 3794 | 36 |
497139 | 497139 | 2020-09-03 | Greene | Missouri | 29077 | 3670 | 36 |
493906 | 493906 | 2020-09-02 | Greene | Missouri | 29077 | 3566 | 35 |
490672 | 490672 | 2020-09-01 | Greene | Missouri | 29077 | 3451 | 35 |
487439 | 487439 | 2020-08-31 | Greene | Missouri | 29077 | 3372 | 30 |
484205 | 484205 | 2020-08-30 | Greene | Missouri | 29077 | 3266 | 30 |
480970 | 480970 | 2020-08-29 | Greene | Missouri | 29077 | 3178 | 30 |
477738 | 477738 | 2020-08-28 | Greene | Missouri | 29077 | 2972 | 30 |
474505 | 474505 | 2020-08-27 | Greene | Missouri | 29077 | 2834 | 29 |
471273 | 471273 | 2020-08-26 | Greene | Missouri | 29077 | 2722 | 28 |
468043 | 468043 | 2020-08-25 | Greene | Missouri | 29077 | 2662 | 25 |
464814 | 464814 | 2020-08-24 | Greene | Missouri | 29077 | 2585 | 24 |
461583 | 461583 | 2020-08-23 | Greene | Missouri | 29077 | 2508 | 22 |
458356 | 458356 | 2020-08-22 | Greene | Missouri | 29077 | 2466 | 22 |
455128 | 455128 | 2020-08-21 | Greene | Missouri | 29077 | 2365 | 22 |
451900 | 451900 | 2020-08-20 | Greene | Missouri | 29077 | 2229 | 22 |
448672 | 448672 | 2020-08-19 | Greene | Missouri | 29077 | 2160 | 22 |
445446 | 445446 | 2020-08-18 | Greene | Missouri | 29077 | 2107 | 17 |
442220 | 442220 | 2020-08-17 | Greene | Missouri | 29077 | 2017 | 17 |
438993 | 438993 | 2020-08-16 | Greene | Missouri | 29077 | 1924 | 17 |
435768 | 435768 | 2020-08-15 | Greene | Missouri | 29077 | 1897 | 17 |
432542 | 432542 | 2020-08-14 | Greene | Missouri | 29077 | 1844 | 16 |
429315 | 429315 | 2020-08-13 | Greene | Missouri | 29077 | 1813 | 16 |
426091 | 426091 | 2020-08-12 | Greene | Missouri | 29077 | 1732 | 16 |
422869 | 422869 | 2020-08-11 | Greene | Missouri | 29077 | 1642 | 16 |
419647 | 419647 | 2020-08-10 | Greene | Missouri | 29077 | 1613 | 16 |
416426 | 416426 | 2020-08-09 | Greene | Missouri | 29077 | 1565 | 14 |
413206 | 413206 | 2020-08-08 | Greene | Missouri | 29077 | 1536 | 14 |
409986 | 409986 | 2020-08-07 | Greene | Missouri | 29077 | 1440 | 11 |
406766 | 406766 | 2020-08-06 | Greene | Missouri | 29077 | 1400 | 11 |
403548 | 403548 | 2020-08-05 | Greene | Missouri | 29077 | 1350 | 11 |
400331 | 400331 | 2020-08-04 | Greene | Missouri | 29077 | 1318 | 11 |
397117 | 397117 | 2020-08-03 | Greene | Missouri | 29077 | 1318 | 11 |
393901 | 393901 | 2020-08-02 | Greene | Missouri | 29077 | 1260 | 11 |
390684 | 390684 | 2020-08-01 | Greene | Missouri | 29077 | 1250 | 11 |
387467 | 387467 | 2020-07-31 | Greene | Missouri | 29077 | 1229 | 11 |
384249 | 384249 | 2020-07-30 | Greene | Missouri | 29077 | 1192 | 11 |
381033 | 381033 | 2020-07-29 | Greene | Missouri | 29077 | 1159 | 10 |
377816 | 377816 | 2020-07-28 | Greene | Missouri | 29077 | 1118 | 10 |
374601 | 374601 | 2020-07-27 | Greene | Missouri | 29077 | 1076 | 10 |
371389 | 371389 | 2020-07-26 | Greene | Missouri | 29077 | 1019 | 10 |
368178 | 368178 | 2020-07-25 | Greene | Missouri | 29077 | 1016 | 10 |
364970 | 364970 | 2020-07-24 | Greene | Missouri | 29077 | 979 | 10 |
361763 | 361763 | 2020-07-23 | Greene | Missouri | 29077 | 966 | 10 |
358558 | 358558 | 2020-07-22 | Greene | Missouri | 29077 | 892 | 9 |
355355 | 355355 | 2020-07-21 | Greene | Missouri | 29077 | 860 | 9 |
352153 | 352153 | 2020-07-20 | Greene | Missouri | 29077 | 815 | 9 |
348953 | 348953 | 2020-07-19 | Greene | Missouri | 29077 | 754 | 9 |
345752 | 345752 | 2020-07-18 | Greene | Missouri | 29077 | 729 | 9 |
342552 | 342552 | 2020-07-17 | Greene | Missouri | 29077 | 712 | 9 |
339356 | 339356 | 2020-07-16 | Greene | Missouri | 29077 | 672 | 9 |
336160 | 336160 | 2020-07-15 | Greene | Missouri | 29077 | 635 | 9 |
332967 | 332967 | 2020-07-14 | Greene | Missouri | 29077 | 614 | 9 |
329780 | 329780 | 2020-07-13 | Greene | Missouri | 29077 | 577 | 9 |
326594 | 326594 | 2020-07-12 | Greene | Missouri | 29077 | 527 | 9 |
323411 | 323411 | 2020-07-11 | Greene | Missouri | 29077 | 510 | 9 |
320232 | 320232 | 2020-07-10 | Greene | Missouri | 29077 | 496 | 9 |
317057 | 317057 | 2020-07-09 | Greene | Missouri | 29077 | 463 | 9 |
313883 | 313883 | 2020-07-08 | Greene | Missouri | 29077 | 429 | 9 |
310713 | 310713 | 2020-07-07 | Greene | Missouri | 29077 | 408 | 8 |
307545 | 307545 | 2020-07-06 | Greene | Missouri | 29077 | 394 | 8 |
304378 | 304378 | 2020-07-05 | Greene | Missouri | 29077 | 360 | 8 |
301214 | 301214 | 2020-07-04 | Greene | Missouri | 29077 | 354 | 8 |
298051 | 298051 | 2020-07-03 | Greene | Missouri | 29077 | 346 | 8 |
294893 | 294893 | 2020-07-02 | Greene | Missouri | 29077 | 343 | 8 |
291739 | 291739 | 2020-07-01 | Greene | Missouri | 29077 | 329 | 8 |
288588 | 288588 | 2020-06-30 | Greene | Missouri | 29077 | 319 | 8 |
285438 | 285438 | 2020-06-29 | Greene | Missouri | 29077 | 311 | 8 |
282293 | 282293 | 2020-06-28 | Greene | Missouri | 29077 | 301 | 8 |
279145 | 279145 | 2020-06-27 | Greene | Missouri | 29077 | 297 | 8 |
275997 | 275997 | 2020-06-26 | Greene | Missouri | 29077 | 292 | 8 |
272854 | 272854 | 2020-06-25 | Greene | Missouri | 29077 | 285 | 8 |
269716 | 269716 | 2020-06-24 | Greene | Missouri | 29077 | 278 | 8 |
266583 | 266583 | 2020-06-23 | Greene | Missouri | 29077 | 267 | 8 |
263457 | 263457 | 2020-06-22 | Greene | Missouri | 29077 | 261 | 8 |
260329 | 260329 | 2020-06-21 | Greene | Missouri | 29077 | 253 | 8 |
257203 | 257203 | 2020-06-20 | Greene | Missouri | 29077 | 250 | 8 |
254083 | 254083 | 2020-06-19 | Greene | Missouri | 29077 | 243 | 8 |
250968 | 250968 | 2020-06-18 | Greene | Missouri | 29077 | 240 | 8 |
247855 | 247855 | 2020-06-17 | Greene | Missouri | 29077 | 236 | 9 |
244742 | 244742 | 2020-06-16 | Greene | Missouri | 29077 | 232 | 9 |
241631 | 241631 | 2020-06-15 | Greene | Missouri | 29077 | 226 | 9 |
238521 | 238521 | 2020-06-14 | Greene | Missouri | 29077 | 220 | 9 |
235414 | 235414 | 2020-06-13 | Greene | Missouri | 29077 | 218 | 9 |
232308 | 232308 | 2020-06-12 | Greene | Missouri | 29077 | 216 | 10 |
229204 | 229204 | 2020-06-11 | Greene | Missouri | 29077 | 212 | 8 |
226101 | 226101 | 2020-06-10 | Greene | Missouri | 29077 | 203 | 8 |
223003 | 223003 | 2020-06-09 | Greene | Missouri | 29077 | 201 | 8 |
219908 | 219908 | 2020-06-08 | Greene | Missouri | 29077 | 197 | 8 |
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);