ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Hamilton" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535152 | 535152 | 2020-09-15 | Hamilton | Indiana | 18057 | 4578 | 118 |
531917 | 531917 | 2020-09-14 | Hamilton | Indiana | 18057 | 4568 | 117 |
528680 | 528680 | 2020-09-13 | Hamilton | Indiana | 18057 | 4546 | 117 |
525444 | 525444 | 2020-09-12 | Hamilton | Indiana | 18057 | 4457 | 117 |
522208 | 522208 | 2020-09-11 | Hamilton | Indiana | 18057 | 4401 | 116 |
518971 | 518971 | 2020-09-10 | Hamilton | Indiana | 18057 | 4339 | 116 |
515736 | 515736 | 2020-09-09 | Hamilton | Indiana | 18057 | 4290 | 116 |
512503 | 512503 | 2020-09-08 | Hamilton | Indiana | 18057 | 4272 | 116 |
509270 | 509270 | 2020-09-07 | Hamilton | Indiana | 18057 | 4254 | 116 |
506038 | 506038 | 2020-09-06 | Hamilton | Indiana | 18057 | 4232 | 116 |
502804 | 502804 | 2020-09-05 | Hamilton | Indiana | 18057 | 4184 | 116 |
499570 | 499570 | 2020-09-04 | Hamilton | Indiana | 18057 | 4132 | 116 |
496337 | 496337 | 2020-09-03 | Hamilton | Indiana | 18057 | 4087 | 116 |
493103 | 493103 | 2020-09-02 | Hamilton | Indiana | 18057 | 4029 | 116 |
489870 | 489870 | 2020-09-01 | Hamilton | Indiana | 18057 | 3988 | 116 |
486637 | 486637 | 2020-08-31 | Hamilton | Indiana | 18057 | 3945 | 116 |
483402 | 483402 | 2020-08-30 | Hamilton | Indiana | 18057 | 3883 | 116 |
480168 | 480168 | 2020-08-29 | Hamilton | Indiana | 18057 | 3842 | 116 |
476935 | 476935 | 2020-08-28 | Hamilton | Indiana | 18057 | 3771 | 116 |
473702 | 473702 | 2020-08-27 | Hamilton | Indiana | 18057 | 3723 | 116 |
470470 | 470470 | 2020-08-26 | Hamilton | Indiana | 18057 | 3670 | 116 |
467241 | 467241 | 2020-08-25 | Hamilton | Indiana | 18057 | 3619 | 115 |
464012 | 464012 | 2020-08-24 | Hamilton | Indiana | 18057 | 3560 | 115 |
460783 | 460783 | 2020-08-23 | Hamilton | Indiana | 18057 | 3454 | 115 |
457556 | 457556 | 2020-08-22 | Hamilton | Indiana | 18057 | 3430 | 115 |
454328 | 454328 | 2020-08-21 | Hamilton | Indiana | 18057 | 3374 | 115 |
451100 | 451100 | 2020-08-20 | Hamilton | Indiana | 18057 | 3339 | 115 |
447872 | 447872 | 2020-08-19 | Hamilton | Indiana | 18057 | 3296 | 115 |
444645 | 444645 | 2020-08-18 | Hamilton | Indiana | 18057 | 3262 | 115 |
441419 | 441419 | 2020-08-17 | Hamilton | Indiana | 18057 | 3200 | 114 |
438193 | 438193 | 2020-08-16 | Hamilton | Indiana | 18057 | 3175 | 114 |
434967 | 434967 | 2020-08-15 | Hamilton | Indiana | 18057 | 3134 | 114 |
431742 | 431742 | 2020-08-14 | Hamilton | Indiana | 18057 | 3064 | 113 |
428514 | 428514 | 2020-08-13 | Hamilton | Indiana | 18057 | 2972 | 113 |
425290 | 425290 | 2020-08-12 | Hamilton | Indiana | 18057 | 2918 | 113 |
422069 | 422069 | 2020-08-11 | Hamilton | Indiana | 18057 | 2860 | 113 |
418846 | 418846 | 2020-08-10 | Hamilton | Indiana | 18057 | 2833 | 113 |
415625 | 415625 | 2020-08-09 | Hamilton | Indiana | 18057 | 2793 | 113 |
412405 | 412405 | 2020-08-08 | Hamilton | Indiana | 18057 | 2752 | 112 |
409186 | 409186 | 2020-08-07 | Hamilton | Indiana | 18057 | 2697 | 113 |
405966 | 405966 | 2020-08-06 | Hamilton | Indiana | 18057 | 2639 | 112 |
402748 | 402748 | 2020-08-05 | Hamilton | Indiana | 18057 | 2601 | 112 |
399532 | 399532 | 2020-08-04 | Hamilton | Indiana | 18057 | 2573 | 112 |
396316 | 396316 | 2020-08-03 | Hamilton | Indiana | 18057 | 2542 | 112 |
393100 | 393100 | 2020-08-02 | Hamilton | Indiana | 18057 | 2518 | 112 |
389883 | 389883 | 2020-08-01 | Hamilton | Indiana | 18057 | 2475 | 112 |
386666 | 386666 | 2020-07-31 | Hamilton | Indiana | 18057 | 2439 | 112 |
383448 | 383448 | 2020-07-30 | Hamilton | Indiana | 18057 | 2395 | 112 |
380231 | 380231 | 2020-07-29 | Hamilton | Indiana | 18057 | 2345 | 110 |
377014 | 377014 | 2020-07-28 | Hamilton | Indiana | 18057 | 2317 | 110 |
373799 | 373799 | 2020-07-27 | Hamilton | Indiana | 18057 | 2281 | 110 |
370587 | 370587 | 2020-07-26 | Hamilton | Indiana | 18057 | 2257 | 110 |
367377 | 367377 | 2020-07-25 | Hamilton | Indiana | 18057 | 2209 | 110 |
364170 | 364170 | 2020-07-24 | Hamilton | Indiana | 18057 | 2161 | 110 |
360963 | 360963 | 2020-07-23 | Hamilton | Indiana | 18057 | 2109 | 110 |
357758 | 357758 | 2020-07-22 | Hamilton | Indiana | 18057 | 2059 | 109 |
354556 | 354556 | 2020-07-21 | Hamilton | Indiana | 18057 | 2017 | 108 |
351354 | 351354 | 2020-07-20 | Hamilton | Indiana | 18057 | 1978 | 107 |
348154 | 348154 | 2020-07-19 | Hamilton | Indiana | 18057 | 1958 | 107 |
344953 | 344953 | 2020-07-18 | Hamilton | Indiana | 18057 | 1913 | 107 |
341753 | 341753 | 2020-07-17 | Hamilton | Indiana | 18057 | 1868 | 107 |
338557 | 338557 | 2020-07-16 | Hamilton | Indiana | 18057 | 1851 | 107 |
335361 | 335361 | 2020-07-15 | Hamilton | Indiana | 18057 | 1822 | 107 |
332168 | 332168 | 2020-07-14 | Hamilton | Indiana | 18057 | 1801 | 107 |
328981 | 328981 | 2020-07-13 | Hamilton | Indiana | 18057 | 1757 | 107 |
325795 | 325795 | 2020-07-12 | Hamilton | Indiana | 18057 | 1730 | 107 |
322614 | 322614 | 2020-07-11 | Hamilton | Indiana | 18057 | 1713 | 107 |
319435 | 319435 | 2020-07-10 | Hamilton | Indiana | 18057 | 1688 | 107 |
316262 | 316262 | 2020-07-09 | Hamilton | Indiana | 18057 | 1652 | 107 |
313088 | 313088 | 2020-07-08 | Hamilton | Indiana | 18057 | 1632 | 107 |
309918 | 309918 | 2020-07-07 | Hamilton | Indiana | 18057 | 1622 | 107 |
306750 | 306750 | 2020-07-06 | Hamilton | Indiana | 18057 | 1589 | 106 |
303585 | 303585 | 2020-07-05 | Hamilton | Indiana | 18057 | 1574 | 106 |
300421 | 300421 | 2020-07-04 | Hamilton | Indiana | 18057 | 1560 | 105 |
297259 | 297259 | 2020-07-03 | Hamilton | Indiana | 18057 | 1536 | 105 |
294101 | 294101 | 2020-07-02 | Hamilton | Indiana | 18057 | 1517 | 105 |
290947 | 290947 | 2020-07-01 | Hamilton | Indiana | 18057 | 1499 | 105 |
287797 | 287797 | 2020-06-30 | Hamilton | Indiana | 18057 | 1478 | 105 |
284648 | 284648 | 2020-06-29 | Hamilton | Indiana | 18057 | 1463 | 103 |
281503 | 281503 | 2020-06-28 | Hamilton | Indiana | 18057 | 1448 | 102 |
278355 | 278355 | 2020-06-27 | Hamilton | Indiana | 18057 | 1442 | 102 |
275207 | 275207 | 2020-06-26 | Hamilton | Indiana | 18057 | 1431 | 102 |
272065 | 272065 | 2020-06-25 | Hamilton | Indiana | 18057 | 1425 | 102 |
268928 | 268928 | 2020-06-24 | Hamilton | Indiana | 18057 | 1412 | 102 |
265798 | 265798 | 2020-06-23 | Hamilton | Indiana | 18057 | 1407 | 102 |
262670 | 262670 | 2020-06-22 | Hamilton | Indiana | 18057 | 1387 | 102 |
259543 | 259543 | 2020-06-21 | Hamilton | Indiana | 18057 | 1382 | 102 |
256417 | 256417 | 2020-06-20 | Hamilton | Indiana | 18057 | 1378 | 102 |
253297 | 253297 | 2020-06-19 | Hamilton | Indiana | 18057 | 1372 | 101 |
250182 | 250182 | 2020-06-18 | Hamilton | Indiana | 18057 | 1362 | 101 |
247070 | 247070 | 2020-06-17 | Hamilton | Indiana | 18057 | 1384 | 101 |
243957 | 243957 | 2020-06-16 | Hamilton | Indiana | 18057 | 1381 | 101 |
240846 | 240846 | 2020-06-15 | Hamilton | Indiana | 18057 | 1370 | 101 |
237738 | 237738 | 2020-06-14 | Hamilton | Indiana | 18057 | 1290 | 101 |
234631 | 234631 | 2020-06-13 | Hamilton | Indiana | 18057 | 1270 | 101 |
231525 | 231525 | 2020-06-12 | Hamilton | Indiana | 18057 | 1263 | 101 |
228422 | 228422 | 2020-06-11 | Hamilton | Indiana | 18057 | 1258 | 100 |
225320 | 225320 | 2020-06-10 | Hamilton | Indiana | 18057 | 1255 | 100 |
222225 | 222225 | 2020-06-09 | Hamilton | Indiana | 18057 | 1234 | 99 |
219130 | 219130 | 2020-06-08 | Hamilton | Indiana | 18057 | 1223 | 100 |
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);