ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 1115 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
271410 | 271410 | 2020-06-25 | St. Clair | Alabama | 1115 | 236 | 2 |
274550 | 274550 | 2020-06-26 | St. Clair | Alabama | 1115 | 245 | 2 |
277698 | 277698 | 2020-06-27 | St. Clair | Alabama | 1115 | 255 | 2 |
280846 | 280846 | 2020-06-28 | St. Clair | Alabama | 1115 | 257 | 2 |
283992 | 283992 | 2020-06-29 | St. Clair | Alabama | 1115 | 285 | 2 |
287138 | 287138 | 2020-06-30 | St. Clair | Alabama | 1115 | 302 | 2 |
290288 | 290288 | 2020-07-01 | St. Clair | Alabama | 1115 | 314 | 2 |
293441 | 293441 | 2020-07-02 | St. Clair | Alabama | 1115 | 329 | 2 |
296596 | 296596 | 2020-07-03 | St. Clair | Alabama | 1115 | 357 | 2 |
299758 | 299758 | 2020-07-04 | St. Clair | Alabama | 1115 | 376 | 2 |
302922 | 302922 | 2020-07-05 | St. Clair | Alabama | 1115 | 392 | 2 |
306086 | 306086 | 2020-07-06 | St. Clair | Alabama | 1115 | 412 | 2 |
309255 | 309255 | 2020-07-07 | St. Clair | Alabama | 1115 | 426 | 2 |
312424 | 312424 | 2020-07-08 | St. Clair | Alabama | 1115 | 452 | 2 |
315599 | 315599 | 2020-07-09 | St. Clair | Alabama | 1115 | 481 | 2 |
318772 | 318772 | 2020-07-10 | St. Clair | Alabama | 1115 | 499 | 2 |
321951 | 321951 | 2020-07-11 | St. Clair | Alabama | 1115 | 528 | 3 |
325132 | 325132 | 2020-07-12 | St. Clair | Alabama | 1115 | 560 | 3 |
328318 | 328318 | 2020-07-13 | St. Clair | Alabama | 1115 | 614 | 3 |
331504 | 331504 | 2020-07-14 | St. Clair | Alabama | 1115 | 663 | 3 |
334697 | 334697 | 2020-07-15 | St. Clair | Alabama | 1115 | 688 | 4 |
337892 | 337892 | 2020-07-16 | St. Clair | Alabama | 1115 | 732 | 4 |
341088 | 341088 | 2020-07-17 | St. Clair | Alabama | 1115 | 766 | 4 |
344287 | 344287 | 2020-07-18 | St. Clair | Alabama | 1115 | 797 | 4 |
347487 | 347487 | 2020-07-19 | St. Clair | Alabama | 1115 | 824 | 4 |
350688 | 350688 | 2020-07-20 | St. Clair | Alabama | 1115 | 865 | 4 |
353890 | 353890 | 2020-07-21 | St. Clair | Alabama | 1115 | 897 | 4 |
357093 | 357093 | 2020-07-22 | St. Clair | Alabama | 1115 | 928 | 5 |
360298 | 360298 | 2020-07-23 | St. Clair | Alabama | 1115 | 959 | 7 |
363504 | 363504 | 2020-07-24 | St. Clair | Alabama | 1115 | 990 | 7 |
366711 | 366711 | 2020-07-25 | St. Clair | Alabama | 1115 | 1016 | 8 |
369921 | 369921 | 2020-07-26 | St. Clair | Alabama | 1115 | 1042 | 8 |
373133 | 373133 | 2020-07-27 | St. Clair | Alabama | 1115 | 1078 | 9 |
376347 | 376347 | 2020-07-28 | St. Clair | Alabama | 1115 | 1104 | 9 |
379563 | 379563 | 2020-07-29 | St. Clair | Alabama | 1115 | 1166 | 9 |
382780 | 382780 | 2020-07-30 | St. Clair | Alabama | 1115 | 1179 | 9 |
385998 | 385998 | 2020-07-31 | St. Clair | Alabama | 1115 | 1226 | 9 |
389215 | 389215 | 2020-08-01 | St. Clair | Alabama | 1115 | 1248 | 11 |
392432 | 392432 | 2020-08-02 | St. Clair | Alabama | 1115 | 1265 | 12 |
395648 | 395648 | 2020-08-03 | St. Clair | Alabama | 1115 | 1305 | 12 |
398864 | 398864 | 2020-08-04 | St. Clair | Alabama | 1115 | 1325 | 12 |
402080 | 402080 | 2020-08-05 | St. Clair | Alabama | 1115 | 1342 | 15 |
405298 | 405298 | 2020-08-06 | St. Clair | Alabama | 1115 | 1379 | 16 |
408518 | 408518 | 2020-08-07 | St. Clair | Alabama | 1115 | 1413 | 17 |
411737 | 411737 | 2020-08-08 | St. Clair | Alabama | 1115 | 1431 | 18 |
414957 | 414957 | 2020-08-09 | St. Clair | Alabama | 1115 | 1441 | 18 |
418178 | 418178 | 2020-08-10 | St. Clair | Alabama | 1115 | 1457 | 19 |
421399 | 421399 | 2020-08-11 | St. Clair | Alabama | 1115 | 1474 | 21 |
424620 | 424620 | 2020-08-12 | St. Clair | Alabama | 1115 | 1488 | 22 |
427844 | 427844 | 2020-08-13 | St. Clair | Alabama | 1115 | 1493 | 22 |
431072 | 431072 | 2020-08-14 | St. Clair | Alabama | 1115 | 1499 | 21 |
434297 | 434297 | 2020-08-15 | St. Clair | Alabama | 1115 | 1506 | 21 |
437523 | 437523 | 2020-08-16 | St. Clair | Alabama | 1115 | 1528 | 21 |
440749 | 440749 | 2020-08-17 | St. Clair | Alabama | 1115 | 1535 | 23 |
443975 | 443975 | 2020-08-18 | St. Clair | Alabama | 1115 | 1558 | 23 |
447202 | 447202 | 2020-08-19 | St. Clair | Alabama | 1115 | 1591 | 23 |
450430 | 450430 | 2020-08-20 | St. Clair | Alabama | 1115 | 1614 | 24 |
453658 | 453658 | 2020-08-21 | St. Clair | Alabama | 1115 | 1639 | 24 |
456886 | 456886 | 2020-08-22 | St. Clair | Alabama | 1115 | 1641 | 25 |
460113 | 460113 | 2020-08-23 | St. Clair | Alabama | 1115 | 1677 | 25 |
463342 | 463342 | 2020-08-24 | St. Clair | Alabama | 1115 | 1701 | 25 |
466571 | 466571 | 2020-08-25 | St. Clair | Alabama | 1115 | 1704 | 25 |
469800 | 469800 | 2020-08-26 | St. Clair | Alabama | 1115 | 1749 | 25 |
473032 | 473032 | 2020-08-27 | St. Clair | Alabama | 1115 | 1765 | 26 |
476265 | 476265 | 2020-08-28 | St. Clair | Alabama | 1115 | 1795 | 27 |
479498 | 479498 | 2020-08-29 | St. Clair | Alabama | 1115 | 1811 | 28 |
482732 | 482732 | 2020-08-30 | St. Clair | Alabama | 1115 | 1833 | 28 |
485967 | 485967 | 2020-08-31 | St. Clair | Alabama | 1115 | 1844 | 29 |
489200 | 489200 | 2020-09-01 | St. Clair | Alabama | 1115 | 1877 | 29 |
492433 | 492433 | 2020-09-02 | St. Clair | Alabama | 1115 | 1888 | 30 |
495667 | 495667 | 2020-09-03 | St. Clair | Alabama | 1115 | 1914 | 30 |
498900 | 498900 | 2020-09-04 | St. Clair | Alabama | 1115 | 1933 | 32 |
502134 | 502134 | 2020-09-05 | St. Clair | Alabama | 1115 | 1959 | 32 |
505368 | 505368 | 2020-09-06 | St. Clair | Alabama | 1115 | 1968 | 32 |
508600 | 508600 | 2020-09-07 | St. Clair | Alabama | 1115 | 1981 | 32 |
511833 | 511833 | 2020-09-08 | St. Clair | Alabama | 1115 | 1997 | 32 |
515066 | 515066 | 2020-09-09 | St. Clair | Alabama | 1115 | 2012 | 32 |
518301 | 518301 | 2020-09-10 | St. Clair | Alabama | 1115 | 2030 | 33 |
521538 | 521538 | 2020-09-11 | St. Clair | Alabama | 1115 | 2056 | 33 |
524774 | 524774 | 2020-09-12 | St. Clair | Alabama | 1115 | 2083 | 34 |
528010 | 528010 | 2020-09-13 | St. Clair | Alabama | 1115 | 2114 | 34 |
531247 | 531247 | 2020-09-14 | St. Clair | Alabama | 1115 | 2132 | 34 |
534482 | 534482 | 2020-09-15 | St. Clair | Alabama | 1115 | 2152 | 34 |
537718 | 537718 | 2020-09-16 | St. Clair | Alabama | 1115 | 2174 | 34 |
540955 | 540955 | 2020-09-17 | St. Clair | Alabama | 1115 | 2181 | 34 |
544191 | 544191 | 2020-09-18 | St. Clair | Alabama | 1115 | 2198 | 35 |
547428 | 547428 | 2020-09-19 | St. Clair | Alabama | 1115 | 2213 | 35 |
550667 | 550667 | 2020-09-20 | St. Clair | Alabama | 1115 | 2234 | 35 |
553906 | 553906 | 2020-09-21 | St. Clair | Alabama | 1115 | 2243 | 35 |
557143 | 557143 | 2020-09-22 | St. Clair | Alabama | 1115 | 2255 | 35 |
560379 | 560379 | 2020-09-23 | St. Clair | Alabama | 1115 | 2263 | 37 |
563618 | 563618 | 2020-09-24 | St. Clair | Alabama | 1115 | 2278 | 37 |
566859 | 566859 | 2020-09-25 | St. Clair | Alabama | 1115 | 2308 | 35 |
570100 | 570100 | 2020-09-26 | St. Clair | Alabama | 1115 | 2322 | 35 |
573342 | 573342 | 2020-09-27 | St. Clair | Alabama | 1115 | 2330 | 36 |
576586 | 576586 | 2020-09-28 | St. Clair | Alabama | 1115 | 2340 | 36 |
579827 | 579827 | 2020-09-29 | St. Clair | Alabama | 1115 | 2359 | 36 |
583066 | 583066 | 2020-09-30 | St. Clair | Alabama | 1115 | 2379 | 37 |
586306 | 586306 | 2020-10-01 | St. Clair | Alabama | 1115 | 2389 | 37 |
589547 | 589547 | 2020-10-02 | St. Clair | Alabama | 1115 | 2414 | 37 |
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);