ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Leon" and state = "Florida" 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 |
531544 | 531544 | 2020-09-14 | Leon | Florida | 12073 | 9132 | 45 |
528307 | 528307 | 2020-09-13 | Leon | Florida | 12073 | 9024 | 45 |
525071 | 525071 | 2020-09-12 | Leon | Florida | 12073 | 8836 | 44 |
521835 | 521835 | 2020-09-11 | Leon | Florida | 12073 | 8588 | 44 |
518598 | 518598 | 2020-09-10 | Leon | Florida | 12073 | 8272 | 44 |
515363 | 515363 | 2020-09-09 | Leon | Florida | 12073 | 8110 | 41 |
512130 | 512130 | 2020-09-08 | Leon | Florida | 12073 | 7942 | 40 |
508897 | 508897 | 2020-09-07 | Leon | Florida | 12073 | 7824 | 40 |
505665 | 505665 | 2020-09-06 | Leon | Florida | 12073 | 7704 | 40 |
502431 | 502431 | 2020-09-05 | Leon | Florida | 12073 | 7475 | 39 |
499197 | 499197 | 2020-09-04 | Leon | Florida | 12073 | 7148 | 38 |
495964 | 495964 | 2020-09-03 | Leon | Florida | 12073 | 6874 | 38 |
492730 | 492730 | 2020-09-02 | Leon | Florida | 12073 | 6596 | 36 |
489497 | 489497 | 2020-09-01 | Leon | Florida | 12073 | 6474 | 35 |
486264 | 486264 | 2020-08-31 | Leon | Florida | 12073 | 6320 | 33 |
483029 | 483029 | 2020-08-30 | Leon | Florida | 12073 | 6293 | 33 |
479795 | 479795 | 2020-08-29 | Leon | Florida | 12073 | 6193 | 33 |
476562 | 476562 | 2020-08-28 | Leon | Florida | 12073 | 6144 | 31 |
473329 | 473329 | 2020-08-27 | Leon | Florida | 12073 | 6066 | 31 |
470097 | 470097 | 2020-08-26 | Leon | Florida | 12073 | 5974 | 30 |
466868 | 466868 | 2020-08-25 | Leon | Florida | 12073 | 5932 | 30 |
463639 | 463639 | 2020-08-24 | Leon | Florida | 12073 | 5907 | 29 |
460410 | 460410 | 2020-08-23 | Leon | Florida | 12073 | 5850 | 29 |
457183 | 457183 | 2020-08-22 | Leon | Florida | 12073 | 5807 | 28 |
453955 | 453955 | 2020-08-21 | Leon | Florida | 12073 | 5704 | 28 |
450727 | 450727 | 2020-08-20 | Leon | Florida | 12073 | 5642 | 27 |
447499 | 447499 | 2020-08-19 | Leon | Florida | 12073 | 5560 | 27 |
444272 | 444272 | 2020-08-18 | Leon | Florida | 12073 | 5515 | 27 |
441046 | 441046 | 2020-08-17 | Leon | Florida | 12073 | 5442 | 27 |
437820 | 437820 | 2020-08-16 | Leon | Florida | 12073 | 5401 | 27 |
434594 | 434594 | 2020-08-15 | Leon | Florida | 12073 | 5362 | 27 |
431369 | 431369 | 2020-08-14 | Leon | Florida | 12073 | 5289 | 26 |
428141 | 428141 | 2020-08-13 | Leon | Florida | 12073 | 5234 | 26 |
424917 | 424917 | 2020-08-12 | Leon | Florida | 12073 | 5149 | 26 |
421696 | 421696 | 2020-08-11 | Leon | Florida | 12073 | 5115 | 26 |
418475 | 418475 | 2020-08-10 | Leon | Florida | 12073 | 5005 | 25 |
415254 | 415254 | 2020-08-09 | Leon | Florida | 12073 | 4964 | 24 |
412034 | 412034 | 2020-08-08 | Leon | Florida | 12073 | 4921 | 24 |
408815 | 408815 | 2020-08-07 | Leon | Florida | 12073 | 4813 | 24 |
405595 | 405595 | 2020-08-06 | Leon | Florida | 12073 | 4642 | 23 |
402377 | 402377 | 2020-08-05 | Leon | Florida | 12073 | 4536 | 21 |
399161 | 399161 | 2020-08-04 | Leon | Florida | 12073 | 4488 | 15 |
395945 | 395945 | 2020-08-03 | Leon | Florida | 12073 | 4447 | 15 |
392729 | 392729 | 2020-08-02 | Leon | Florida | 12073 | 4386 | 14 |
389512 | 389512 | 2020-08-01 | Leon | Florida | 12073 | 4293 | 14 |
386295 | 386295 | 2020-07-31 | Leon | Florida | 12073 | 4170 | 14 |
383077 | 383077 | 2020-07-30 | Leon | Florida | 12073 | 4101 | 14 |
379860 | 379860 | 2020-07-29 | Leon | Florida | 12073 | 4003 | 14 |
376643 | 376643 | 2020-07-28 | Leon | Florida | 12073 | 3948 | 14 |
373429 | 373429 | 2020-07-27 | Leon | Florida | 12073 | 3867 | 14 |
370217 | 370217 | 2020-07-26 | Leon | Florida | 12073 | 3759 | 13 |
367007 | 367007 | 2020-07-25 | Leon | Florida | 12073 | 3655 | 13 |
363800 | 363800 | 2020-07-24 | Leon | Florida | 12073 | 3567 | 13 |
360593 | 360593 | 2020-07-23 | Leon | Florida | 12073 | 3479 | 13 |
357388 | 357388 | 2020-07-22 | Leon | Florida | 12073 | 3318 | 13 |
354185 | 354185 | 2020-07-21 | Leon | Florida | 12073 | 3264 | 11 |
350983 | 350983 | 2020-07-20 | Leon | Florida | 12073 | 3139 | 11 |
347782 | 347782 | 2020-07-19 | Leon | Florida | 12073 | 3004 | 10 |
344582 | 344582 | 2020-07-18 | Leon | Florida | 12073 | 2883 | 10 |
341383 | 341383 | 2020-07-17 | Leon | Florida | 12073 | 2816 | 10 |
338186 | 338186 | 2020-07-16 | Leon | Florida | 12073 | 2708 | 10 |
334991 | 334991 | 2020-07-15 | Leon | Florida | 12073 | 2605 | 10 |
331798 | 331798 | 2020-07-14 | Leon | Florida | 12073 | 2519 | 10 |
328611 | 328611 | 2020-07-13 | Leon | Florida | 12073 | 2447 | 8 |
325425 | 325425 | 2020-07-12 | Leon | Florida | 12073 | 2347 | 8 |
322244 | 322244 | 2020-07-11 | Leon | Florida | 12073 | 2245 | 8 |
319065 | 319065 | 2020-07-10 | Leon | Florida | 12073 | 2160 | 8 |
315892 | 315892 | 2020-07-09 | Leon | Florida | 12073 | 2046 | 8 |
312717 | 312717 | 2020-07-08 | Leon | Florida | 12073 | 1954 | 8 |
309547 | 309547 | 2020-07-07 | Leon | Florida | 12073 | 1910 | 8 |
306379 | 306379 | 2020-07-06 | Leon | Florida | 12073 | 1869 | 8 |
303215 | 303215 | 2020-07-05 | Leon | Florida | 12073 | 1797 | 8 |
300051 | 300051 | 2020-07-04 | Leon | Florida | 12073 | 1637 | 8 |
296889 | 296889 | 2020-07-03 | Leon | Florida | 12073 | 1465 | 8 |
293733 | 293733 | 2020-07-02 | Leon | Florida | 12073 | 1376 | 8 |
290579 | 290579 | 2020-07-01 | Leon | Florida | 12073 | 1148 | 8 |
287428 | 287428 | 2020-06-30 | Leon | Florida | 12073 | 1113 | 8 |
284282 | 284282 | 2020-06-29 | Leon | Florida | 12073 | 997 | 8 |
281136 | 281136 | 2020-06-28 | Leon | Florida | 12073 | 950 | 8 |
277989 | 277989 | 2020-06-27 | Leon | Florida | 12073 | 774 | 8 |
274841 | 274841 | 2020-06-26 | Leon | Florida | 12073 | 694 | 8 |
271701 | 271701 | 2020-06-25 | Leon | Florida | 12073 | 641 | 8 |
268565 | 268565 | 2020-06-24 | Leon | Florida | 12073 | 613 | 8 |
265435 | 265435 | 2020-06-23 | Leon | Florida | 12073 | 595 | 8 |
262307 | 262307 | 2020-06-22 | Leon | Florida | 12073 | 586 | 8 |
259180 | 259180 | 2020-06-21 | Leon | Florida | 12073 | 572 | 8 |
256053 | 256053 | 2020-06-20 | Leon | Florida | 12073 | 556 | 8 |
252934 | 252934 | 2020-06-19 | Leon | Florida | 12073 | 507 | 8 |
249819 | 249819 | 2020-06-18 | Leon | Florida | 12073 | 494 | 8 |
246707 | 246707 | 2020-06-17 | Leon | Florida | 12073 | 484 | 8 |
243594 | 243594 | 2020-06-16 | Leon | Florida | 12073 | 482 | 8 |
240483 | 240483 | 2020-06-15 | Leon | Florida | 12073 | 473 | 8 |
237375 | 237375 | 2020-06-14 | Leon | Florida | 12073 | 468 | 8 |
234268 | 234268 | 2020-06-13 | Leon | Florida | 12073 | 463 | 8 |
231162 | 231162 | 2020-06-12 | Leon | Florida | 12073 | 463 | 8 |
228059 | 228059 | 2020-06-11 | Leon | Florida | 12073 | 455 | 8 |
224957 | 224957 | 2020-06-10 | Leon | Florida | 12073 | 450 | 8 |
221862 | 221862 | 2020-06-09 | Leon | Florida | 12073 | 447 | 7 |
218767 | 218767 | 2020-06-08 | Leon | Florida | 12073 | 442 | 7 |
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);