ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Franklin" and fips = 12037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534761 | 534761 | 2020-09-15 | Franklin | Florida | 12037 | 582 | 3 |
531526 | 531526 | 2020-09-14 | Franklin | Florida | 12037 | 581 | 3 |
528289 | 528289 | 2020-09-13 | Franklin | Florida | 12037 | 578 | 3 |
525053 | 525053 | 2020-09-12 | Franklin | Florida | 12037 | 578 | 3 |
521817 | 521817 | 2020-09-11 | Franklin | Florida | 12037 | 574 | 3 |
518580 | 518580 | 2020-09-10 | Franklin | Florida | 12037 | 572 | 3 |
515345 | 515345 | 2020-09-09 | Franklin | Florida | 12037 | 569 | 3 |
512112 | 512112 | 2020-09-08 | Franklin | Florida | 12037 | 569 | 3 |
508879 | 508879 | 2020-09-07 | Franklin | Florida | 12037 | 569 | 3 |
505647 | 505647 | 2020-09-06 | Franklin | Florida | 12037 | 568 | 3 |
502413 | 502413 | 2020-09-05 | Franklin | Florida | 12037 | 565 | 3 |
499179 | 499179 | 2020-09-04 | Franklin | Florida | 12037 | 562 | 3 |
495946 | 495946 | 2020-09-03 | Franklin | Florida | 12037 | 560 | 3 |
492712 | 492712 | 2020-09-02 | Franklin | Florida | 12037 | 551 | 3 |
489479 | 489479 | 2020-09-01 | Franklin | Florida | 12037 | 549 | 3 |
486246 | 486246 | 2020-08-31 | Franklin | Florida | 12037 | 544 | 3 |
483011 | 483011 | 2020-08-30 | Franklin | Florida | 12037 | 542 | 3 |
479777 | 479777 | 2020-08-29 | Franklin | Florida | 12037 | 537 | 3 |
476544 | 476544 | 2020-08-28 | Franklin | Florida | 12037 | 529 | 3 |
473311 | 473311 | 2020-08-27 | Franklin | Florida | 12037 | 527 | 3 |
470079 | 470079 | 2020-08-26 | Franklin | Florida | 12037 | 522 | 3 |
466850 | 466850 | 2020-08-25 | Franklin | Florida | 12037 | 520 | 3 |
463621 | 463621 | 2020-08-24 | Franklin | Florida | 12037 | 519 | 3 |
460392 | 460392 | 2020-08-23 | Franklin | Florida | 12037 | 511 | 3 |
457165 | 457165 | 2020-08-22 | Franklin | Florida | 12037 | 509 | 3 |
453937 | 453937 | 2020-08-21 | Franklin | Florida | 12037 | 498 | 3 |
450709 | 450709 | 2020-08-20 | Franklin | Florida | 12037 | 485 | 3 |
447481 | 447481 | 2020-08-19 | Franklin | Florida | 12037 | 480 | 3 |
444254 | 444254 | 2020-08-18 | Franklin | Florida | 12037 | 479 | 3 |
441028 | 441028 | 2020-08-17 | Franklin | Florida | 12037 | 472 | 3 |
437802 | 437802 | 2020-08-16 | Franklin | Florida | 12037 | 473 | 3 |
434576 | 434576 | 2020-08-15 | Franklin | Florida | 12037 | 464 | 3 |
431351 | 431351 | 2020-08-14 | Franklin | Florida | 12037 | 449 | 3 |
428123 | 428123 | 2020-08-13 | Franklin | Florida | 12037 | 448 | 2 |
424899 | 424899 | 2020-08-12 | Franklin | Florida | 12037 | 433 | 2 |
421678 | 421678 | 2020-08-11 | Franklin | Florida | 12037 | 433 | 2 |
418457 | 418457 | 2020-08-10 | Franklin | Florida | 12037 | 430 | 2 |
415236 | 415236 | 2020-08-09 | Franklin | Florida | 12037 | 418 | 2 |
412016 | 412016 | 2020-08-08 | Franklin | Florida | 12037 | 398 | 2 |
408797 | 408797 | 2020-08-07 | Franklin | Florida | 12037 | 377 | 2 |
405577 | 405577 | 2020-08-06 | Franklin | Florida | 12037 | 276 | 2 |
402359 | 402359 | 2020-08-05 | Franklin | Florida | 12037 | 197 | 2 |
399143 | 399143 | 2020-08-04 | Franklin | Florida | 12037 | 189 | 2 |
395927 | 395927 | 2020-08-03 | Franklin | Florida | 12037 | 158 | 2 |
392711 | 392711 | 2020-08-02 | Franklin | Florida | 12037 | 130 | 2 |
389494 | 389494 | 2020-08-01 | Franklin | Florida | 12037 | 116 | 2 |
386277 | 386277 | 2020-07-31 | Franklin | Florida | 12037 | 108 | 1 |
383059 | 383059 | 2020-07-30 | Franklin | Florida | 12037 | 105 | 1 |
379842 | 379842 | 2020-07-29 | Franklin | Florida | 12037 | 103 | 1 |
376625 | 376625 | 2020-07-28 | Franklin | Florida | 12037 | 95 | 1 |
373411 | 373411 | 2020-07-27 | Franklin | Florida | 12037 | 87 | 1 |
370199 | 370199 | 2020-07-26 | Franklin | Florida | 12037 | 88 | 1 |
366989 | 366989 | 2020-07-25 | Franklin | Florida | 12037 | 85 | 1 |
363782 | 363782 | 2020-07-24 | Franklin | Florida | 12037 | 83 | 1 |
360575 | 360575 | 2020-07-23 | Franklin | Florida | 12037 | 82 | 1 |
357370 | 357370 | 2020-07-22 | Franklin | Florida | 12037 | 81 | 1 |
354167 | 354167 | 2020-07-21 | Franklin | Florida | 12037 | 80 | 0 |
350965 | 350965 | 2020-07-20 | Franklin | Florida | 12037 | 77 | 0 |
347764 | 347764 | 2020-07-19 | Franklin | Florida | 12037 | 56 | 0 |
344564 | 344564 | 2020-07-18 | Franklin | Florida | 12037 | 52 | 0 |
341365 | 341365 | 2020-07-17 | Franklin | Florida | 12037 | 50 | 0 |
338168 | 338168 | 2020-07-16 | Franklin | Florida | 12037 | 48 | 0 |
334973 | 334973 | 2020-07-15 | Franklin | Florida | 12037 | 47 | 0 |
331780 | 331780 | 2020-07-14 | Franklin | Florida | 12037 | 45 | 0 |
328593 | 328593 | 2020-07-13 | Franklin | Florida | 12037 | 44 | 0 |
325407 | 325407 | 2020-07-12 | Franklin | Florida | 12037 | 33 | 0 |
322226 | 322226 | 2020-07-11 | Franklin | Florida | 12037 | 31 | 0 |
319047 | 319047 | 2020-07-10 | Franklin | Florida | 12037 | 25 | 0 |
315874 | 315874 | 2020-07-09 | Franklin | Florida | 12037 | 24 | 0 |
312699 | 312699 | 2020-07-08 | Franklin | Florida | 12037 | 19 | 0 |
309529 | 309529 | 2020-07-07 | Franklin | Florida | 12037 | 15 | 0 |
306361 | 306361 | 2020-07-06 | Franklin | Florida | 12037 | 15 | 0 |
303197 | 303197 | 2020-07-05 | Franklin | Florida | 12037 | 15 | 0 |
300033 | 300033 | 2020-07-04 | Franklin | Florida | 12037 | 11 | 0 |
296871 | 296871 | 2020-07-03 | Franklin | Florida | 12037 | 11 | 0 |
293715 | 293715 | 2020-07-02 | Franklin | Florida | 12037 | 9 | 0 |
290561 | 290561 | 2020-07-01 | Franklin | Florida | 12037 | 6 | 0 |
287410 | 287410 | 2020-06-30 | Franklin | Florida | 12037 | 6 | 0 |
284264 | 284264 | 2020-06-29 | Franklin | Florida | 12037 | 6 | 0 |
281118 | 281118 | 2020-06-28 | Franklin | Florida | 12037 | 6 | 0 |
277971 | 277971 | 2020-06-27 | Franklin | Florida | 12037 | 6 | 0 |
274823 | 274823 | 2020-06-26 | Franklin | Florida | 12037 | 6 | 0 |
271683 | 271683 | 2020-06-25 | Franklin | Florida | 12037 | 4 | 0 |
268547 | 268547 | 2020-06-24 | Franklin | Florida | 12037 | 4 | 0 |
265417 | 265417 | 2020-06-23 | Franklin | Florida | 12037 | 4 | 0 |
262289 | 262289 | 2020-06-22 | Franklin | Florida | 12037 | 4 | 0 |
259162 | 259162 | 2020-06-21 | Franklin | Florida | 12037 | 2 | 0 |
256035 | 256035 | 2020-06-20 | Franklin | Florida | 12037 | 2 | 0 |
252916 | 252916 | 2020-06-19 | Franklin | Florida | 12037 | 2 | 0 |
249801 | 249801 | 2020-06-18 | Franklin | Florida | 12037 | 2 | 0 |
246689 | 246689 | 2020-06-17 | Franklin | Florida | 12037 | 2 | 0 |
243576 | 243576 | 2020-06-16 | Franklin | Florida | 12037 | 2 | 0 |
240465 | 240465 | 2020-06-15 | Franklin | Florida | 12037 | 2 | 0 |
237357 | 237357 | 2020-06-14 | Franklin | Florida | 12037 | 2 | 0 |
234250 | 234250 | 2020-06-13 | Franklin | Florida | 12037 | 3 | 0 |
231144 | 231144 | 2020-06-12 | Franklin | Florida | 12037 | 2 | 0 |
228041 | 228041 | 2020-06-11 | Franklin | Florida | 12037 | 2 | 0 |
224939 | 224939 | 2020-06-10 | Franklin | Florida | 12037 | 2 | 0 |
221844 | 221844 | 2020-06-09 | Franklin | Florida | 12037 | 2 | 0 |
218749 | 218749 | 2020-06-08 | Franklin | Florida | 12037 | 2 | 0 |
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);