ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Jefferson" and fips = 5069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531332 | 531332 | 2020-09-14 | Jefferson | Arkansas | 5069 | 2555 | 55 |
528095 | 528095 | 2020-09-13 | Jefferson | Arkansas | 5069 | 2514 | 55 |
524859 | 524859 | 2020-09-12 | Jefferson | Arkansas | 5069 | 2475 | 55 |
521623 | 521623 | 2020-09-11 | Jefferson | Arkansas | 5069 | 2431 | 55 |
518386 | 518386 | 2020-09-10 | Jefferson | Arkansas | 5069 | 2372 | 54 |
515151 | 515151 | 2020-09-09 | Jefferson | Arkansas | 5069 | 2338 | 53 |
511918 | 511918 | 2020-09-08 | Jefferson | Arkansas | 5069 | 2314 | 53 |
508685 | 508685 | 2020-09-07 | Jefferson | Arkansas | 5069 | 2304 | 53 |
505453 | 505453 | 2020-09-06 | Jefferson | Arkansas | 5069 | 2285 | 52 |
502219 | 502219 | 2020-09-05 | Jefferson | Arkansas | 5069 | 2241 | 51 |
498985 | 498985 | 2020-09-04 | Jefferson | Arkansas | 5069 | 2191 | 51 |
495752 | 495752 | 2020-09-03 | Jefferson | Arkansas | 5069 | 2166 | 51 |
492518 | 492518 | 2020-09-02 | Jefferson | Arkansas | 5069 | 2129 | 51 |
489285 | 489285 | 2020-09-01 | Jefferson | Arkansas | 5069 | 2112 | 50 |
486052 | 486052 | 2020-08-31 | Jefferson | Arkansas | 5069 | 2104 | 50 |
482817 | 482817 | 2020-08-30 | Jefferson | Arkansas | 5069 | 2091 | 50 |
479583 | 479583 | 2020-08-29 | Jefferson | Arkansas | 5069 | 2082 | 50 |
476350 | 476350 | 2020-08-28 | Jefferson | Arkansas | 5069 | 2059 | 50 |
473117 | 473117 | 2020-08-27 | Jefferson | Arkansas | 5069 | 2002 | 47 |
469885 | 469885 | 2020-08-26 | Jefferson | Arkansas | 5069 | 1970 | 47 |
466656 | 466656 | 2020-08-25 | Jefferson | Arkansas | 5069 | 1924 | 47 |
463427 | 463427 | 2020-08-24 | Jefferson | Arkansas | 5069 | 1904 | 44 |
460198 | 460198 | 2020-08-23 | Jefferson | Arkansas | 5069 | 1899 | 43 |
456971 | 456971 | 2020-08-22 | Jefferson | Arkansas | 5069 | 1881 | 43 |
453743 | 453743 | 2020-08-21 | Jefferson | Arkansas | 5069 | 1861 | 43 |
450515 | 450515 | 2020-08-20 | Jefferson | Arkansas | 5069 | 1831 | 41 |
447287 | 447287 | 2020-08-19 | Jefferson | Arkansas | 5069 | 1776 | 41 |
444060 | 444060 | 2020-08-18 | Jefferson | Arkansas | 5069 | 1718 | 41 |
440834 | 440834 | 2020-08-17 | Jefferson | Arkansas | 5069 | 1710 | 41 |
437608 | 437608 | 2020-08-16 | Jefferson | Arkansas | 5069 | 1696 | 41 |
434382 | 434382 | 2020-08-15 | Jefferson | Arkansas | 5069 | 1670 | 41 |
431157 | 431157 | 2020-08-14 | Jefferson | Arkansas | 5069 | 1657 | 41 |
427929 | 427929 | 2020-08-13 | Jefferson | Arkansas | 5069 | 1644 | 41 |
424705 | 424705 | 2020-08-12 | Jefferson | Arkansas | 5069 | 1617 | 40 |
421484 | 421484 | 2020-08-11 | Jefferson | Arkansas | 5069 | 1584 | 40 |
418263 | 418263 | 2020-08-10 | Jefferson | Arkansas | 5069 | 1574 | 40 |
415042 | 415042 | 2020-08-09 | Jefferson | Arkansas | 5069 | 1534 | 40 |
411822 | 411822 | 2020-08-08 | Jefferson | Arkansas | 5069 | 1519 | 40 |
408603 | 408603 | 2020-08-07 | Jefferson | Arkansas | 5069 | 1484 | 40 |
405383 | 405383 | 2020-08-06 | Jefferson | Arkansas | 5069 | 1423 | 40 |
402165 | 402165 | 2020-08-05 | Jefferson | Arkansas | 5069 | 1412 | 40 |
398949 | 398949 | 2020-08-04 | Jefferson | Arkansas | 5069 | 1404 | 39 |
395733 | 395733 | 2020-08-03 | Jefferson | Arkansas | 5069 | 1382 | 39 |
392517 | 392517 | 2020-08-02 | Jefferson | Arkansas | 5069 | 1357 | 38 |
389300 | 389300 | 2020-08-01 | Jefferson | Arkansas | 5069 | 1315 | 38 |
386083 | 386083 | 2020-07-31 | Jefferson | Arkansas | 5069 | 1293 | 37 |
382865 | 382865 | 2020-07-30 | Jefferson | Arkansas | 5069 | 1270 | 37 |
379648 | 379648 | 2020-07-29 | Jefferson | Arkansas | 5069 | 1239 | 37 |
376432 | 376432 | 2020-07-28 | Jefferson | Arkansas | 5069 | 1222 | 36 |
373218 | 373218 | 2020-07-27 | Jefferson | Arkansas | 5069 | 1204 | 36 |
370006 | 370006 | 2020-07-26 | Jefferson | Arkansas | 5069 | 1171 | 34 |
366796 | 366796 | 2020-07-25 | Jefferson | Arkansas | 5069 | 1146 | 34 |
363589 | 363589 | 2020-07-24 | Jefferson | Arkansas | 5069 | 1133 | 33 |
360382 | 360382 | 2020-07-23 | Jefferson | Arkansas | 5069 | 1094 | 32 |
357177 | 357177 | 2020-07-22 | Jefferson | Arkansas | 5069 | 1069 | 32 |
353974 | 353974 | 2020-07-21 | Jefferson | Arkansas | 5069 | 1063 | 32 |
350772 | 350772 | 2020-07-20 | Jefferson | Arkansas | 5069 | 1029 | 30 |
347571 | 347571 | 2020-07-19 | Jefferson | Arkansas | 5069 | 1023 | 30 |
344371 | 344371 | 2020-07-18 | Jefferson | Arkansas | 5069 | 969 | 30 |
341172 | 341172 | 2020-07-17 | Jefferson | Arkansas | 5069 | 950 | 30 |
337976 | 337976 | 2020-07-16 | Jefferson | Arkansas | 5069 | 937 | 29 |
334781 | 334781 | 2020-07-15 | Jefferson | Arkansas | 5069 | 917 | 29 |
331588 | 331588 | 2020-07-14 | Jefferson | Arkansas | 5069 | 900 | 29 |
328402 | 328402 | 2020-07-13 | Jefferson | Arkansas | 5069 | 884 | 29 |
325216 | 325216 | 2020-07-12 | Jefferson | Arkansas | 5069 | 861 | 29 |
322035 | 322035 | 2020-07-11 | Jefferson | Arkansas | 5069 | 850 | 29 |
318856 | 318856 | 2020-07-10 | Jefferson | Arkansas | 5069 | 831 | 28 |
315683 | 315683 | 2020-07-09 | Jefferson | Arkansas | 5069 | 808 | 28 |
312508 | 312508 | 2020-07-08 | Jefferson | Arkansas | 5069 | 784 | 28 |
309338 | 309338 | 2020-07-07 | Jefferson | Arkansas | 5069 | 774 | 28 |
306170 | 306170 | 2020-07-06 | Jefferson | Arkansas | 5069 | 761 | 28 |
303006 | 303006 | 2020-07-05 | Jefferson | Arkansas | 5069 | 752 | 28 |
299842 | 299842 | 2020-07-04 | Jefferson | Arkansas | 5069 | 737 | 28 |
296680 | 296680 | 2020-07-03 | Jefferson | Arkansas | 5069 | 726 | 28 |
293524 | 293524 | 2020-07-02 | Jefferson | Arkansas | 5069 | 720 | 28 |
290370 | 290370 | 2020-07-01 | Jefferson | Arkansas | 5069 | 706 | 28 |
287219 | 287219 | 2020-06-30 | Jefferson | Arkansas | 5069 | 700 | 28 |
284073 | 284073 | 2020-06-29 | Jefferson | Arkansas | 5069 | 693 | 28 |
280927 | 280927 | 2020-06-28 | Jefferson | Arkansas | 5069 | 683 | 28 |
277780 | 277780 | 2020-06-27 | Jefferson | Arkansas | 5069 | 680 | 28 |
274632 | 274632 | 2020-06-26 | Jefferson | Arkansas | 5069 | 676 | 28 |
271492 | 271492 | 2020-06-25 | Jefferson | Arkansas | 5069 | 663 | 28 |
268357 | 268357 | 2020-06-24 | Jefferson | Arkansas | 5069 | 661 | 28 |
265227 | 265227 | 2020-06-23 | Jefferson | Arkansas | 5069 | 657 | 28 |
262099 | 262099 | 2020-06-22 | Jefferson | Arkansas | 5069 | 657 | 28 |
258972 | 258972 | 2020-06-21 | Jefferson | Arkansas | 5069 | 650 | 28 |
255845 | 255845 | 2020-06-20 | Jefferson | Arkansas | 5069 | 644 | 28 |
252726 | 252726 | 2020-06-19 | Jefferson | Arkansas | 5069 | 640 | 28 |
249611 | 249611 | 2020-06-18 | Jefferson | Arkansas | 5069 | 637 | 28 |
246499 | 246499 | 2020-06-17 | Jefferson | Arkansas | 5069 | 634 | 28 |
243386 | 243386 | 2020-06-16 | Jefferson | Arkansas | 5069 | 633 | 28 |
240275 | 240275 | 2020-06-15 | Jefferson | Arkansas | 5069 | 633 | 28 |
237167 | 237167 | 2020-06-14 | Jefferson | Arkansas | 5069 | 630 | 28 |
234060 | 234060 | 2020-06-13 | Jefferson | Arkansas | 5069 | 628 | 28 |
230954 | 230954 | 2020-06-12 | Jefferson | Arkansas | 5069 | 625 | 28 |
227851 | 227851 | 2020-06-11 | Jefferson | Arkansas | 5069 | 578 | 28 |
224749 | 224749 | 2020-06-10 | Jefferson | Arkansas | 5069 | 573 | 28 |
221654 | 221654 | 2020-06-09 | Jefferson | Arkansas | 5069 | 559 | 28 |
218559 | 218559 | 2020-06-08 | Jefferson | Arkansas | 5069 | 554 | 26 |
215468 | 215468 | 2020-06-07 | Jefferson | Arkansas | 5069 | 548 | 26 |
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);