ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Johnson" and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
253309 | 253309 | 2020-06-19 | Johnson | Indiana | 18081 | 1213 | 124 |
256429 | 256429 | 2020-06-20 | Johnson | Indiana | 18081 | 1217 | 125 |
259555 | 259555 | 2020-06-21 | Johnson | Indiana | 18081 | 1228 | 125 |
262682 | 262682 | 2020-06-22 | Johnson | Indiana | 18081 | 1228 | 125 |
265810 | 265810 | 2020-06-23 | Johnson | Indiana | 18081 | 1233 | 125 |
268940 | 268940 | 2020-06-24 | Johnson | Indiana | 18081 | 1233 | 125 |
272077 | 272077 | 2020-06-25 | Johnson | Indiana | 18081 | 1233 | 125 |
275219 | 275219 | 2020-06-26 | Johnson | Indiana | 18081 | 1240 | 125 |
278367 | 278367 | 2020-06-27 | Johnson | Indiana | 18081 | 1248 | 125 |
281515 | 281515 | 2020-06-28 | Johnson | Indiana | 18081 | 1255 | 125 |
284660 | 284660 | 2020-06-29 | Johnson | Indiana | 18081 | 1259 | 125 |
287809 | 287809 | 2020-06-30 | Johnson | Indiana | 18081 | 1260 | 126 |
290959 | 290959 | 2020-07-01 | Johnson | Indiana | 18081 | 1263 | 126 |
294113 | 294113 | 2020-07-02 | Johnson | Indiana | 18081 | 1272 | 126 |
297271 | 297271 | 2020-07-03 | Johnson | Indiana | 18081 | 1283 | 126 |
300433 | 300433 | 2020-07-04 | Johnson | Indiana | 18081 | 1285 | 126 |
303597 | 303597 | 2020-07-05 | Johnson | Indiana | 18081 | 1307 | 126 |
306762 | 306762 | 2020-07-06 | Johnson | Indiana | 18081 | 1317 | 126 |
309930 | 309930 | 2020-07-07 | Johnson | Indiana | 18081 | 1317 | 125 |
313100 | 313100 | 2020-07-08 | Johnson | Indiana | 18081 | 1326 | 126 |
316274 | 316274 | 2020-07-09 | Johnson | Indiana | 18081 | 1336 | 126 |
319447 | 319447 | 2020-07-10 | Johnson | Indiana | 18081 | 1355 | 126 |
322626 | 322626 | 2020-07-11 | Johnson | Indiana | 18081 | 1370 | 126 |
325807 | 325807 | 2020-07-12 | Johnson | Indiana | 18081 | 1375 | 126 |
328993 | 328993 | 2020-07-13 | Johnson | Indiana | 18081 | 1381 | 126 |
332180 | 332180 | 2020-07-14 | Johnson | Indiana | 18081 | 1397 | 126 |
335373 | 335373 | 2020-07-15 | Johnson | Indiana | 18081 | 1410 | 126 |
338569 | 338569 | 2020-07-16 | Johnson | Indiana | 18081 | 1425 | 126 |
341765 | 341765 | 2020-07-17 | Johnson | Indiana | 18081 | 1437 | 126 |
344965 | 344965 | 2020-07-18 | Johnson | Indiana | 18081 | 1450 | 126 |
348166 | 348166 | 2020-07-19 | Johnson | Indiana | 18081 | 1464 | 126 |
351366 | 351366 | 2020-07-20 | Johnson | Indiana | 18081 | 1476 | 126 |
354568 | 354568 | 2020-07-21 | Johnson | Indiana | 18081 | 1496 | 126 |
357770 | 357770 | 2020-07-22 | Johnson | Indiana | 18081 | 1508 | 126 |
360975 | 360975 | 2020-07-23 | Johnson | Indiana | 18081 | 1523 | 126 |
364182 | 364182 | 2020-07-24 | Johnson | Indiana | 18081 | 1548 | 126 |
367389 | 367389 | 2020-07-25 | Johnson | Indiana | 18081 | 1561 | 126 |
370599 | 370599 | 2020-07-26 | Johnson | Indiana | 18081 | 1581 | 126 |
373811 | 373811 | 2020-07-27 | Johnson | Indiana | 18081 | 1587 | 126 |
377026 | 377026 | 2020-07-28 | Johnson | Indiana | 18081 | 1608 | 126 |
380243 | 380243 | 2020-07-29 | Johnson | Indiana | 18081 | 1620 | 126 |
383460 | 383460 | 2020-07-30 | Johnson | Indiana | 18081 | 1634 | 126 |
386678 | 386678 | 2020-07-31 | Johnson | Indiana | 18081 | 1650 | 126 |
389895 | 389895 | 2020-08-01 | Johnson | Indiana | 18081 | 1665 | 126 |
393112 | 393112 | 2020-08-02 | Johnson | Indiana | 18081 | 1682 | 126 |
396328 | 396328 | 2020-08-03 | Johnson | Indiana | 18081 | 1686 | 126 |
399544 | 399544 | 2020-08-04 | Johnson | Indiana | 18081 | 1701 | 126 |
402760 | 402760 | 2020-08-05 | Johnson | Indiana | 18081 | 1708 | 126 |
405978 | 405978 | 2020-08-06 | Johnson | Indiana | 18081 | 1728 | 126 |
409198 | 409198 | 2020-08-07 | Johnson | Indiana | 18081 | 1753 | 126 |
412417 | 412417 | 2020-08-08 | Johnson | Indiana | 18081 | 1775 | 126 |
415637 | 415637 | 2020-08-09 | Johnson | Indiana | 18081 | 1791 | 126 |
418858 | 418858 | 2020-08-10 | Johnson | Indiana | 18081 | 1801 | 126 |
422081 | 422081 | 2020-08-11 | Johnson | Indiana | 18081 | 1823 | 127 |
425302 | 425302 | 2020-08-12 | Johnson | Indiana | 18081 | 1828 | 127 |
428526 | 428526 | 2020-08-13 | Johnson | Indiana | 18081 | 1834 | 127 |
431754 | 431754 | 2020-08-14 | Johnson | Indiana | 18081 | 1854 | 127 |
434979 | 434979 | 2020-08-15 | Johnson | Indiana | 18081 | 1868 | 127 |
438205 | 438205 | 2020-08-16 | Johnson | Indiana | 18081 | 1880 | 127 |
441431 | 441431 | 2020-08-17 | Johnson | Indiana | 18081 | 1883 | 127 |
444657 | 444657 | 2020-08-18 | Johnson | Indiana | 18081 | 1897 | 128 |
447884 | 447884 | 2020-08-19 | Johnson | Indiana | 18081 | 1906 | 128 |
451112 | 451112 | 2020-08-20 | Johnson | Indiana | 18081 | 1919 | 128 |
454340 | 454340 | 2020-08-21 | Johnson | Indiana | 18081 | 1935 | 128 |
457568 | 457568 | 2020-08-22 | Johnson | Indiana | 18081 | 1946 | 128 |
460795 | 460795 | 2020-08-23 | Johnson | Indiana | 18081 | 1953 | 128 |
464024 | 464024 | 2020-08-24 | Johnson | Indiana | 18081 | 1978 | 128 |
467253 | 467253 | 2020-08-25 | Johnson | Indiana | 18081 | 1994 | 128 |
470482 | 470482 | 2020-08-26 | Johnson | Indiana | 18081 | 2002 | 128 |
473714 | 473714 | 2020-08-27 | Johnson | Indiana | 18081 | 2029 | 128 |
476947 | 476947 | 2020-08-28 | Johnson | Indiana | 18081 | 2037 | 128 |
480180 | 480180 | 2020-08-29 | Johnson | Indiana | 18081 | 2050 | 129 |
483414 | 483414 | 2020-08-30 | Johnson | Indiana | 18081 | 2061 | 129 |
486649 | 486649 | 2020-08-31 | Johnson | Indiana | 18081 | 2071 | 129 |
489882 | 489882 | 2020-09-01 | Johnson | Indiana | 18081 | 2076 | 129 |
493115 | 493115 | 2020-09-02 | Johnson | Indiana | 18081 | 2089 | 129 |
496349 | 496349 | 2020-09-03 | Johnson | Indiana | 18081 | 2097 | 130 |
499582 | 499582 | 2020-09-04 | Johnson | Indiana | 18081 | 2103 | 131 |
502816 | 502816 | 2020-09-05 | Johnson | Indiana | 18081 | 2115 | 131 |
506050 | 506050 | 2020-09-06 | Johnson | Indiana | 18081 | 2126 | 131 |
509282 | 509282 | 2020-09-07 | Johnson | Indiana | 18081 | 2132 | 131 |
512515 | 512515 | 2020-09-08 | Johnson | Indiana | 18081 | 2134 | 131 |
515748 | 515748 | 2020-09-09 | Johnson | Indiana | 18081 | 2143 | 131 |
518983 | 518983 | 2020-09-10 | Johnson | Indiana | 18081 | 2154 | 131 |
522220 | 522220 | 2020-09-11 | Johnson | Indiana | 18081 | 2169 | 131 |
525456 | 525456 | 2020-09-12 | Johnson | Indiana | 18081 | 2176 | 131 |
528692 | 528692 | 2020-09-13 | Johnson | Indiana | 18081 | 2229 | 131 |
531929 | 531929 | 2020-09-14 | Johnson | Indiana | 18081 | 2248 | 131 |
535164 | 535164 | 2020-09-15 | Johnson | Indiana | 18081 | 2257 | 131 |
538400 | 538400 | 2020-09-16 | Johnson | Indiana | 18081 | 2266 | 131 |
541637 | 541637 | 2020-09-17 | Johnson | Indiana | 18081 | 2280 | 131 |
544873 | 544873 | 2020-09-18 | Johnson | Indiana | 18081 | 2275 | 131 |
548111 | 548111 | 2020-09-19 | Johnson | Indiana | 18081 | 2289 | 131 |
551350 | 551350 | 2020-09-20 | Johnson | Indiana | 18081 | 2296 | 131 |
554589 | 554589 | 2020-09-21 | Johnson | Indiana | 18081 | 2297 | 131 |
557826 | 557826 | 2020-09-22 | Johnson | Indiana | 18081 | 2307 | 132 |
561062 | 561062 | 2020-09-23 | Johnson | Indiana | 18081 | 2318 | 132 |
564302 | 564302 | 2020-09-24 | Johnson | Indiana | 18081 | 2330 | 132 |
567542 | 567542 | 2020-09-25 | Johnson | Indiana | 18081 | 2344 | 132 |
570784 | 570784 | 2020-09-26 | Johnson | Indiana | 18081 | 2367 | 133 |
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);