ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,562 rows where county = "Leon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534779 | 534779 | 2020-09-15 | Leon | Florida | 12073 | 9270 | 46 |
537179 | 537179 | 2020-09-15 | Leon | Texas | 48289 | 221 | 5 |
531544 | 531544 | 2020-09-14 | Leon | Florida | 12073 | 9132 | 45 |
533943 | 533943 | 2020-09-14 | Leon | Texas | 48289 | 210 | 5 |
528307 | 528307 | 2020-09-13 | Leon | Florida | 12073 | 9024 | 45 |
530708 | 530708 | 2020-09-13 | Leon | Texas | 48289 | 210 | 5 |
525071 | 525071 | 2020-09-12 | Leon | Florida | 12073 | 8836 | 44 |
527471 | 527471 | 2020-09-12 | Leon | Texas | 48289 | 210 | 5 |
521835 | 521835 | 2020-09-11 | Leon | Florida | 12073 | 8588 | 44 |
524235 | 524235 | 2020-09-11 | Leon | Texas | 48289 | 209 | 5 |
518598 | 518598 | 2020-09-10 | Leon | Florida | 12073 | 8272 | 44 |
520999 | 520999 | 2020-09-10 | Leon | Texas | 48289 | 207 | 5 |
515363 | 515363 | 2020-09-09 | Leon | Florida | 12073 | 8110 | 41 |
517763 | 517763 | 2020-09-09 | Leon | Texas | 48289 | 207 | 5 |
512130 | 512130 | 2020-09-08 | Leon | Florida | 12073 | 7942 | 40 |
514528 | 514528 | 2020-09-08 | Leon | Texas | 48289 | 205 | 5 |
508897 | 508897 | 2020-09-07 | Leon | Florida | 12073 | 7824 | 40 |
511295 | 511295 | 2020-09-07 | Leon | Texas | 48289 | 205 | 5 |
505665 | 505665 | 2020-09-06 | Leon | Florida | 12073 | 7704 | 40 |
508062 | 508062 | 2020-09-06 | Leon | Texas | 48289 | 205 | 5 |
502431 | 502431 | 2020-09-05 | Leon | Florida | 12073 | 7475 | 39 |
504830 | 504830 | 2020-09-05 | Leon | Texas | 48289 | 205 | 5 |
499197 | 499197 | 2020-09-04 | Leon | Florida | 12073 | 7148 | 38 |
501596 | 501596 | 2020-09-04 | Leon | Texas | 48289 | 205 | 5 |
495964 | 495964 | 2020-09-03 | Leon | Florida | 12073 | 6874 | 38 |
498362 | 498362 | 2020-09-03 | Leon | Texas | 48289 | 204 | 5 |
492730 | 492730 | 2020-09-02 | Leon | Florida | 12073 | 6596 | 36 |
495129 | 495129 | 2020-09-02 | Leon | Texas | 48289 | 201 | 5 |
489497 | 489497 | 2020-09-01 | Leon | Florida | 12073 | 6474 | 35 |
491895 | 491895 | 2020-09-01 | Leon | Texas | 48289 | 192 | 5 |
486264 | 486264 | 2020-08-31 | Leon | Florida | 12073 | 6320 | 33 |
488662 | 488662 | 2020-08-31 | Leon | Texas | 48289 | 188 | 4 |
483029 | 483029 | 2020-08-30 | Leon | Florida | 12073 | 6293 | 33 |
485429 | 485429 | 2020-08-30 | Leon | Texas | 48289 | 188 | 4 |
479795 | 479795 | 2020-08-29 | Leon | Florida | 12073 | 6193 | 33 |
482194 | 482194 | 2020-08-29 | Leon | Texas | 48289 | 186 | 4 |
476562 | 476562 | 2020-08-28 | Leon | Florida | 12073 | 6144 | 31 |
478960 | 478960 | 2020-08-28 | Leon | Texas | 48289 | 180 | 4 |
473329 | 473329 | 2020-08-27 | Leon | Florida | 12073 | 6066 | 31 |
475727 | 475727 | 2020-08-27 | Leon | Texas | 48289 | 178 | 4 |
470097 | 470097 | 2020-08-26 | Leon | Florida | 12073 | 5974 | 30 |
472494 | 472494 | 2020-08-26 | Leon | Texas | 48289 | 173 | 4 |
466868 | 466868 | 2020-08-25 | Leon | Florida | 12073 | 5932 | 30 |
469262 | 469262 | 2020-08-25 | Leon | Texas | 48289 | 167 | 4 |
463639 | 463639 | 2020-08-24 | Leon | Florida | 12073 | 5907 | 29 |
466033 | 466033 | 2020-08-24 | Leon | Texas | 48289 | 167 | 4 |
460410 | 460410 | 2020-08-23 | Leon | Florida | 12073 | 5850 | 29 |
462804 | 462804 | 2020-08-23 | Leon | Texas | 48289 | 167 | 4 |
457183 | 457183 | 2020-08-22 | Leon | Florida | 12073 | 5807 | 28 |
459575 | 459575 | 2020-08-22 | Leon | Texas | 48289 | 165 | 4 |
453955 | 453955 | 2020-08-21 | Leon | Florida | 12073 | 5704 | 28 |
456348 | 456348 | 2020-08-21 | Leon | Texas | 48289 | 162 | 4 |
450727 | 450727 | 2020-08-20 | Leon | Florida | 12073 | 5642 | 27 |
453120 | 453120 | 2020-08-20 | Leon | Texas | 48289 | 161 | 3 |
447499 | 447499 | 2020-08-19 | Leon | Florida | 12073 | 5560 | 27 |
449892 | 449892 | 2020-08-19 | Leon | Texas | 48289 | 159 | 3 |
444272 | 444272 | 2020-08-18 | Leon | Florida | 12073 | 5515 | 27 |
446664 | 446664 | 2020-08-18 | Leon | Texas | 48289 | 159 | 3 |
441046 | 441046 | 2020-08-17 | Leon | Florida | 12073 | 5442 | 27 |
443437 | 443437 | 2020-08-17 | Leon | Texas | 48289 | 158 | 3 |
437820 | 437820 | 2020-08-16 | Leon | Florida | 12073 | 5401 | 27 |
440211 | 440211 | 2020-08-16 | Leon | Texas | 48289 | 158 | 3 |
434594 | 434594 | 2020-08-15 | Leon | Florida | 12073 | 5362 | 27 |
436985 | 436985 | 2020-08-15 | Leon | Texas | 48289 | 158 | 3 |
431369 | 431369 | 2020-08-14 | Leon | Florida | 12073 | 5289 | 26 |
433759 | 433759 | 2020-08-14 | Leon | Texas | 48289 | 156 | 3 |
428141 | 428141 | 2020-08-13 | Leon | Florida | 12073 | 5234 | 26 |
430534 | 430534 | 2020-08-13 | Leon | Texas | 48289 | 154 | 3 |
424917 | 424917 | 2020-08-12 | Leon | Florida | 12073 | 5149 | 26 |
427307 | 427307 | 2020-08-12 | Leon | Texas | 48289 | 145 | 3 |
421696 | 421696 | 2020-08-11 | Leon | Florida | 12073 | 5115 | 26 |
424083 | 424083 | 2020-08-11 | Leon | Texas | 48289 | 145 | 3 |
418475 | 418475 | 2020-08-10 | Leon | Florida | 12073 | 5005 | 25 |
420862 | 420862 | 2020-08-10 | Leon | Texas | 48289 | 144 | 2 |
415254 | 415254 | 2020-08-09 | Leon | Florida | 12073 | 4964 | 24 |
417641 | 417641 | 2020-08-09 | Leon | Texas | 48289 | 143 | 2 |
412034 | 412034 | 2020-08-08 | Leon | Florida | 12073 | 4921 | 24 |
414420 | 414420 | 2020-08-08 | Leon | Texas | 48289 | 143 | 2 |
408815 | 408815 | 2020-08-07 | Leon | Florida | 12073 | 4813 | 24 |
411200 | 411200 | 2020-08-07 | Leon | Texas | 48289 | 141 | 2 |
405595 | 405595 | 2020-08-06 | Leon | Florida | 12073 | 4642 | 23 |
407981 | 407981 | 2020-08-06 | Leon | Texas | 48289 | 138 | 2 |
402377 | 402377 | 2020-08-05 | Leon | Florida | 12073 | 4536 | 21 |
404761 | 404761 | 2020-08-05 | Leon | Texas | 48289 | 138 | 2 |
399161 | 399161 | 2020-08-04 | Leon | Florida | 12073 | 4488 | 15 |
401543 | 401543 | 2020-08-04 | Leon | Texas | 48289 | 138 | 1 |
395945 | 395945 | 2020-08-03 | Leon | Florida | 12073 | 4447 | 15 |
398327 | 398327 | 2020-08-03 | Leon | Texas | 48289 | 138 | 1 |
392729 | 392729 | 2020-08-02 | Leon | Florida | 12073 | 4386 | 14 |
395111 | 395111 | 2020-08-02 | Leon | Texas | 48289 | 138 | 1 |
389512 | 389512 | 2020-08-01 | Leon | Florida | 12073 | 4293 | 14 |
391895 | 391895 | 2020-08-01 | Leon | Texas | 48289 | 138 | 1 |
386295 | 386295 | 2020-07-31 | Leon | Florida | 12073 | 4170 | 14 |
388678 | 388678 | 2020-07-31 | Leon | Texas | 48289 | 137 | 1 |
383077 | 383077 | 2020-07-30 | Leon | Florida | 12073 | 4101 | 14 |
385461 | 385461 | 2020-07-30 | Leon | Texas | 48289 | 137 | 1 |
379860 | 379860 | 2020-07-29 | Leon | Florida | 12073 | 4003 | 14 |
382243 | 382243 | 2020-07-29 | Leon | Texas | 48289 | 135 | 1 |
376643 | 376643 | 2020-07-28 | Leon | Florida | 12073 | 3948 | 14 |
379026 | 379026 | 2020-07-28 | Leon | Texas | 48289 | 130 | 1 |
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);