ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Christian" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535937 | 535937 | 2020-09-15 | Christian | Missouri | 29043 | 1169 | 4 |
532702 | 532702 | 2020-09-14 | Christian | Missouri | 29043 | 1073 | 4 |
529466 | 529466 | 2020-09-13 | Christian | Missouri | 29043 | 1073 | 4 |
526230 | 526230 | 2020-09-12 | Christian | Missouri | 29043 | 1073 | 4 |
522994 | 522994 | 2020-09-11 | Christian | Missouri | 29043 | 1073 | 4 |
519757 | 519757 | 2020-09-10 | Christian | Missouri | 29043 | 936 | 4 |
516522 | 516522 | 2020-09-09 | Christian | Missouri | 29043 | 936 | 4 |
513288 | 513288 | 2020-09-08 | Christian | Missouri | 29043 | 936 | 4 |
510056 | 510056 | 2020-09-07 | Christian | Missouri | 29043 | 829 | 3 |
506823 | 506823 | 2020-09-06 | Christian | Missouri | 29043 | 821 | 3 |
503590 | 503590 | 2020-09-05 | Christian | Missouri | 29043 | 821 | 3 |
500356 | 500356 | 2020-09-04 | Christian | Missouri | 29043 | 821 | 3 |
497122 | 497122 | 2020-09-03 | Christian | Missouri | 29043 | 741 | 2 |
493889 | 493889 | 2020-09-02 | Christian | Missouri | 29043 | 728 | 2 |
490655 | 490655 | 2020-09-01 | Christian | Missouri | 29043 | 728 | 2 |
487422 | 487422 | 2020-08-31 | Christian | Missouri | 29043 | 728 | 2 |
484188 | 484188 | 2020-08-30 | Christian | Missouri | 29043 | 676 | 2 |
480953 | 480953 | 2020-08-29 | Christian | Missouri | 29043 | 676 | 2 |
477721 | 477721 | 2020-08-28 | Christian | Missouri | 29043 | 609 | 2 |
474488 | 474488 | 2020-08-27 | Christian | Missouri | 29043 | 609 | 2 |
471256 | 471256 | 2020-08-26 | Christian | Missouri | 29043 | 609 | 2 |
468026 | 468026 | 2020-08-25 | Christian | Missouri | 29043 | 609 | 2 |
464797 | 464797 | 2020-08-24 | Christian | Missouri | 29043 | 552 | 2 |
461566 | 461566 | 2020-08-23 | Christian | Missouri | 29043 | 552 | 2 |
458339 | 458339 | 2020-08-22 | Christian | Missouri | 29043 | 552 | 2 |
455111 | 455111 | 2020-08-21 | Christian | Missouri | 29043 | 552 | 2 |
451883 | 451883 | 2020-08-20 | Christian | Missouri | 29043 | 523 | 2 |
448655 | 448655 | 2020-08-19 | Christian | Missouri | 29043 | 523 | 2 |
445429 | 445429 | 2020-08-18 | Christian | Missouri | 29043 | 493 | 1 |
442203 | 442203 | 2020-08-17 | Christian | Missouri | 29043 | 490 | 1 |
438976 | 438976 | 2020-08-16 | Christian | Missouri | 29043 | 490 | 1 |
435751 | 435751 | 2020-08-15 | Christian | Missouri | 29043 | 458 | 1 |
432525 | 432525 | 2020-08-14 | Christian | Missouri | 29043 | 458 | 1 |
429298 | 429298 | 2020-08-13 | Christian | Missouri | 29043 | 403 | 1 |
426074 | 426074 | 2020-08-12 | Christian | Missouri | 29043 | 395 | 1 |
422852 | 422852 | 2020-08-11 | Christian | Missouri | 29043 | 395 | 1 |
419630 | 419630 | 2020-08-10 | Christian | Missouri | 29043 | 395 | 1 |
416409 | 416409 | 2020-08-09 | Christian | Missouri | 29043 | 369 | 1 |
413189 | 413189 | 2020-08-08 | Christian | Missouri | 29043 | 369 | 1 |
409969 | 409969 | 2020-08-07 | Christian | Missouri | 29043 | 369 | 1 |
406749 | 406749 | 2020-08-06 | Christian | Missouri | 29043 | 324 | 1 |
403531 | 403531 | 2020-08-05 | Christian | Missouri | 29043 | 311 | 1 |
400314 | 400314 | 2020-08-04 | Christian | Missouri | 29043 | 300 | 1 |
397100 | 397100 | 2020-08-03 | Christian | Missouri | 29043 | 286 | 1 |
393884 | 393884 | 2020-08-02 | Christian | Missouri | 29043 | 281 | 1 |
390667 | 390667 | 2020-08-01 | Christian | Missouri | 29043 | 278 | 1 |
387450 | 387450 | 2020-07-31 | Christian | Missouri | 29043 | 278 | 1 |
384232 | 384232 | 2020-07-30 | Christian | Missouri | 29043 | 278 | 1 |
381016 | 381016 | 2020-07-29 | Christian | Missouri | 29043 | 241 | 1 |
377799 | 377799 | 2020-07-28 | Christian | Missouri | 29043 | 241 | 1 |
374584 | 374584 | 2020-07-27 | Christian | Missouri | 29043 | 241 | 1 |
371372 | 371372 | 2020-07-26 | Christian | Missouri | 29043 | 211 | 1 |
368161 | 368161 | 2020-07-25 | Christian | Missouri | 29043 | 211 | 1 |
364953 | 364953 | 2020-07-24 | Christian | Missouri | 29043 | 211 | 1 |
361746 | 361746 | 2020-07-23 | Christian | Missouri | 29043 | 185 | 1 |
358541 | 358541 | 2020-07-22 | Christian | Missouri | 29043 | 185 | 1 |
355338 | 355338 | 2020-07-21 | Christian | Missouri | 29043 | 176 | 1 |
352136 | 352136 | 2020-07-20 | Christian | Missouri | 29043 | 148 | 1 |
348936 | 348936 | 2020-07-19 | Christian | Missouri | 29043 | 130 | 1 |
345735 | 345735 | 2020-07-18 | Christian | Missouri | 29043 | 130 | 1 |
342535 | 342535 | 2020-07-17 | Christian | Missouri | 29043 | 130 | 1 |
339339 | 339339 | 2020-07-16 | Christian | Missouri | 29043 | 130 | 1 |
336143 | 336143 | 2020-07-15 | Christian | Missouri | 29043 | 120 | 1 |
332950 | 332950 | 2020-07-14 | Christian | Missouri | 29043 | 120 | 1 |
329763 | 329763 | 2020-07-13 | Christian | Missouri | 29043 | 102 | 1 |
326577 | 326577 | 2020-07-12 | Christian | Missouri | 29043 | 85 | 1 |
323394 | 323394 | 2020-07-11 | Christian | Missouri | 29043 | 85 | 1 |
320215 | 320215 | 2020-07-10 | Christian | Missouri | 29043 | 85 | 1 |
317040 | 317040 | 2020-07-09 | Christian | Missouri | 29043 | 85 | 1 |
313866 | 313866 | 2020-07-08 | Christian | Missouri | 29043 | 71 | 1 |
310696 | 310696 | 2020-07-07 | Christian | Missouri | 29043 | 71 | 1 |
307528 | 307528 | 2020-07-06 | Christian | Missouri | 29043 | 58 | 1 |
304361 | 304361 | 2020-07-05 | Christian | Missouri | 29043 | 54 | 1 |
301197 | 301197 | 2020-07-04 | Christian | Missouri | 29043 | 54 | 1 |
298034 | 298034 | 2020-07-03 | Christian | Missouri | 29043 | 54 | 1 |
294876 | 294876 | 2020-07-02 | Christian | Missouri | 29043 | 54 | 1 |
291722 | 291722 | 2020-07-01 | Christian | Missouri | 29043 | 45 | 0 |
288571 | 288571 | 2020-06-30 | Christian | Missouri | 29043 | 44 | 0 |
285421 | 285421 | 2020-06-29 | Christian | Missouri | 29043 | 43 | 0 |
282276 | 282276 | 2020-06-28 | Christian | Missouri | 29043 | 41 | 0 |
279128 | 279128 | 2020-06-27 | Christian | Missouri | 29043 | 40 | 0 |
275980 | 275980 | 2020-06-26 | Christian | Missouri | 29043 | 39 | 0 |
272837 | 272837 | 2020-06-25 | Christian | Missouri | 29043 | 38 | 0 |
269699 | 269699 | 2020-06-24 | Christian | Missouri | 29043 | 37 | 0 |
266566 | 266566 | 2020-06-23 | Christian | Missouri | 29043 | 35 | 0 |
263440 | 263440 | 2020-06-22 | Christian | Missouri | 29043 | 32 | 0 |
260312 | 260312 | 2020-06-21 | Christian | Missouri | 29043 | 32 | 0 |
257186 | 257186 | 2020-06-20 | Christian | Missouri | 29043 | 32 | 0 |
254066 | 254066 | 2020-06-19 | Christian | Missouri | 29043 | 31 | 0 |
250951 | 250951 | 2020-06-18 | Christian | Missouri | 29043 | 31 | 0 |
247838 | 247838 | 2020-06-17 | Christian | Missouri | 29043 | 30 | 0 |
244725 | 244725 | 2020-06-16 | Christian | Missouri | 29043 | 30 | 0 |
241614 | 241614 | 2020-06-15 | Christian | Missouri | 29043 | 30 | 0 |
238505 | 238505 | 2020-06-14 | Christian | Missouri | 29043 | 29 | 0 |
235398 | 235398 | 2020-06-13 | Christian | Missouri | 29043 | 29 | 0 |
232292 | 232292 | 2020-06-12 | Christian | Missouri | 29043 | 29 | 0 |
229188 | 229188 | 2020-06-11 | Christian | Missouri | 29043 | 28 | 0 |
226085 | 226085 | 2020-06-10 | Christian | Missouri | 29043 | 28 | 0 |
222987 | 222987 | 2020-06-09 | Christian | Missouri | 29043 | 28 | 0 |
219892 | 219892 | 2020-06-08 | Christian | Missouri | 29043 | 28 | 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);