ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "St. Joseph" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535197 | 535197 | 2020-09-15 | St. Joseph | Indiana | 18141 | 5822 | 102 |
531962 | 531962 | 2020-09-14 | St. Joseph | Indiana | 18141 | 5790 | 102 |
528725 | 528725 | 2020-09-13 | St. Joseph | Indiana | 18141 | 5741 | 102 |
525489 | 525489 | 2020-09-12 | St. Joseph | Indiana | 18141 | 5658 | 102 |
522253 | 522253 | 2020-09-11 | St. Joseph | Indiana | 18141 | 5619 | 102 |
519016 | 519016 | 2020-09-10 | St. Joseph | Indiana | 18141 | 5574 | 102 |
515781 | 515781 | 2020-09-09 | St. Joseph | Indiana | 18141 | 5559 | 102 |
512548 | 512548 | 2020-09-08 | St. Joseph | Indiana | 18141 | 5488 | 101 |
509315 | 509315 | 2020-09-07 | St. Joseph | Indiana | 18141 | 5472 | 101 |
506083 | 506083 | 2020-09-06 | St. Joseph | Indiana | 18141 | 5450 | 101 |
502849 | 502849 | 2020-09-05 | St. Joseph | Indiana | 18141 | 5409 | 101 |
499615 | 499615 | 2020-09-04 | St. Joseph | Indiana | 18141 | 5355 | 100 |
496382 | 496382 | 2020-09-03 | St. Joseph | Indiana | 18141 | 5311 | 100 |
493148 | 493148 | 2020-09-02 | St. Joseph | Indiana | 18141 | 5233 | 99 |
489915 | 489915 | 2020-09-01 | St. Joseph | Indiana | 18141 | 5197 | 99 |
486682 | 486682 | 2020-08-31 | St. Joseph | Indiana | 18141 | 5168 | 97 |
483447 | 483447 | 2020-08-30 | St. Joseph | Indiana | 18141 | 5117 | 97 |
480213 | 480213 | 2020-08-29 | St. Joseph | Indiana | 18141 | 5044 | 97 |
476980 | 476980 | 2020-08-28 | St. Joseph | Indiana | 18141 | 4986 | 97 |
473747 | 473747 | 2020-08-27 | St. Joseph | Indiana | 18141 | 4939 | 95 |
470515 | 470515 | 2020-08-26 | St. Joseph | Indiana | 18141 | 4840 | 95 |
467286 | 467286 | 2020-08-25 | St. Joseph | Indiana | 18141 | 4709 | 95 |
464057 | 464057 | 2020-08-24 | St. Joseph | Indiana | 18141 | 4557 | 93 |
460828 | 460828 | 2020-08-23 | St. Joseph | Indiana | 18141 | 4245 | 93 |
457601 | 457601 | 2020-08-22 | St. Joseph | Indiana | 18141 | 4194 | 93 |
454373 | 454373 | 2020-08-21 | St. Joseph | Indiana | 18141 | 4121 | 92 |
451145 | 451145 | 2020-08-20 | St. Joseph | Indiana | 18141 | 4057 | 92 |
447917 | 447917 | 2020-08-19 | St. Joseph | Indiana | 18141 | 3986 | 92 |
444690 | 444690 | 2020-08-18 | St. Joseph | Indiana | 18141 | 3953 | 92 |
441464 | 441464 | 2020-08-17 | St. Joseph | Indiana | 18141 | 3898 | 90 |
438238 | 438238 | 2020-08-16 | St. Joseph | Indiana | 18141 | 3857 | 88 |
435012 | 435012 | 2020-08-15 | St. Joseph | Indiana | 18141 | 3821 | 88 |
431787 | 431787 | 2020-08-14 | St. Joseph | Indiana | 18141 | 3778 | 88 |
428559 | 428559 | 2020-08-13 | St. Joseph | Indiana | 18141 | 3693 | 88 |
425335 | 425335 | 2020-08-12 | St. Joseph | Indiana | 18141 | 3622 | 88 |
422114 | 422114 | 2020-08-11 | St. Joseph | Indiana | 18141 | 3589 | 88 |
418891 | 418891 | 2020-08-10 | St. Joseph | Indiana | 18141 | 3557 | 87 |
415670 | 415670 | 2020-08-09 | St. Joseph | Indiana | 18141 | 3511 | 86 |
412450 | 412450 | 2020-08-08 | St. Joseph | Indiana | 18141 | 3434 | 86 |
409231 | 409231 | 2020-08-07 | St. Joseph | Indiana | 18141 | 3384 | 86 |
406011 | 406011 | 2020-08-06 | St. Joseph | Indiana | 18141 | 3312 | 84 |
402793 | 402793 | 2020-08-05 | St. Joseph | Indiana | 18141 | 3235 | 84 |
399577 | 399577 | 2020-08-04 | St. Joseph | Indiana | 18141 | 3214 | 84 |
396361 | 396361 | 2020-08-03 | St. Joseph | Indiana | 18141 | 3165 | 84 |
393145 | 393145 | 2020-08-02 | St. Joseph | Indiana | 18141 | 3125 | 84 |
389928 | 389928 | 2020-08-01 | St. Joseph | Indiana | 18141 | 3082 | 84 |
386711 | 386711 | 2020-07-31 | St. Joseph | Indiana | 18141 | 3026 | 84 |
383493 | 383493 | 2020-07-30 | St. Joseph | Indiana | 18141 | 2978 | 83 |
380276 | 380276 | 2020-07-29 | St. Joseph | Indiana | 18141 | 2904 | 82 |
377059 | 377059 | 2020-07-28 | St. Joseph | Indiana | 18141 | 2865 | 81 |
373844 | 373844 | 2020-07-27 | St. Joseph | Indiana | 18141 | 2841 | 81 |
370632 | 370632 | 2020-07-26 | St. Joseph | Indiana | 18141 | 2812 | 81 |
367422 | 367422 | 2020-07-25 | St. Joseph | Indiana | 18141 | 2754 | 80 |
364215 | 364215 | 2020-07-24 | St. Joseph | Indiana | 18141 | 2727 | 80 |
361008 | 361008 | 2020-07-23 | St. Joseph | Indiana | 18141 | 2661 | 80 |
357803 | 357803 | 2020-07-22 | St. Joseph | Indiana | 18141 | 2616 | 79 |
354601 | 354601 | 2020-07-21 | St. Joseph | Indiana | 18141 | 2564 | 79 |
351399 | 351399 | 2020-07-20 | St. Joseph | Indiana | 18141 | 2535 | 79 |
348199 | 348199 | 2020-07-19 | St. Joseph | Indiana | 18141 | 2502 | 78 |
344998 | 344998 | 2020-07-18 | St. Joseph | Indiana | 18141 | 2444 | 77 |
341798 | 341798 | 2020-07-17 | St. Joseph | Indiana | 18141 | 2400 | 77 |
338602 | 338602 | 2020-07-16 | St. Joseph | Indiana | 18141 | 2332 | 76 |
335406 | 335406 | 2020-07-15 | St. Joseph | Indiana | 18141 | 2305 | 75 |
332213 | 332213 | 2020-07-14 | St. Joseph | Indiana | 18141 | 2245 | 75 |
329026 | 329026 | 2020-07-13 | St. Joseph | Indiana | 18141 | 2221 | 74 |
325840 | 325840 | 2020-07-12 | St. Joseph | Indiana | 18141 | 2158 | 74 |
322659 | 322659 | 2020-07-11 | St. Joseph | Indiana | 18141 | 2116 | 74 |
319480 | 319480 | 2020-07-10 | St. Joseph | Indiana | 18141 | 2061 | 74 |
316307 | 316307 | 2020-07-09 | St. Joseph | Indiana | 18141 | 2035 | 74 |
313133 | 313133 | 2020-07-08 | St. Joseph | Indiana | 18141 | 2011 | 74 |
309963 | 309963 | 2020-07-07 | St. Joseph | Indiana | 18141 | 1991 | 73 |
306795 | 306795 | 2020-07-06 | St. Joseph | Indiana | 18141 | 1974 | 71 |
303630 | 303630 | 2020-07-05 | St. Joseph | Indiana | 18141 | 1953 | 71 |
300466 | 300466 | 2020-07-04 | St. Joseph | Indiana | 18141 | 1918 | 71 |
297304 | 297304 | 2020-07-03 | St. Joseph | Indiana | 18141 | 1873 | 71 |
294146 | 294146 | 2020-07-02 | St. Joseph | Indiana | 18141 | 1867 | 71 |
290992 | 290992 | 2020-07-01 | St. Joseph | Indiana | 18141 | 1859 | 70 |
287842 | 287842 | 2020-06-30 | St. Joseph | Indiana | 18141 | 1840 | 70 |
284693 | 284693 | 2020-06-29 | St. Joseph | Indiana | 18141 | 1829 | 70 |
281548 | 281548 | 2020-06-28 | St. Joseph | Indiana | 18141 | 1822 | 69 |
278400 | 278400 | 2020-06-27 | St. Joseph | Indiana | 18141 | 1808 | 67 |
275252 | 275252 | 2020-06-26 | St. Joseph | Indiana | 18141 | 1790 | 65 |
272110 | 272110 | 2020-06-25 | St. Joseph | Indiana | 18141 | 1750 | 64 |
268973 | 268973 | 2020-06-24 | St. Joseph | Indiana | 18141 | 1715 | 64 |
265843 | 265843 | 2020-06-23 | St. Joseph | Indiana | 18141 | 1697 | 63 |
262715 | 262715 | 2020-06-22 | St. Joseph | Indiana | 18141 | 1687 | 62 |
259588 | 259588 | 2020-06-21 | St. Joseph | Indiana | 18141 | 1672 | 61 |
256462 | 256462 | 2020-06-20 | St. Joseph | Indiana | 18141 | 1656 | 61 |
253342 | 253342 | 2020-06-19 | St. Joseph | Indiana | 18141 | 1638 | 58 |
250227 | 250227 | 2020-06-18 | St. Joseph | Indiana | 18141 | 1622 | 58 |
247115 | 247115 | 2020-06-17 | St. Joseph | Indiana | 18141 | 1593 | 58 |
244002 | 244002 | 2020-06-16 | St. Joseph | Indiana | 18141 | 1580 | 56 |
240891 | 240891 | 2020-06-15 | St. Joseph | Indiana | 18141 | 1561 | 55 |
237783 | 237783 | 2020-06-14 | St. Joseph | Indiana | 18141 | 1548 | 55 |
234676 | 234676 | 2020-06-13 | St. Joseph | Indiana | 18141 | 1521 | 55 |
231570 | 231570 | 2020-06-12 | St. Joseph | Indiana | 18141 | 1505 | 55 |
228467 | 228467 | 2020-06-11 | St. Joseph | Indiana | 18141 | 1491 | 50 |
225365 | 225365 | 2020-06-10 | St. Joseph | Indiana | 18141 | 1463 | 49 |
222270 | 222270 | 2020-06-09 | St. Joseph | Indiana | 18141 | 1447 | 48 |
219175 | 219175 | 2020-06-08 | St. Joseph | Indiana | 18141 | 1428 | 47 |
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);