ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1127 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
277703 | 277703 | 2020-06-27 | Walker | Alabama | 1127 | 791 | 13 |
280851 | 280851 | 2020-06-28 | Walker | Alabama | 1127 | 797 | 13 |
283997 | 283997 | 2020-06-29 | Walker | Alabama | 1127 | 840 | 15 |
287143 | 287143 | 2020-06-30 | Walker | Alabama | 1127 | 855 | 17 |
290293 | 290293 | 2020-07-01 | Walker | Alabama | 1127 | 880 | 23 |
293446 | 293446 | 2020-07-02 | Walker | Alabama | 1127 | 884 | 23 |
296601 | 296601 | 2020-07-03 | Walker | Alabama | 1127 | 918 | 24 |
299763 | 299763 | 2020-07-04 | Walker | Alabama | 1127 | 927 | 24 |
302927 | 302927 | 2020-07-05 | Walker | Alabama | 1127 | 952 | 24 |
306091 | 306091 | 2020-07-06 | Walker | Alabama | 1127 | 991 | 24 |
309260 | 309260 | 2020-07-07 | Walker | Alabama | 1127 | 998 | 25 |
312429 | 312429 | 2020-07-08 | Walker | Alabama | 1127 | 1031 | 25 |
315604 | 315604 | 2020-07-09 | Walker | Alabama | 1127 | 1066 | 27 |
318777 | 318777 | 2020-07-10 | Walker | Alabama | 1127 | 1070 | 31 |
321956 | 321956 | 2020-07-11 | Walker | Alabama | 1127 | 1077 | 31 |
325137 | 325137 | 2020-07-12 | Walker | Alabama | 1127 | 1091 | 32 |
328323 | 328323 | 2020-07-13 | Walker | Alabama | 1127 | 1129 | 32 |
331509 | 331509 | 2020-07-14 | Walker | Alabama | 1127 | 1143 | 35 |
334702 | 334702 | 2020-07-15 | Walker | Alabama | 1127 | 1152 | 37 |
337897 | 337897 | 2020-07-16 | Walker | Alabama | 1127 | 1178 | 43 |
341093 | 341093 | 2020-07-17 | Walker | Alabama | 1127 | 1220 | 49 |
344292 | 344292 | 2020-07-18 | Walker | Alabama | 1127 | 1243 | 51 |
347492 | 347492 | 2020-07-19 | Walker | Alabama | 1127 | 1254 | 51 |
350693 | 350693 | 2020-07-20 | Walker | Alabama | 1127 | 1274 | 51 |
353895 | 353895 | 2020-07-21 | Walker | Alabama | 1127 | 1276 | 51 |
357098 | 357098 | 2020-07-22 | Walker | Alabama | 1127 | 1290 | 54 |
360303 | 360303 | 2020-07-23 | Walker | Alabama | 1127 | 1312 | 55 |
363509 | 363509 | 2020-07-24 | Walker | Alabama | 1127 | 1358 | 56 |
366716 | 366716 | 2020-07-25 | Walker | Alabama | 1127 | 1377 | 56 |
369926 | 369926 | 2020-07-26 | Walker | Alabama | 1127 | 1385 | 58 |
373138 | 373138 | 2020-07-27 | Walker | Alabama | 1127 | 1419 | 58 |
376352 | 376352 | 2020-07-28 | Walker | Alabama | 1127 | 1429 | 58 |
379568 | 379568 | 2020-07-29 | Walker | Alabama | 1127 | 1432 | 62 |
382785 | 382785 | 2020-07-30 | Walker | Alabama | 1127 | 1445 | 63 |
386003 | 386003 | 2020-07-31 | Walker | Alabama | 1127 | 1466 | 64 |
389220 | 389220 | 2020-08-01 | Walker | Alabama | 1127 | 1475 | 66 |
392437 | 392437 | 2020-08-02 | Walker | Alabama | 1127 | 1484 | 66 |
395653 | 395653 | 2020-08-03 | Walker | Alabama | 1127 | 1500 | 66 |
398869 | 398869 | 2020-08-04 | Walker | Alabama | 1127 | 1506 | 67 |
402085 | 402085 | 2020-08-05 | Walker | Alabama | 1127 | 1511 | 67 |
405303 | 405303 | 2020-08-06 | Walker | Alabama | 1127 | 1532 | 67 |
408523 | 408523 | 2020-08-07 | Walker | Alabama | 1127 | 1536 | 67 |
411742 | 411742 | 2020-08-08 | Walker | Alabama | 1127 | 1555 | 67 |
414962 | 414962 | 2020-08-09 | Walker | Alabama | 1127 | 1561 | 67 |
418183 | 418183 | 2020-08-10 | Walker | Alabama | 1127 | 1577 | 67 |
421404 | 421404 | 2020-08-11 | Walker | Alabama | 1127 | 1584 | 68 |
424625 | 424625 | 2020-08-12 | Walker | Alabama | 1127 | 1588 | 68 |
427849 | 427849 | 2020-08-13 | Walker | Alabama | 1127 | 1603 | 68 |
431077 | 431077 | 2020-08-14 | Walker | Alabama | 1127 | 1624 | 69 |
434302 | 434302 | 2020-08-15 | Walker | Alabama | 1127 | 1648 | 69 |
437528 | 437528 | 2020-08-16 | Walker | Alabama | 1127 | 1670 | 69 |
440754 | 440754 | 2020-08-17 | Walker | Alabama | 1127 | 1684 | 69 |
443980 | 443980 | 2020-08-18 | Walker | Alabama | 1127 | 1703 | 70 |
447207 | 447207 | 2020-08-19 | Walker | Alabama | 1127 | 1718 | 70 |
450435 | 450435 | 2020-08-20 | Walker | Alabama | 1127 | 1749 | 70 |
453663 | 453663 | 2020-08-21 | Walker | Alabama | 1127 | 1761 | 70 |
456891 | 456891 | 2020-08-22 | Walker | Alabama | 1127 | 1771 | 70 |
460118 | 460118 | 2020-08-23 | Walker | Alabama | 1127 | 1778 | 70 |
463347 | 463347 | 2020-08-24 | Walker | Alabama | 1127 | 1832 | 70 |
466576 | 466576 | 2020-08-25 | Walker | Alabama | 1127 | 1839 | 70 |
469805 | 469805 | 2020-08-26 | Walker | Alabama | 1127 | 1853 | 70 |
473037 | 473037 | 2020-08-27 | Walker | Alabama | 1127 | 1873 | 71 |
476270 | 476270 | 2020-08-28 | Walker | Alabama | 1127 | 1886 | 73 |
479503 | 479503 | 2020-08-29 | Walker | Alabama | 1127 | 1900 | 75 |
482737 | 482737 | 2020-08-30 | Walker | Alabama | 1127 | 1907 | 75 |
485972 | 485972 | 2020-08-31 | Walker | Alabama | 1127 | 1914 | 76 |
489205 | 489205 | 2020-09-01 | Walker | Alabama | 1127 | 1937 | 76 |
492438 | 492438 | 2020-09-02 | Walker | Alabama | 1127 | 1945 | 77 |
495672 | 495672 | 2020-09-03 | Walker | Alabama | 1127 | 1977 | 77 |
498905 | 498905 | 2020-09-04 | Walker | Alabama | 1127 | 2000 | 77 |
502139 | 502139 | 2020-09-05 | Walker | Alabama | 1127 | 2008 | 77 |
505373 | 505373 | 2020-09-06 | Walker | Alabama | 1127 | 2029 | 77 |
508605 | 508605 | 2020-09-07 | Walker | Alabama | 1127 | 2061 | 77 |
511838 | 511838 | 2020-09-08 | Walker | Alabama | 1127 | 2067 | 77 |
515071 | 515071 | 2020-09-09 | Walker | Alabama | 1127 | 2085 | 77 |
518306 | 518306 | 2020-09-10 | Walker | Alabama | 1127 | 2099 | 78 |
521543 | 521543 | 2020-09-11 | Walker | Alabama | 1127 | 2113 | 79 |
524779 | 524779 | 2020-09-12 | Walker | Alabama | 1127 | 2124 | 80 |
528015 | 528015 | 2020-09-13 | Walker | Alabama | 1127 | 2153 | 80 |
531252 | 531252 | 2020-09-14 | Walker | Alabama | 1127 | 2159 | 80 |
534487 | 534487 | 2020-09-15 | Walker | Alabama | 1127 | 2164 | 80 |
537723 | 537723 | 2020-09-16 | Walker | Alabama | 1127 | 2174 | 80 |
540960 | 540960 | 2020-09-17 | Walker | Alabama | 1127 | 2177 | 80 |
544196 | 544196 | 2020-09-18 | Walker | Alabama | 1127 | 2191 | 80 |
547433 | 547433 | 2020-09-19 | Walker | Alabama | 1127 | 2207 | 80 |
550672 | 550672 | 2020-09-20 | Walker | Alabama | 1127 | 2226 | 80 |
553911 | 553911 | 2020-09-21 | Walker | Alabama | 1127 | 2243 | 80 |
557148 | 557148 | 2020-09-22 | Walker | Alabama | 1127 | 2250 | 80 |
560384 | 560384 | 2020-09-23 | Walker | Alabama | 1127 | 2253 | 83 |
563623 | 563623 | 2020-09-24 | Walker | Alabama | 1127 | 2284 | 83 |
566864 | 566864 | 2020-09-25 | Walker | Alabama | 1127 | 2306 | 83 |
570105 | 570105 | 2020-09-26 | Walker | Alabama | 1127 | 2316 | 84 |
573347 | 573347 | 2020-09-27 | Walker | Alabama | 1127 | 2319 | 84 |
576591 | 576591 | 2020-09-28 | Walker | Alabama | 1127 | 2330 | 84 |
579832 | 579832 | 2020-09-29 | Walker | Alabama | 1127 | 2354 | 85 |
583071 | 583071 | 2020-09-30 | Walker | Alabama | 1127 | 2369 | 87 |
586311 | 586311 | 2020-10-01 | Walker | Alabama | 1127 | 2376 | 88 |
589552 | 589552 | 2020-10-02 | Walker | Alabama | 1127 | 2403 | 88 |
592792 | 592792 | 2020-10-03 | Walker | Alabama | 1127 | 2415 | 88 |
596034 | 596034 | 2020-10-04 | Walker | Alabama | 1127 | 2424 | 88 |
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);