ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 29099 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535965 | 535965 | 2020-09-15 | Jefferson | Missouri | 29099 | 3579 | 52 |
532730 | 532730 | 2020-09-14 | Jefferson | Missouri | 29099 | 3519 | 52 |
529494 | 529494 | 2020-09-13 | Jefferson | Missouri | 29099 | 3425 | 52 |
526258 | 526258 | 2020-09-12 | Jefferson | Missouri | 29099 | 3369 | 52 |
523022 | 523022 | 2020-09-11 | Jefferson | Missouri | 29099 | 3336 | 52 |
519785 | 519785 | 2020-09-10 | Jefferson | Missouri | 29099 | 3336 | 52 |
516550 | 516550 | 2020-09-09 | Jefferson | Missouri | 29099 | 3297 | 49 |
513316 | 513316 | 2020-09-08 | Jefferson | Missouri | 29099 | 3248 | 49 |
510084 | 510084 | 2020-09-07 | Jefferson | Missouri | 29099 | 3109 | 48 |
506851 | 506851 | 2020-09-06 | Jefferson | Missouri | 29099 | 3064 | 48 |
503618 | 503618 | 2020-09-05 | Jefferson | Missouri | 29099 | 3025 | 48 |
500384 | 500384 | 2020-09-04 | Jefferson | Missouri | 29099 | 3025 | 48 |
497150 | 497150 | 2020-09-03 | Jefferson | Missouri | 29099 | 2963 | 48 |
493917 | 493917 | 2020-09-02 | Jefferson | Missouri | 29099 | 2891 | 47 |
490683 | 490683 | 2020-09-01 | Jefferson | Missouri | 29099 | 2857 | 46 |
487450 | 487450 | 2020-08-31 | Jefferson | Missouri | 29099 | 2813 | 45 |
484216 | 484216 | 2020-08-30 | Jefferson | Missouri | 29099 | 2776 | 45 |
480981 | 480981 | 2020-08-29 | Jefferson | Missouri | 29099 | 2663 | 45 |
477749 | 477749 | 2020-08-28 | Jefferson | Missouri | 29099 | 2663 | 45 |
474516 | 474516 | 2020-08-27 | Jefferson | Missouri | 29099 | 2605 | 45 |
471284 | 471284 | 2020-08-26 | Jefferson | Missouri | 29099 | 2566 | 40 |
468054 | 468054 | 2020-08-25 | Jefferson | Missouri | 29099 | 2518 | 40 |
464825 | 464825 | 2020-08-24 | Jefferson | Missouri | 29099 | 2471 | 40 |
461594 | 461594 | 2020-08-23 | Jefferson | Missouri | 29099 | 2412 | 40 |
458367 | 458367 | 2020-08-22 | Jefferson | Missouri | 29099 | 2317 | 40 |
455139 | 455139 | 2020-08-21 | Jefferson | Missouri | 29099 | 2317 | 40 |
451911 | 451911 | 2020-08-20 | Jefferson | Missouri | 29099 | 2297 | 40 |
448683 | 448683 | 2020-08-19 | Jefferson | Missouri | 29099 | 2250 | 30 |
445457 | 445457 | 2020-08-18 | Jefferson | Missouri | 29099 | 2196 | 30 |
442231 | 442231 | 2020-08-17 | Jefferson | Missouri | 29099 | 2166 | 30 |
439004 | 439004 | 2020-08-16 | Jefferson | Missouri | 29099 | 2006 | 28 |
435779 | 435779 | 2020-08-15 | Jefferson | Missouri | 29099 | 2006 | 28 |
432553 | 432553 | 2020-08-14 | Jefferson | Missouri | 29099 | 2006 | 28 |
429326 | 429326 | 2020-08-13 | Jefferson | Missouri | 29099 | 1974 | 28 |
426102 | 426102 | 2020-08-12 | Jefferson | Missouri | 29099 | 1912 | 28 |
422880 | 422880 | 2020-08-11 | Jefferson | Missouri | 29099 | 1876 | 28 |
419658 | 419658 | 2020-08-10 | Jefferson | Missouri | 29099 | 1836 | 28 |
416437 | 416437 | 2020-08-09 | Jefferson | Missouri | 29099 | 1822 | 28 |
413217 | 413217 | 2020-08-08 | Jefferson | Missouri | 29099 | 1716 | 28 |
409997 | 409997 | 2020-08-07 | Jefferson | Missouri | 29099 | 1716 | 28 |
406777 | 406777 | 2020-08-06 | Jefferson | Missouri | 29099 | 1679 | 28 |
403559 | 403559 | 2020-08-05 | Jefferson | Missouri | 29099 | 1646 | 28 |
400342 | 400342 | 2020-08-04 | Jefferson | Missouri | 29099 | 1614 | 28 |
397128 | 397128 | 2020-08-03 | Jefferson | Missouri | 29099 | 1559 | 25 |
393912 | 393912 | 2020-08-02 | Jefferson | Missouri | 29099 | 1417 | 25 |
390695 | 390695 | 2020-08-01 | Jefferson | Missouri | 29099 | 1417 | 25 |
387478 | 387478 | 2020-07-31 | Jefferson | Missouri | 29099 | 1417 | 25 |
384260 | 384260 | 2020-07-30 | Jefferson | Missouri | 29099 | 1370 | 25 |
381044 | 381044 | 2020-07-29 | Jefferson | Missouri | 29099 | 1291 | 25 |
377827 | 377827 | 2020-07-28 | Jefferson | Missouri | 29099 | 1248 | 25 |
374612 | 374612 | 2020-07-27 | Jefferson | Missouri | 29099 | 1211 | 25 |
371400 | 371400 | 2020-07-26 | Jefferson | Missouri | 29099 | 1155 | 25 |
368189 | 368189 | 2020-07-25 | Jefferson | Missouri | 29099 | 1122 | 25 |
364981 | 364981 | 2020-07-24 | Jefferson | Missouri | 29099 | 1122 | 25 |
361774 | 361774 | 2020-07-23 | Jefferson | Missouri | 29099 | 1101 | 25 |
358569 | 358569 | 2020-07-22 | Jefferson | Missouri | 29099 | 1018 | 25 |
355366 | 355366 | 2020-07-21 | Jefferson | Missouri | 29099 | 1007 | 25 |
352164 | 352164 | 2020-07-20 | Jefferson | Missouri | 29099 | 969 | 25 |
348964 | 348964 | 2020-07-19 | Jefferson | Missouri | 29099 | 873 | 25 |
345763 | 345763 | 2020-07-18 | Jefferson | Missouri | 29099 | 873 | 25 |
342563 | 342563 | 2020-07-17 | Jefferson | Missouri | 29099 | 873 | 25 |
339367 | 339367 | 2020-07-16 | Jefferson | Missouri | 29099 | 857 | 25 |
336171 | 336171 | 2020-07-15 | Jefferson | Missouri | 29099 | 834 | 23 |
332978 | 332978 | 2020-07-14 | Jefferson | Missouri | 29099 | 814 | 23 |
329791 | 329791 | 2020-07-13 | Jefferson | Missouri | 29099 | 769 | 23 |
326605 | 326605 | 2020-07-12 | Jefferson | Missouri | 29099 | 743 | 23 |
323422 | 323422 | 2020-07-11 | Jefferson | Missouri | 29099 | 666 | 23 |
320243 | 320243 | 2020-07-10 | Jefferson | Missouri | 29099 | 666 | 23 |
317068 | 317068 | 2020-07-09 | Jefferson | Missouri | 29099 | 666 | 23 |
313894 | 313894 | 2020-07-08 | Jefferson | Missouri | 29099 | 631 | 23 |
310723 | 310723 | 2020-07-07 | Jefferson | Missouri | 29099 | 604 | 23 |
307555 | 307555 | 2020-07-06 | Jefferson | Missouri | 29099 | 582 | 23 |
304388 | 304388 | 2020-07-05 | Jefferson | Missouri | 29099 | 551 | 23 |
301224 | 301224 | 2020-07-04 | Jefferson | Missouri | 29099 | 551 | 23 |
298061 | 298061 | 2020-07-03 | Jefferson | Missouri | 29099 | 551 | 23 |
294903 | 294903 | 2020-07-02 | Jefferson | Missouri | 29099 | 551 | 23 |
291749 | 291749 | 2020-07-01 | Jefferson | Missouri | 29099 | 540 | 23 |
288598 | 288598 | 2020-06-30 | Jefferson | Missouri | 29099 | 539 | 21 |
285448 | 285448 | 2020-06-29 | Jefferson | Missouri | 29099 | 535 | 21 |
282303 | 282303 | 2020-06-28 | Jefferson | Missouri | 29099 | 519 | 21 |
279155 | 279155 | 2020-06-27 | Jefferson | Missouri | 29099 | 519 | 21 |
276007 | 276007 | 2020-06-26 | Jefferson | Missouri | 29099 | 519 | 21 |
272864 | 272864 | 2020-06-25 | Jefferson | Missouri | 29099 | 506 | 21 |
269726 | 269726 | 2020-06-24 | Jefferson | Missouri | 29099 | 501 | 21 |
266593 | 266593 | 2020-06-23 | Jefferson | Missouri | 29099 | 473 | 21 |
263467 | 263467 | 2020-06-22 | Jefferson | Missouri | 29099 | 465 | 21 |
260339 | 260339 | 2020-06-21 | Jefferson | Missouri | 29099 | 461 | 20 |
257213 | 257213 | 2020-06-20 | Jefferson | Missouri | 29099 | 461 | 20 |
254093 | 254093 | 2020-06-19 | Jefferson | Missouri | 29099 | 461 | 20 |
250978 | 250978 | 2020-06-18 | Jefferson | Missouri | 29099 | 456 | 20 |
247865 | 247865 | 2020-06-17 | Jefferson | Missouri | 29099 | 445 | 20 |
244752 | 244752 | 2020-06-16 | Jefferson | Missouri | 29099 | 439 | 20 |
241641 | 241641 | 2020-06-15 | Jefferson | Missouri | 29099 | 432 | 20 |
238531 | 238531 | 2020-06-14 | Jefferson | Missouri | 29099 | 428 | 20 |
235424 | 235424 | 2020-06-13 | Jefferson | Missouri | 29099 | 428 | 20 |
232318 | 232318 | 2020-06-12 | Jefferson | Missouri | 29099 | 428 | 20 |
229214 | 229214 | 2020-06-11 | Jefferson | Missouri | 29099 | 427 | 20 |
226111 | 226111 | 2020-06-10 | Jefferson | Missouri | 29099 | 411 | 20 |
223013 | 223013 | 2020-06-09 | Jefferson | Missouri | 29099 | 411 | 20 |
219918 | 219918 | 2020-06-08 | Jefferson | Missouri | 29099 | 407 | 19 |
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);