ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 18043 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535145 | 535145 | 2020-09-15 | Floyd | Indiana | 18043 | 1258 | 63 |
531910 | 531910 | 2020-09-14 | Floyd | Indiana | 18043 | 1247 | 63 |
528673 | 528673 | 2020-09-13 | Floyd | Indiana | 18043 | 1226 | 63 |
525437 | 525437 | 2020-09-12 | Floyd | Indiana | 18043 | 1220 | 63 |
522201 | 522201 | 2020-09-11 | Floyd | Indiana | 18043 | 1190 | 62 |
518964 | 518964 | 2020-09-10 | Floyd | Indiana | 18043 | 1175 | 62 |
515729 | 515729 | 2020-09-09 | Floyd | Indiana | 18043 | 1166 | 61 |
512496 | 512496 | 2020-09-08 | Floyd | Indiana | 18043 | 1162 | 61 |
509263 | 509263 | 2020-09-07 | Floyd | Indiana | 18043 | 1156 | 60 |
506031 | 506031 | 2020-09-06 | Floyd | Indiana | 18043 | 1149 | 60 |
502797 | 502797 | 2020-09-05 | Floyd | Indiana | 18043 | 1138 | 60 |
499563 | 499563 | 2020-09-04 | Floyd | Indiana | 18043 | 1115 | 60 |
496330 | 496330 | 2020-09-03 | Floyd | Indiana | 18043 | 1103 | 60 |
493096 | 493096 | 2020-09-02 | Floyd | Indiana | 18043 | 1091 | 60 |
489863 | 489863 | 2020-09-01 | Floyd | Indiana | 18043 | 1087 | 60 |
486630 | 486630 | 2020-08-31 | Floyd | Indiana | 18043 | 1082 | 57 |
483395 | 483395 | 2020-08-30 | Floyd | Indiana | 18043 | 1075 | 57 |
480161 | 480161 | 2020-08-29 | Floyd | Indiana | 18043 | 1069 | 57 |
476928 | 476928 | 2020-08-28 | Floyd | Indiana | 18043 | 1047 | 57 |
473695 | 473695 | 2020-08-27 | Floyd | Indiana | 18043 | 1031 | 57 |
470463 | 470463 | 2020-08-26 | Floyd | Indiana | 18043 | 1026 | 57 |
467234 | 467234 | 2020-08-25 | Floyd | Indiana | 18043 | 1014 | 57 |
464005 | 464005 | 2020-08-24 | Floyd | Indiana | 18043 | 1001 | 57 |
460776 | 460776 | 2020-08-23 | Floyd | Indiana | 18043 | 983 | 57 |
457549 | 457549 | 2020-08-22 | Floyd | Indiana | 18043 | 971 | 57 |
454321 | 454321 | 2020-08-21 | Floyd | Indiana | 18043 | 964 | 57 |
451093 | 451093 | 2020-08-20 | Floyd | Indiana | 18043 | 941 | 57 |
447865 | 447865 | 2020-08-19 | Floyd | Indiana | 18043 | 929 | 57 |
444638 | 444638 | 2020-08-18 | Floyd | Indiana | 18043 | 924 | 57 |
441412 | 441412 | 2020-08-17 | Floyd | Indiana | 18043 | 906 | 53 |
438186 | 438186 | 2020-08-16 | Floyd | Indiana | 18043 | 894 | 53 |
434960 | 434960 | 2020-08-15 | Floyd | Indiana | 18043 | 881 | 53 |
431735 | 431735 | 2020-08-14 | Floyd | Indiana | 18043 | 865 | 53 |
428507 | 428507 | 2020-08-13 | Floyd | Indiana | 18043 | 841 | 53 |
425283 | 425283 | 2020-08-12 | Floyd | Indiana | 18043 | 826 | 52 |
422062 | 422062 | 2020-08-11 | Floyd | Indiana | 18043 | 813 | 51 |
418839 | 418839 | 2020-08-10 | Floyd | Indiana | 18043 | 795 | 49 |
415618 | 415618 | 2020-08-09 | Floyd | Indiana | 18043 | 783 | 49 |
412398 | 412398 | 2020-08-08 | Floyd | Indiana | 18043 | 776 | 49 |
409179 | 409179 | 2020-08-07 | Floyd | Indiana | 18043 | 764 | 48 |
405959 | 405959 | 2020-08-06 | Floyd | Indiana | 18043 | 744 | 48 |
402741 | 402741 | 2020-08-05 | Floyd | Indiana | 18043 | 733 | 48 |
399525 | 399525 | 2020-08-04 | Floyd | Indiana | 18043 | 722 | 48 |
396309 | 396309 | 2020-08-03 | Floyd | Indiana | 18043 | 697 | 46 |
393093 | 393093 | 2020-08-02 | Floyd | Indiana | 18043 | 687 | 46 |
389876 | 389876 | 2020-08-01 | Floyd | Indiana | 18043 | 668 | 46 |
386659 | 386659 | 2020-07-31 | Floyd | Indiana | 18043 | 661 | 46 |
383441 | 383441 | 2020-07-30 | Floyd | Indiana | 18043 | 639 | 46 |
380224 | 380224 | 2020-07-29 | Floyd | Indiana | 18043 | 621 | 46 |
377007 | 377007 | 2020-07-28 | Floyd | Indiana | 18043 | 611 | 46 |
373792 | 373792 | 2020-07-27 | Floyd | Indiana | 18043 | 585 | 46 |
370580 | 370580 | 2020-07-26 | Floyd | Indiana | 18043 | 579 | 46 |
367370 | 367370 | 2020-07-25 | Floyd | Indiana | 18043 | 572 | 46 |
364163 | 364163 | 2020-07-24 | Floyd | Indiana | 18043 | 545 | 46 |
360956 | 360956 | 2020-07-23 | Floyd | Indiana | 18043 | 524 | 46 |
357751 | 357751 | 2020-07-22 | Floyd | Indiana | 18043 | 512 | 46 |
354549 | 354549 | 2020-07-21 | Floyd | Indiana | 18043 | 503 | 46 |
351347 | 351347 | 2020-07-20 | Floyd | Indiana | 18043 | 494 | 46 |
348147 | 348147 | 2020-07-19 | Floyd | Indiana | 18043 | 481 | 46 |
344946 | 344946 | 2020-07-18 | Floyd | Indiana | 18043 | 470 | 46 |
341746 | 341746 | 2020-07-17 | Floyd | Indiana | 18043 | 458 | 46 |
338550 | 338550 | 2020-07-16 | Floyd | Indiana | 18043 | 444 | 46 |
335354 | 335354 | 2020-07-15 | Floyd | Indiana | 18043 | 437 | 46 |
332161 | 332161 | 2020-07-14 | Floyd | Indiana | 18043 | 427 | 46 |
328974 | 328974 | 2020-07-13 | Floyd | Indiana | 18043 | 420 | 46 |
325788 | 325788 | 2020-07-12 | Floyd | Indiana | 18043 | 416 | 46 |
322607 | 322607 | 2020-07-11 | Floyd | Indiana | 18043 | 408 | 46 |
319428 | 319428 | 2020-07-10 | Floyd | Indiana | 18043 | 406 | 46 |
316255 | 316255 | 2020-07-09 | Floyd | Indiana | 18043 | 393 | 46 |
313081 | 313081 | 2020-07-08 | Floyd | Indiana | 18043 | 386 | 46 |
309911 | 309911 | 2020-07-07 | Floyd | Indiana | 18043 | 384 | 46 |
306743 | 306743 | 2020-07-06 | Floyd | Indiana | 18043 | 383 | 46 |
303578 | 303578 | 2020-07-05 | Floyd | Indiana | 18043 | 381 | 46 |
300414 | 300414 | 2020-07-04 | Floyd | Indiana | 18043 | 373 | 46 |
297252 | 297252 | 2020-07-03 | Floyd | Indiana | 18043 | 373 | 46 |
294094 | 294094 | 2020-07-02 | Floyd | Indiana | 18043 | 372 | 46 |
290940 | 290940 | 2020-07-01 | Floyd | Indiana | 18043 | 365 | 46 |
287790 | 287790 | 2020-06-30 | Floyd | Indiana | 18043 | 364 | 46 |
284641 | 284641 | 2020-06-29 | Floyd | Indiana | 18043 | 360 | 46 |
281496 | 281496 | 2020-06-28 | Floyd | Indiana | 18043 | 359 | 46 |
278348 | 278348 | 2020-06-27 | Floyd | Indiana | 18043 | 359 | 46 |
275200 | 275200 | 2020-06-26 | Floyd | Indiana | 18043 | 356 | 45 |
272058 | 272058 | 2020-06-25 | Floyd | Indiana | 18043 | 352 | 45 |
268921 | 268921 | 2020-06-24 | Floyd | Indiana | 18043 | 353 | 45 |
265791 | 265791 | 2020-06-23 | Floyd | Indiana | 18043 | 349 | 45 |
262663 | 262663 | 2020-06-22 | Floyd | Indiana | 18043 | 347 | 45 |
259536 | 259536 | 2020-06-21 | Floyd | Indiana | 18043 | 346 | 45 |
256410 | 256410 | 2020-06-20 | Floyd | Indiana | 18043 | 346 | 45 |
253290 | 253290 | 2020-06-19 | Floyd | Indiana | 18043 | 344 | 45 |
250175 | 250175 | 2020-06-18 | Floyd | Indiana | 18043 | 341 | 45 |
247063 | 247063 | 2020-06-17 | Floyd | Indiana | 18043 | 340 | 44 |
243950 | 243950 | 2020-06-16 | Floyd | Indiana | 18043 | 339 | 44 |
240839 | 240839 | 2020-06-15 | Floyd | Indiana | 18043 | 337 | 44 |
237731 | 237731 | 2020-06-14 | Floyd | Indiana | 18043 | 335 | 44 |
234624 | 234624 | 2020-06-13 | Floyd | Indiana | 18043 | 335 | 44 |
231518 | 231518 | 2020-06-12 | Floyd | Indiana | 18043 | 335 | 44 |
228415 | 228415 | 2020-06-11 | Floyd | Indiana | 18043 | 334 | 44 |
225313 | 225313 | 2020-06-10 | Floyd | Indiana | 18043 | 331 | 44 |
222218 | 222218 | 2020-06-09 | Floyd | Indiana | 18043 | 329 | 44 |
219123 | 219123 | 2020-06-08 | Floyd | Indiana | 18043 | 330 | 43 |
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);