ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 18063 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535155 | 535155 | 2020-09-15 | Hendricks | Indiana | 18063 | 2605 | 137 |
531920 | 531920 | 2020-09-14 | Hendricks | Indiana | 18063 | 2595 | 136 |
528683 | 528683 | 2020-09-13 | Hendricks | Indiana | 18063 | 2579 | 137 |
525447 | 525447 | 2020-09-12 | Hendricks | Indiana | 18063 | 2560 | 137 |
522211 | 522211 | 2020-09-11 | Hendricks | Indiana | 18063 | 2544 | 136 |
518974 | 518974 | 2020-09-10 | Hendricks | Indiana | 18063 | 2521 | 135 |
515739 | 515739 | 2020-09-09 | Hendricks | Indiana | 18063 | 2513 | 135 |
512506 | 512506 | 2020-09-08 | Hendricks | Indiana | 18063 | 2500 | 135 |
509273 | 509273 | 2020-09-07 | Hendricks | Indiana | 18063 | 2493 | 134 |
506041 | 506041 | 2020-09-06 | Hendricks | Indiana | 18063 | 2482 | 134 |
502807 | 502807 | 2020-09-05 | Hendricks | Indiana | 18063 | 2467 | 133 |
499573 | 499573 | 2020-09-04 | Hendricks | Indiana | 18063 | 2445 | 130 |
496340 | 496340 | 2020-09-03 | Hendricks | Indiana | 18063 | 2423 | 130 |
493106 | 493106 | 2020-09-02 | Hendricks | Indiana | 18063 | 2403 | 130 |
489873 | 489873 | 2020-09-01 | Hendricks | Indiana | 18063 | 2368 | 130 |
486640 | 486640 | 2020-08-31 | Hendricks | Indiana | 18063 | 2357 | 128 |
483405 | 483405 | 2020-08-30 | Hendricks | Indiana | 18063 | 2332 | 128 |
480171 | 480171 | 2020-08-29 | Hendricks | Indiana | 18063 | 2313 | 128 |
476938 | 476938 | 2020-08-28 | Hendricks | Indiana | 18063 | 2283 | 128 |
473705 | 473705 | 2020-08-27 | Hendricks | Indiana | 18063 | 2269 | 128 |
470473 | 470473 | 2020-08-26 | Hendricks | Indiana | 18063 | 2232 | 128 |
467244 | 467244 | 2020-08-25 | Hendricks | Indiana | 18063 | 2216 | 128 |
464015 | 464015 | 2020-08-24 | Hendricks | Indiana | 18063 | 2199 | 127 |
460786 | 460786 | 2020-08-23 | Hendricks | Indiana | 18063 | 2180 | 127 |
457559 | 457559 | 2020-08-22 | Hendricks | Indiana | 18063 | 2152 | 127 |
454331 | 454331 | 2020-08-21 | Hendricks | Indiana | 18063 | 2130 | 127 |
451103 | 451103 | 2020-08-20 | Hendricks | Indiana | 18063 | 2099 | 127 |
447875 | 447875 | 2020-08-19 | Hendricks | Indiana | 18063 | 2072 | 125 |
444648 | 444648 | 2020-08-18 | Hendricks | Indiana | 18063 | 2065 | 125 |
441422 | 441422 | 2020-08-17 | Hendricks | Indiana | 18063 | 2045 | 125 |
438196 | 438196 | 2020-08-16 | Hendricks | Indiana | 18063 | 2042 | 125 |
434970 | 434970 | 2020-08-15 | Hendricks | Indiana | 18063 | 2023 | 125 |
431745 | 431745 | 2020-08-14 | Hendricks | Indiana | 18063 | 2005 | 125 |
428517 | 428517 | 2020-08-13 | Hendricks | Indiana | 18063 | 1999 | 125 |
425293 | 425293 | 2020-08-12 | Hendricks | Indiana | 18063 | 1970 | 124 |
422072 | 422072 | 2020-08-11 | Hendricks | Indiana | 18063 | 1953 | 124 |
418849 | 418849 | 2020-08-10 | Hendricks | Indiana | 18063 | 1927 | 124 |
415628 | 415628 | 2020-08-09 | Hendricks | Indiana | 18063 | 1913 | 124 |
412408 | 412408 | 2020-08-08 | Hendricks | Indiana | 18063 | 1897 | 124 |
409189 | 409189 | 2020-08-07 | Hendricks | Indiana | 18063 | 1858 | 122 |
405969 | 405969 | 2020-08-06 | Hendricks | Indiana | 18063 | 1839 | 122 |
402751 | 402751 | 2020-08-05 | Hendricks | Indiana | 18063 | 1820 | 121 |
399535 | 399535 | 2020-08-04 | Hendricks | Indiana | 18063 | 1798 | 121 |
396319 | 396319 | 2020-08-03 | Hendricks | Indiana | 18063 | 1774 | 121 |
393103 | 393103 | 2020-08-02 | Hendricks | Indiana | 18063 | 1766 | 121 |
389886 | 389886 | 2020-08-01 | Hendricks | Indiana | 18063 | 1755 | 121 |
386669 | 386669 | 2020-07-31 | Hendricks | Indiana | 18063 | 1735 | 121 |
383451 | 383451 | 2020-07-30 | Hendricks | Indiana | 18063 | 1707 | 121 |
380234 | 380234 | 2020-07-29 | Hendricks | Indiana | 18063 | 1697 | 121 |
377017 | 377017 | 2020-07-28 | Hendricks | Indiana | 18063 | 1690 | 121 |
373802 | 373802 | 2020-07-27 | Hendricks | Indiana | 18063 | 1684 | 121 |
370590 | 370590 | 2020-07-26 | Hendricks | Indiana | 18063 | 1668 | 121 |
367380 | 367380 | 2020-07-25 | Hendricks | Indiana | 18063 | 1654 | 121 |
364173 | 364173 | 2020-07-24 | Hendricks | Indiana | 18063 | 1635 | 121 |
360966 | 360966 | 2020-07-23 | Hendricks | Indiana | 18063 | 1618 | 121 |
357761 | 357761 | 2020-07-22 | Hendricks | Indiana | 18063 | 1598 | 120 |
354559 | 354559 | 2020-07-21 | Hendricks | Indiana | 18063 | 1597 | 122 |
351357 | 351357 | 2020-07-20 | Hendricks | Indiana | 18063 | 1584 | 119 |
348157 | 348157 | 2020-07-19 | Hendricks | Indiana | 18063 | 1575 | 119 |
344956 | 344956 | 2020-07-18 | Hendricks | Indiana | 18063 | 1563 | 119 |
341756 | 341756 | 2020-07-17 | Hendricks | Indiana | 18063 | 1543 | 118 |
338560 | 338560 | 2020-07-16 | Hendricks | Indiana | 18063 | 1525 | 118 |
335364 | 335364 | 2020-07-15 | Hendricks | Indiana | 18063 | 1520 | 118 |
332171 | 332171 | 2020-07-14 | Hendricks | Indiana | 18063 | 1506 | 116 |
328984 | 328984 | 2020-07-13 | Hendricks | Indiana | 18063 | 1494 | 116 |
325798 | 325798 | 2020-07-12 | Hendricks | Indiana | 18063 | 1490 | 116 |
322617 | 322617 | 2020-07-11 | Hendricks | Indiana | 18063 | 1478 | 116 |
319438 | 319438 | 2020-07-10 | Hendricks | Indiana | 18063 | 1470 | 116 |
316265 | 316265 | 2020-07-09 | Hendricks | Indiana | 18063 | 1463 | 116 |
313091 | 313091 | 2020-07-08 | Hendricks | Indiana | 18063 | 1449 | 116 |
309921 | 309921 | 2020-07-07 | Hendricks | Indiana | 18063 | 1438 | 116 |
306753 | 306753 | 2020-07-06 | Hendricks | Indiana | 18063 | 1434 | 116 |
303588 | 303588 | 2020-07-05 | Hendricks | Indiana | 18063 | 1427 | 116 |
300424 | 300424 | 2020-07-04 | Hendricks | Indiana | 18063 | 1414 | 116 |
297262 | 297262 | 2020-07-03 | Hendricks | Indiana | 18063 | 1410 | 116 |
294104 | 294104 | 2020-07-02 | Hendricks | Indiana | 18063 | 1395 | 116 |
290950 | 290950 | 2020-07-01 | Hendricks | Indiana | 18063 | 1390 | 115 |
287800 | 287800 | 2020-06-30 | Hendricks | Indiana | 18063 | 1390 | 115 |
284651 | 284651 | 2020-06-29 | Hendricks | Indiana | 18063 | 1385 | 115 |
281506 | 281506 | 2020-06-28 | Hendricks | Indiana | 18063 | 1382 | 115 |
278358 | 278358 | 2020-06-27 | Hendricks | Indiana | 18063 | 1380 | 115 |
275210 | 275210 | 2020-06-26 | Hendricks | Indiana | 18063 | 1372 | 113 |
272068 | 272068 | 2020-06-25 | Hendricks | Indiana | 18063 | 1370 | 113 |
268931 | 268931 | 2020-06-24 | Hendricks | Indiana | 18063 | 1361 | 111 |
265801 | 265801 | 2020-06-23 | Hendricks | Indiana | 18063 | 1351 | 110 |
262673 | 262673 | 2020-06-22 | Hendricks | Indiana | 18063 | 1344 | 110 |
259546 | 259546 | 2020-06-21 | Hendricks | Indiana | 18063 | 1342 | 110 |
256420 | 256420 | 2020-06-20 | Hendricks | Indiana | 18063 | 1331 | 110 |
253300 | 253300 | 2020-06-19 | Hendricks | Indiana | 18063 | 1319 | 109 |
250185 | 250185 | 2020-06-18 | Hendricks | Indiana | 18063 | 1309 | 108 |
247073 | 247073 | 2020-06-17 | Hendricks | Indiana | 18063 | 1305 | 107 |
243960 | 243960 | 2020-06-16 | Hendricks | Indiana | 18063 | 1303 | 106 |
240849 | 240849 | 2020-06-15 | Hendricks | Indiana | 18063 | 1298 | 106 |
237741 | 237741 | 2020-06-14 | Hendricks | Indiana | 18063 | 1292 | 105 |
234634 | 234634 | 2020-06-13 | Hendricks | Indiana | 18063 | 1288 | 104 |
231528 | 231528 | 2020-06-12 | Hendricks | Indiana | 18063 | 1283 | 104 |
228425 | 228425 | 2020-06-11 | Hendricks | Indiana | 18063 | 1268 | 100 |
225323 | 225323 | 2020-06-10 | Hendricks | Indiana | 18063 | 1256 | 97 |
222228 | 222228 | 2020-06-09 | Hendricks | Indiana | 18063 | 1245 | 96 |
219133 | 219133 | 2020-06-08 | Hendricks | Indiana | 18063 | 1240 | 93 |
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);