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 |
---|---|---|---|---|---|---|---|
2337162 | 2337162 | 2022-03-24 | Leon | Florida | 12073 | 84655 | 641 |
2339577 | 2339577 | 2022-03-24 | Leon | Texas | 48289 | 3706 | 93 |
2333908 | 2333908 | 2022-03-23 | Leon | Florida | 12073 | 84655 | 630 |
2336323 | 2336323 | 2022-03-23 | Leon | Texas | 48289 | 3702 | 93 |
2330654 | 2330654 | 2022-03-22 | Leon | Florida | 12073 | 84655 | 630 |
2333069 | 2333069 | 2022-03-22 | Leon | Texas | 48289 | 3701 | 93 |
2327402 | 2327402 | 2022-03-21 | Leon | Florida | 12073 | 84655 | 630 |
2329816 | 2329816 | 2022-03-21 | Leon | Texas | 48289 | 3701 | 93 |
2324149 | 2324149 | 2022-03-20 | Leon | Florida | 12073 | 84655 | 630 |
2326564 | 2326564 | 2022-03-20 | Leon | Texas | 48289 | 3701 | 93 |
2320895 | 2320895 | 2022-03-19 | Leon | Florida | 12073 | 84655 | 630 |
2323311 | 2323311 | 2022-03-19 | Leon | Texas | 48289 | 3701 | 93 |
2317641 | 2317641 | 2022-03-18 | Leon | Florida | 12073 | 84655 | 630 |
2320057 | 2320057 | 2022-03-18 | Leon | Texas | 48289 | 3701 | 92 |
2314388 | 2314388 | 2022-03-17 | Leon | Florida | 12073 | 84655 | 630 |
2316803 | 2316803 | 2022-03-17 | Leon | Texas | 48289 | 3700 | 92 |
2311135 | 2311135 | 2022-03-16 | Leon | Florida | 12073 | 84655 | 630 |
2313550 | 2313550 | 2022-03-16 | Leon | Texas | 48289 | 3698 | 91 |
2307882 | 2307882 | 2022-03-15 | Leon | Florida | 12073 | 84655 | 620 |
2310297 | 2310297 | 2022-03-15 | Leon | Texas | 48289 | 3698 | 91 |
2304631 | 2304631 | 2022-03-14 | Leon | Florida | 12073 | 84655 | 620 |
2307044 | 2307044 | 2022-03-14 | Leon | Texas | 48289 | 3696 | 91 |
2301379 | 2301379 | 2022-03-13 | Leon | Florida | 12073 | 84655 | 620 |
2303793 | 2303793 | 2022-03-13 | Leon | Texas | 48289 | 3694 | 91 |
2298127 | 2298127 | 2022-03-12 | Leon | Florida | 12073 | 84655 | 620 |
2300541 | 2300541 | 2022-03-12 | Leon | Texas | 48289 | 3693 | 91 |
2294875 | 2294875 | 2022-03-11 | Leon | Florida | 12073 | 84655 | 620 |
2297289 | 2297289 | 2022-03-11 | Leon | Texas | 48289 | 3692 | 90 |
2291623 | 2291623 | 2022-03-10 | Leon | Florida | 12073 | 84539 | 620 |
2294037 | 2294037 | 2022-03-10 | Leon | Texas | 48289 | 3690 | 90 |
2288371 | 2288371 | 2022-03-09 | Leon | Florida | 12073 | 84539 | 620 |
2290785 | 2290785 | 2022-03-09 | Leon | Texas | 48289 | 3686 | 90 |
2285120 | 2285120 | 2022-03-08 | Leon | Florida | 12073 | 84539 | 606 |
2287533 | 2287533 | 2022-03-08 | Leon | Texas | 48289 | 3685 | 90 |
2281868 | 2281868 | 2022-03-07 | Leon | Florida | 12073 | 84539 | 606 |
2284281 | 2284281 | 2022-03-07 | Leon | Texas | 48289 | 3684 | 89 |
2278615 | 2278615 | 2022-03-06 | Leon | Florida | 12073 | 84539 | 606 |
2281029 | 2281029 | 2022-03-06 | Leon | Texas | 48289 | 3683 | 89 |
2275362 | 2275362 | 2022-03-05 | Leon | Florida | 12073 | 84539 | 606 |
2277776 | 2277776 | 2022-03-05 | Leon | Texas | 48289 | 3683 | 89 |
2272109 | 2272109 | 2022-03-04 | Leon | Florida | 12073 | 84539 | 606 |
2274523 | 2274523 | 2022-03-04 | Leon | Texas | 48289 | 3682 | 89 |
2268857 | 2268857 | 2022-03-03 | Leon | Florida | 12073 | 84316 | 606 |
2271270 | 2271270 | 2022-03-03 | Leon | Texas | 48289 | 3679 | 89 |
2265604 | 2265604 | 2022-03-02 | Leon | Florida | 12073 | 84316 | 606 |
2268018 | 2268018 | 2022-03-02 | Leon | Texas | 48289 | 3679 | 89 |
2262353 | 2262353 | 2022-03-01 | Leon | Florida | 12073 | 84316 | 594 |
2264765 | 2264765 | 2022-03-01 | Leon | Texas | 48289 | 3679 | 89 |
2259102 | 2259102 | 2022-02-28 | Leon | Florida | 12073 | 84316 | 594 |
2261515 | 2261515 | 2022-02-28 | Leon | Texas | 48289 | 3672 | 89 |
2255851 | 2255851 | 2022-02-27 | Leon | Florida | 12073 | 84316 | 594 |
2258264 | 2258264 | 2022-02-27 | Leon | Texas | 48289 | 3670 | 89 |
2252600 | 2252600 | 2022-02-26 | Leon | Florida | 12073 | 84316 | 594 |
2255013 | 2255013 | 2022-02-26 | Leon | Texas | 48289 | 3670 | 88 |
2249349 | 2249349 | 2022-02-25 | Leon | Florida | 12073 | 84316 | 594 |
2251762 | 2251762 | 2022-02-25 | Leon | Texas | 48289 | 3668 | 88 |
2246098 | 2246098 | 2022-02-24 | Leon | Florida | 12073 | 83989 | 594 |
2248511 | 2248511 | 2022-02-24 | Leon | Texas | 48289 | 3667 | 88 |
2242847 | 2242847 | 2022-02-23 | Leon | Florida | 12073 | 83989 | 594 |
2245260 | 2245260 | 2022-02-23 | Leon | Texas | 48289 | 3662 | 88 |
2239596 | 2239596 | 2022-02-22 | Leon | Florida | 12073 | 83989 | 570 |
2242009 | 2242009 | 2022-02-22 | Leon | Texas | 48289 | 3656 | 87 |
2236345 | 2236345 | 2022-02-21 | Leon | Florida | 12073 | 83989 | 570 |
2238758 | 2238758 | 2022-02-21 | Leon | Texas | 48289 | 3656 | 87 |
2233094 | 2233094 | 2022-02-20 | Leon | Florida | 12073 | 83989 | 570 |
2235507 | 2235507 | 2022-02-20 | Leon | Texas | 48289 | 3655 | 87 |
2229843 | 2229843 | 2022-02-19 | Leon | Florida | 12073 | 83989 | 570 |
2232256 | 2232256 | 2022-02-19 | Leon | Texas | 48289 | 3654 | 86 |
2226592 | 2226592 | 2022-02-18 | Leon | Florida | 12073 | 83989 | 570 |
2229005 | 2229005 | 2022-02-18 | Leon | Texas | 48289 | 3647 | 86 |
2223341 | 2223341 | 2022-02-17 | Leon | Florida | 12073 | 83283 | 570 |
2225754 | 2225754 | 2022-02-17 | Leon | Texas | 48289 | 3645 | 86 |
2220090 | 2220090 | 2022-02-16 | Leon | Florida | 12073 | 83283 | 570 |
2222503 | 2222503 | 2022-02-16 | Leon | Texas | 48289 | 3642 | 85 |
2216839 | 2216839 | 2022-02-15 | Leon | Florida | 12073 | 83283 | 561 |
2219252 | 2219252 | 2022-02-15 | Leon | Texas | 48289 | 3638 | 84 |
2213588 | 2213588 | 2022-02-14 | Leon | Florida | 12073 | 83283 | 561 |
2216001 | 2216001 | 2022-02-14 | Leon | Texas | 48289 | 3626 | 84 |
2210336 | 2210336 | 2022-02-13 | Leon | Florida | 12073 | 83283 | 561 |
2212750 | 2212750 | 2022-02-13 | Leon | Texas | 48289 | 3623 | 84 |
2207083 | 2207083 | 2022-02-12 | Leon | Florida | 12073 | 83283 | 561 |
2209497 | 2209497 | 2022-02-12 | Leon | Texas | 48289 | 3618 | 84 |
2203830 | 2203830 | 2022-02-11 | Leon | Florida | 12073 | 83283 | 561 |
2206244 | 2206244 | 2022-02-11 | Leon | Texas | 48289 | 3614 | 83 |
2200577 | 2200577 | 2022-02-10 | Leon | Florida | 12073 | 80881 | 561 |
2202991 | 2202991 | 2022-02-10 | Leon | Texas | 48289 | 3611 | 81 |
2197323 | 2197323 | 2022-02-09 | Leon | Florida | 12073 | 80881 | 561 |
2199737 | 2199737 | 2022-02-09 | Leon | Texas | 48289 | 3602 | 81 |
2194069 | 2194069 | 2022-02-08 | Leon | Florida | 12073 | 80881 | 551 |
2196483 | 2196483 | 2022-02-08 | Leon | Texas | 48289 | 3582 | 81 |
2190815 | 2190815 | 2022-02-07 | Leon | Florida | 12073 | 80881 | 551 |
2193229 | 2193229 | 2022-02-07 | Leon | Texas | 48289 | 3577 | 81 |
2187562 | 2187562 | 2022-02-06 | Leon | Florida | 12073 | 80881 | 551 |
2189975 | 2189975 | 2022-02-06 | Leon | Texas | 48289 | 3576 | 81 |
2184309 | 2184309 | 2022-02-05 | Leon | Florida | 12073 | 80881 | 551 |
2186722 | 2186722 | 2022-02-05 | Leon | Texas | 48289 | 3565 | 81 |
2181057 | 2181057 | 2022-02-04 | Leon | Florida | 12073 | 80881 | 551 |
2183470 | 2183470 | 2022-02-04 | Leon | Texas | 48289 | 3556 | 81 |
2177806 | 2177806 | 2022-02-03 | Leon | Florida | 12073 | 78130 | 551 |
2180218 | 2180218 | 2022-02-03 | Leon | Texas | 48289 | 3555 | 80 |
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);