ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Elkhart" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535143 | 535143 | 2020-09-15 | Elkhart | Indiana | 18039 | 6212 | 109 |
531908 | 531908 | 2020-09-14 | Elkhart | Indiana | 18039 | 6161 | 108 |
528671 | 528671 | 2020-09-13 | Elkhart | Indiana | 18039 | 6136 | 108 |
525435 | 525435 | 2020-09-12 | Elkhart | Indiana | 18039 | 6090 | 108 |
522199 | 522199 | 2020-09-11 | Elkhart | Indiana | 18039 | 6032 | 107 |
518962 | 518962 | 2020-09-10 | Elkhart | Indiana | 18039 | 5991 | 106 |
515727 | 515727 | 2020-09-09 | Elkhart | Indiana | 18039 | 5967 | 105 |
512494 | 512494 | 2020-09-08 | Elkhart | Indiana | 18039 | 5929 | 105 |
509261 | 509261 | 2020-09-07 | Elkhart | Indiana | 18039 | 5916 | 103 |
506029 | 506029 | 2020-09-06 | Elkhart | Indiana | 18039 | 5906 | 103 |
502795 | 502795 | 2020-09-05 | Elkhart | Indiana | 18039 | 5883 | 103 |
499561 | 499561 | 2020-09-04 | Elkhart | Indiana | 18039 | 5838 | 103 |
496328 | 496328 | 2020-09-03 | Elkhart | Indiana | 18039 | 5793 | 102 |
493094 | 493094 | 2020-09-02 | Elkhart | Indiana | 18039 | 5722 | 102 |
489861 | 489861 | 2020-09-01 | Elkhart | Indiana | 18039 | 5702 | 102 |
486628 | 486628 | 2020-08-31 | Elkhart | Indiana | 18039 | 5693 | 102 |
483393 | 483393 | 2020-08-30 | Elkhart | Indiana | 18039 | 5668 | 102 |
480159 | 480159 | 2020-08-29 | Elkhart | Indiana | 18039 | 5645 | 102 |
476926 | 476926 | 2020-08-28 | Elkhart | Indiana | 18039 | 5603 | 102 |
473693 | 473693 | 2020-08-27 | Elkhart | Indiana | 18039 | 5576 | 101 |
470461 | 470461 | 2020-08-26 | Elkhart | Indiana | 18039 | 5530 | 101 |
467232 | 467232 | 2020-08-25 | Elkhart | Indiana | 18039 | 5489 | 101 |
464003 | 464003 | 2020-08-24 | Elkhart | Indiana | 18039 | 5475 | 99 |
460774 | 460774 | 2020-08-23 | Elkhart | Indiana | 18039 | 5431 | 99 |
457547 | 457547 | 2020-08-22 | Elkhart | Indiana | 18039 | 5405 | 99 |
454319 | 454319 | 2020-08-21 | Elkhart | Indiana | 18039 | 5356 | 99 |
451091 | 451091 | 2020-08-20 | Elkhart | Indiana | 18039 | 5329 | 97 |
447863 | 447863 | 2020-08-19 | Elkhart | Indiana | 18039 | 5300 | 97 |
444636 | 444636 | 2020-08-18 | Elkhart | Indiana | 18039 | 5280 | 97 |
441410 | 441410 | 2020-08-17 | Elkhart | Indiana | 18039 | 5243 | 96 |
438184 | 438184 | 2020-08-16 | Elkhart | Indiana | 18039 | 5210 | 96 |
434958 | 434958 | 2020-08-15 | Elkhart | Indiana | 18039 | 5192 | 96 |
431733 | 431733 | 2020-08-14 | Elkhart | Indiana | 18039 | 5141 | 95 |
428505 | 428505 | 2020-08-13 | Elkhart | Indiana | 18039 | 5082 | 91 |
425281 | 425281 | 2020-08-12 | Elkhart | Indiana | 18039 | 5046 | 91 |
422060 | 422060 | 2020-08-11 | Elkhart | Indiana | 18039 | 5016 | 89 |
418837 | 418837 | 2020-08-10 | Elkhart | Indiana | 18039 | 4973 | 89 |
415616 | 415616 | 2020-08-09 | Elkhart | Indiana | 18039 | 4933 | 88 |
412396 | 412396 | 2020-08-08 | Elkhart | Indiana | 18039 | 4891 | 88 |
409177 | 409177 | 2020-08-07 | Elkhart | Indiana | 18039 | 4850 | 86 |
405957 | 405957 | 2020-08-06 | Elkhart | Indiana | 18039 | 4803 | 84 |
402739 | 402739 | 2020-08-05 | Elkhart | Indiana | 18039 | 4770 | 83 |
399523 | 399523 | 2020-08-04 | Elkhart | Indiana | 18039 | 4720 | 81 |
396307 | 396307 | 2020-08-03 | Elkhart | Indiana | 18039 | 4687 | 81 |
393091 | 393091 | 2020-08-02 | Elkhart | Indiana | 18039 | 4672 | 80 |
389874 | 389874 | 2020-08-01 | Elkhart | Indiana | 18039 | 4656 | 80 |
386657 | 386657 | 2020-07-31 | Elkhart | Indiana | 18039 | 4609 | 80 |
383439 | 383439 | 2020-07-30 | Elkhart | Indiana | 18039 | 4555 | 79 |
380222 | 380222 | 2020-07-29 | Elkhart | Indiana | 18039 | 4511 | 76 |
377005 | 377005 | 2020-07-28 | Elkhart | Indiana | 18039 | 4487 | 76 |
373790 | 373790 | 2020-07-27 | Elkhart | Indiana | 18039 | 4466 | 75 |
370578 | 370578 | 2020-07-26 | Elkhart | Indiana | 18039 | 4434 | 74 |
367368 | 367368 | 2020-07-25 | Elkhart | Indiana | 18039 | 4396 | 74 |
364161 | 364161 | 2020-07-24 | Elkhart | Indiana | 18039 | 4332 | 74 |
360954 | 360954 | 2020-07-23 | Elkhart | Indiana | 18039 | 4277 | 74 |
357749 | 357749 | 2020-07-22 | Elkhart | Indiana | 18039 | 4238 | 73 |
354547 | 354547 | 2020-07-21 | Elkhart | Indiana | 18039 | 4167 | 72 |
351345 | 351345 | 2020-07-20 | Elkhart | Indiana | 18039 | 4133 | 68 |
348145 | 348145 | 2020-07-19 | Elkhart | Indiana | 18039 | 4086 | 68 |
344944 | 344944 | 2020-07-18 | Elkhart | Indiana | 18039 | 4014 | 68 |
341744 | 341744 | 2020-07-17 | Elkhart | Indiana | 18039 | 3975 | 67 |
338548 | 338548 | 2020-07-16 | Elkhart | Indiana | 18039 | 3920 | 66 |
335352 | 335352 | 2020-07-15 | Elkhart | Indiana | 18039 | 3880 | 66 |
332159 | 332159 | 2020-07-14 | Elkhart | Indiana | 18039 | 3806 | 65 |
328972 | 328972 | 2020-07-13 | Elkhart | Indiana | 18039 | 3748 | 64 |
325786 | 325786 | 2020-07-12 | Elkhart | Indiana | 18039 | 3704 | 64 |
322605 | 322605 | 2020-07-11 | Elkhart | Indiana | 18039 | 3625 | 63 |
319426 | 319426 | 2020-07-10 | Elkhart | Indiana | 18039 | 3555 | 62 |
316253 | 316253 | 2020-07-09 | Elkhart | Indiana | 18039 | 3517 | 61 |
313079 | 313079 | 2020-07-08 | Elkhart | Indiana | 18039 | 3487 | 59 |
309909 | 309909 | 2020-07-07 | Elkhart | Indiana | 18039 | 3405 | 55 |
306741 | 306741 | 2020-07-06 | Elkhart | Indiana | 18039 | 3386 | 50 |
303576 | 303576 | 2020-07-05 | Elkhart | Indiana | 18039 | 3346 | 50 |
300412 | 300412 | 2020-07-04 | Elkhart | Indiana | 18039 | 3272 | 48 |
297250 | 297250 | 2020-07-03 | Elkhart | Indiana | 18039 | 3225 | 47 |
294092 | 294092 | 2020-07-02 | Elkhart | Indiana | 18039 | 3194 | 47 |
290938 | 290938 | 2020-07-01 | Elkhart | Indiana | 18039 | 3146 | 47 |
287788 | 287788 | 2020-06-30 | Elkhart | Indiana | 18039 | 3101 | 46 |
284639 | 284639 | 2020-06-29 | Elkhart | Indiana | 18039 | 3063 | 45 |
281494 | 281494 | 2020-06-28 | Elkhart | Indiana | 18039 | 3036 | 45 |
278346 | 278346 | 2020-06-27 | Elkhart | Indiana | 18039 | 2988 | 45 |
275198 | 275198 | 2020-06-26 | Elkhart | Indiana | 18039 | 2921 | 44 |
272056 | 272056 | 2020-06-25 | Elkhart | Indiana | 18039 | 2862 | 44 |
268919 | 268919 | 2020-06-24 | Elkhart | Indiana | 18039 | 2761 | 43 |
265789 | 265789 | 2020-06-23 | Elkhart | Indiana | 18039 | 2721 | 42 |
262661 | 262661 | 2020-06-22 | Elkhart | Indiana | 18039 | 2680 | 41 |
259534 | 259534 | 2020-06-21 | Elkhart | Indiana | 18039 | 2658 | 41 |
256408 | 256408 | 2020-06-20 | Elkhart | Indiana | 18039 | 2593 | 41 |
253288 | 253288 | 2020-06-19 | Elkhart | Indiana | 18039 | 2532 | 41 |
250173 | 250173 | 2020-06-18 | Elkhart | Indiana | 18039 | 2454 | 38 |
247061 | 247061 | 2020-06-17 | Elkhart | Indiana | 18039 | 2330 | 37 |
243948 | 243948 | 2020-06-16 | Elkhart | Indiana | 18039 | 2295 | 37 |
240837 | 240837 | 2020-06-15 | Elkhart | Indiana | 18039 | 2213 | 36 |
237729 | 237729 | 2020-06-14 | Elkhart | Indiana | 18039 | 2126 | 36 |
234622 | 234622 | 2020-06-13 | Elkhart | Indiana | 18039 | 2075 | 34 |
231516 | 231516 | 2020-06-12 | Elkhart | Indiana | 18039 | 1955 | 34 |
228413 | 228413 | 2020-06-11 | Elkhart | Indiana | 18039 | 1902 | 32 |
225311 | 225311 | 2020-06-10 | Elkhart | Indiana | 18039 | 1858 | 31 |
222216 | 222216 | 2020-06-09 | Elkhart | Indiana | 18039 | 1826 | 31 |
219121 | 219121 | 2020-06-08 | Elkhart | Indiana | 18039 | 1767 | 31 |
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);