ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29043 and state = "Missouri" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
282276 | 282276 | 2020-06-28 | Christian | Missouri | 29043 | 41 | 0 |
285421 | 285421 | 2020-06-29 | Christian | Missouri | 29043 | 43 | 0 |
288571 | 288571 | 2020-06-30 | Christian | Missouri | 29043 | 44 | 0 |
291722 | 291722 | 2020-07-01 | Christian | Missouri | 29043 | 45 | 0 |
294876 | 294876 | 2020-07-02 | Christian | Missouri | 29043 | 54 | 1 |
298034 | 298034 | 2020-07-03 | Christian | Missouri | 29043 | 54 | 1 |
301197 | 301197 | 2020-07-04 | Christian | Missouri | 29043 | 54 | 1 |
304361 | 304361 | 2020-07-05 | Christian | Missouri | 29043 | 54 | 1 |
307528 | 307528 | 2020-07-06 | Christian | Missouri | 29043 | 58 | 1 |
310696 | 310696 | 2020-07-07 | Christian | Missouri | 29043 | 71 | 1 |
313866 | 313866 | 2020-07-08 | Christian | Missouri | 29043 | 71 | 1 |
317040 | 317040 | 2020-07-09 | Christian | Missouri | 29043 | 85 | 1 |
320215 | 320215 | 2020-07-10 | Christian | Missouri | 29043 | 85 | 1 |
323394 | 323394 | 2020-07-11 | Christian | Missouri | 29043 | 85 | 1 |
326577 | 326577 | 2020-07-12 | Christian | Missouri | 29043 | 85 | 1 |
329763 | 329763 | 2020-07-13 | Christian | Missouri | 29043 | 102 | 1 |
332950 | 332950 | 2020-07-14 | Christian | Missouri | 29043 | 120 | 1 |
336143 | 336143 | 2020-07-15 | Christian | Missouri | 29043 | 120 | 1 |
339339 | 339339 | 2020-07-16 | Christian | Missouri | 29043 | 130 | 1 |
342535 | 342535 | 2020-07-17 | Christian | Missouri | 29043 | 130 | 1 |
345735 | 345735 | 2020-07-18 | Christian | Missouri | 29043 | 130 | 1 |
348936 | 348936 | 2020-07-19 | Christian | Missouri | 29043 | 130 | 1 |
352136 | 352136 | 2020-07-20 | Christian | Missouri | 29043 | 148 | 1 |
355338 | 355338 | 2020-07-21 | Christian | Missouri | 29043 | 176 | 1 |
358541 | 358541 | 2020-07-22 | Christian | Missouri | 29043 | 185 | 1 |
361746 | 361746 | 2020-07-23 | Christian | Missouri | 29043 | 185 | 1 |
364953 | 364953 | 2020-07-24 | Christian | Missouri | 29043 | 211 | 1 |
368161 | 368161 | 2020-07-25 | Christian | Missouri | 29043 | 211 | 1 |
371372 | 371372 | 2020-07-26 | Christian | Missouri | 29043 | 211 | 1 |
374584 | 374584 | 2020-07-27 | Christian | Missouri | 29043 | 241 | 1 |
377799 | 377799 | 2020-07-28 | Christian | Missouri | 29043 | 241 | 1 |
381016 | 381016 | 2020-07-29 | Christian | Missouri | 29043 | 241 | 1 |
384232 | 384232 | 2020-07-30 | Christian | Missouri | 29043 | 278 | 1 |
387450 | 387450 | 2020-07-31 | Christian | Missouri | 29043 | 278 | 1 |
390667 | 390667 | 2020-08-01 | Christian | Missouri | 29043 | 278 | 1 |
393884 | 393884 | 2020-08-02 | Christian | Missouri | 29043 | 281 | 1 |
397100 | 397100 | 2020-08-03 | Christian | Missouri | 29043 | 286 | 1 |
400314 | 400314 | 2020-08-04 | Christian | Missouri | 29043 | 300 | 1 |
403531 | 403531 | 2020-08-05 | Christian | Missouri | 29043 | 311 | 1 |
406749 | 406749 | 2020-08-06 | Christian | Missouri | 29043 | 324 | 1 |
409969 | 409969 | 2020-08-07 | Christian | Missouri | 29043 | 369 | 1 |
413189 | 413189 | 2020-08-08 | Christian | Missouri | 29043 | 369 | 1 |
416409 | 416409 | 2020-08-09 | Christian | Missouri | 29043 | 369 | 1 |
419630 | 419630 | 2020-08-10 | Christian | Missouri | 29043 | 395 | 1 |
422852 | 422852 | 2020-08-11 | Christian | Missouri | 29043 | 395 | 1 |
426074 | 426074 | 2020-08-12 | Christian | Missouri | 29043 | 395 | 1 |
429298 | 429298 | 2020-08-13 | Christian | Missouri | 29043 | 403 | 1 |
432525 | 432525 | 2020-08-14 | Christian | Missouri | 29043 | 458 | 1 |
435751 | 435751 | 2020-08-15 | Christian | Missouri | 29043 | 458 | 1 |
438976 | 438976 | 2020-08-16 | Christian | Missouri | 29043 | 490 | 1 |
442203 | 442203 | 2020-08-17 | Christian | Missouri | 29043 | 490 | 1 |
445429 | 445429 | 2020-08-18 | Christian | Missouri | 29043 | 493 | 1 |
448655 | 448655 | 2020-08-19 | Christian | Missouri | 29043 | 523 | 2 |
451883 | 451883 | 2020-08-20 | Christian | Missouri | 29043 | 523 | 2 |
455111 | 455111 | 2020-08-21 | Christian | Missouri | 29043 | 552 | 2 |
458339 | 458339 | 2020-08-22 | Christian | Missouri | 29043 | 552 | 2 |
461566 | 461566 | 2020-08-23 | Christian | Missouri | 29043 | 552 | 2 |
464797 | 464797 | 2020-08-24 | Christian | Missouri | 29043 | 552 | 2 |
468026 | 468026 | 2020-08-25 | Christian | Missouri | 29043 | 609 | 2 |
471256 | 471256 | 2020-08-26 | Christian | Missouri | 29043 | 609 | 2 |
474488 | 474488 | 2020-08-27 | Christian | Missouri | 29043 | 609 | 2 |
477721 | 477721 | 2020-08-28 | Christian | Missouri | 29043 | 609 | 2 |
480953 | 480953 | 2020-08-29 | Christian | Missouri | 29043 | 676 | 2 |
484188 | 484188 | 2020-08-30 | Christian | Missouri | 29043 | 676 | 2 |
487422 | 487422 | 2020-08-31 | Christian | Missouri | 29043 | 728 | 2 |
490655 | 490655 | 2020-09-01 | Christian | Missouri | 29043 | 728 | 2 |
493889 | 493889 | 2020-09-02 | Christian | Missouri | 29043 | 728 | 2 |
497122 | 497122 | 2020-09-03 | Christian | Missouri | 29043 | 741 | 2 |
500356 | 500356 | 2020-09-04 | Christian | Missouri | 29043 | 821 | 3 |
503590 | 503590 | 2020-09-05 | Christian | Missouri | 29043 | 821 | 3 |
506823 | 506823 | 2020-09-06 | Christian | Missouri | 29043 | 821 | 3 |
510056 | 510056 | 2020-09-07 | Christian | Missouri | 29043 | 829 | 3 |
513288 | 513288 | 2020-09-08 | Christian | Missouri | 29043 | 936 | 4 |
516522 | 516522 | 2020-09-09 | Christian | Missouri | 29043 | 936 | 4 |
519757 | 519757 | 2020-09-10 | Christian | Missouri | 29043 | 936 | 4 |
522994 | 522994 | 2020-09-11 | Christian | Missouri | 29043 | 1073 | 4 |
526230 | 526230 | 2020-09-12 | Christian | Missouri | 29043 | 1073 | 4 |
529466 | 529466 | 2020-09-13 | Christian | Missouri | 29043 | 1073 | 4 |
532702 | 532702 | 2020-09-14 | Christian | Missouri | 29043 | 1073 | 4 |
535937 | 535937 | 2020-09-15 | Christian | Missouri | 29043 | 1169 | 4 |
539174 | 539174 | 2020-09-16 | Christian | Missouri | 29043 | 1169 | 4 |
542410 | 542410 | 2020-09-17 | Christian | Missouri | 29043 | 1169 | 4 |
545647 | 545647 | 2020-09-18 | Christian | Missouri | 29043 | 1287 | 4 |
548885 | 548885 | 2020-09-19 | Christian | Missouri | 29043 | 1287 | 4 |
552124 | 552124 | 2020-09-20 | Christian | Missouri | 29043 | 1287 | 4 |
555362 | 555362 | 2020-09-21 | Christian | Missouri | 29043 | 1287 | 4 |
558599 | 558599 | 2020-09-22 | Christian | Missouri | 29043 | 1407 | 4 |
561836 | 561836 | 2020-09-23 | Christian | Missouri | 29043 | 1407 | 5 |
565076 | 565076 | 2020-09-24 | Christian | Missouri | 29043 | 1407 | 5 |
568316 | 568316 | 2020-09-25 | Christian | Missouri | 29043 | 1490 | 5 |
571558 | 571558 | 2020-09-26 | Christian | Missouri | 29043 | 1490 | 6 |
574801 | 574801 | 2020-09-27 | Christian | Missouri | 29043 | 1490 | 6 |
578042 | 578042 | 2020-09-28 | Christian | Missouri | 29043 | 1546 | 6 |
581283 | 581283 | 2020-09-29 | Christian | Missouri | 29043 | 1546 | 6 |
584524 | 584524 | 2020-09-30 | Christian | Missouri | 29043 | 1546 | 6 |
587764 | 587764 | 2020-10-01 | Christian | Missouri | 29043 | 1546 | 6 |
591005 | 591005 | 2020-10-02 | Christian | Missouri | 29043 | 1767 | 6 |
594246 | 594246 | 2020-10-03 | Christian | Missouri | 29043 | 1767 | 6 |
597487 | 597487 | 2020-10-04 | Christian | Missouri | 29043 | 1767 | 6 |
600730 | 600730 | 2020-10-05 | Christian | Missouri | 29043 | 1767 | 6 |
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);