ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Gilchrist" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499917 | 2499917 | 2022-05-13 | Gilchrist | Florida | 12041 | 4562 | 93 |
2496659 | 2496659 | 2022-05-12 | Gilchrist | Florida | 12041 | 4562 | 93 |
2493401 | 2493401 | 2022-05-11 | Gilchrist | Florida | 12041 | 4562 | 93 |
2490143 | 2490143 | 2022-05-10 | Gilchrist | Florida | 12041 | 4562 | 93 |
2486886 | 2486886 | 2022-05-09 | Gilchrist | Florida | 12041 | 4562 | 93 |
2483628 | 2483628 | 2022-05-08 | Gilchrist | Florida | 12041 | 4562 | 93 |
2480370 | 2480370 | 2022-05-07 | Gilchrist | Florida | 12041 | 4562 | 93 |
2477112 | 2477112 | 2022-05-06 | Gilchrist | Florida | 12041 | 4562 | 93 |
2473854 | 2473854 | 2022-05-05 | Gilchrist | Florida | 12041 | 4553 | 93 |
2470597 | 2470597 | 2022-05-04 | Gilchrist | Florida | 12041 | 4553 | 93 |
2467341 | 2467341 | 2022-05-03 | Gilchrist | Florida | 12041 | 4553 | 93 |
2464086 | 2464086 | 2022-05-02 | Gilchrist | Florida | 12041 | 4553 | 93 |
2460830 | 2460830 | 2022-05-01 | Gilchrist | Florida | 12041 | 4553 | 93 |
2457574 | 2457574 | 2022-04-30 | Gilchrist | Florida | 12041 | 4553 | 93 |
2454318 | 2454318 | 2022-04-29 | Gilchrist | Florida | 12041 | 4553 | 93 |
2451062 | 2451062 | 2022-04-28 | Gilchrist | Florida | 12041 | 4553 | 93 |
2447806 | 2447806 | 2022-04-27 | Gilchrist | Florida | 12041 | 4553 | 93 |
2444550 | 2444550 | 2022-04-26 | Gilchrist | Florida | 12041 | 4553 | 92 |
2441294 | 2441294 | 2022-04-25 | Gilchrist | Florida | 12041 | 4553 | 92 |
2438038 | 2438038 | 2022-04-24 | Gilchrist | Florida | 12041 | 4553 | 92 |
2434782 | 2434782 | 2022-04-23 | Gilchrist | Florida | 12041 | 4553 | 92 |
2431526 | 2431526 | 2022-04-22 | Gilchrist | Florida | 12041 | 4553 | 92 |
2428270 | 2428270 | 2022-04-21 | Gilchrist | Florida | 12041 | 4538 | 92 |
2425014 | 2425014 | 2022-04-20 | Gilchrist | Florida | 12041 | 4538 | 92 |
2421758 | 2421758 | 2022-04-19 | Gilchrist | Florida | 12041 | 4538 | 90 |
2418502 | 2418502 | 2022-04-18 | Gilchrist | Florida | 12041 | 4538 | 90 |
2415246 | 2415246 | 2022-04-17 | Gilchrist | Florida | 12041 | 4538 | 90 |
2411990 | 2411990 | 2022-04-16 | Gilchrist | Florida | 12041 | 4538 | 90 |
2408734 | 2408734 | 2022-04-15 | Gilchrist | Florida | 12041 | 4538 | 90 |
2405478 | 2405478 | 2022-04-14 | Gilchrist | Florida | 12041 | 4538 | 90 |
2402223 | 2402223 | 2022-04-13 | Gilchrist | Florida | 12041 | 4538 | 90 |
2398968 | 2398968 | 2022-04-12 | Gilchrist | Florida | 12041 | 4538 | 89 |
2395713 | 2395713 | 2022-04-11 | Gilchrist | Florida | 12041 | 4538 | 89 |
2392457 | 2392457 | 2022-04-10 | Gilchrist | Florida | 12041 | 4538 | 89 |
2389201 | 2389201 | 2022-04-09 | Gilchrist | Florida | 12041 | 4538 | 89 |
2385946 | 2385946 | 2022-04-08 | Gilchrist | Florida | 12041 | 4538 | 89 |
2382691 | 2382691 | 2022-04-07 | Gilchrist | Florida | 12041 | 4534 | 89 |
2379436 | 2379436 | 2022-04-06 | Gilchrist | Florida | 12041 | 4534 | 89 |
2376182 | 2376182 | 2022-04-05 | Gilchrist | Florida | 12041 | 4534 | 89 |
2372930 | 2372930 | 2022-04-04 | Gilchrist | Florida | 12041 | 4534 | 89 |
2369677 | 2369677 | 2022-04-03 | Gilchrist | Florida | 12041 | 4534 | 89 |
2366424 | 2366424 | 2022-04-02 | Gilchrist | Florida | 12041 | 4534 | 89 |
2363171 | 2363171 | 2022-04-01 | Gilchrist | Florida | 12041 | 4534 | 89 |
2359917 | 2359917 | 2022-03-31 | Gilchrist | Florida | 12041 | 4534 | 89 |
2356663 | 2356663 | 2022-03-30 | Gilchrist | Florida | 12041 | 4534 | 89 |
2353410 | 2353410 | 2022-03-29 | Gilchrist | Florida | 12041 | 4534 | 88 |
2350158 | 2350158 | 2022-03-28 | Gilchrist | Florida | 12041 | 4534 | 88 |
2346905 | 2346905 | 2022-03-27 | Gilchrist | Florida | 12041 | 4534 | 88 |
2343652 | 2343652 | 2022-03-26 | Gilchrist | Florida | 12041 | 4534 | 88 |
2340399 | 2340399 | 2022-03-25 | Gilchrist | Florida | 12041 | 4534 | 88 |
2337146 | 2337146 | 2022-03-24 | Gilchrist | Florida | 12041 | 4517 | 88 |
2333892 | 2333892 | 2022-03-23 | Gilchrist | Florida | 12041 | 4517 | 85 |
2330638 | 2330638 | 2022-03-22 | Gilchrist | Florida | 12041 | 4517 | 85 |
2327386 | 2327386 | 2022-03-21 | Gilchrist | Florida | 12041 | 4517 | 85 |
2324133 | 2324133 | 2022-03-20 | Gilchrist | Florida | 12041 | 4517 | 85 |
2320879 | 2320879 | 2022-03-19 | Gilchrist | Florida | 12041 | 4517 | 85 |
2317625 | 2317625 | 2022-03-18 | Gilchrist | Florida | 12041 | 4517 | 85 |
2314372 | 2314372 | 2022-03-17 | Gilchrist | Florida | 12041 | 4517 | 85 |
2311119 | 2311119 | 2022-03-16 | Gilchrist | Florida | 12041 | 4517 | 85 |
2307866 | 2307866 | 2022-03-15 | Gilchrist | Florida | 12041 | 4517 | 83 |
2304615 | 2304615 | 2022-03-14 | Gilchrist | Florida | 12041 | 4517 | 83 |
2301363 | 2301363 | 2022-03-13 | Gilchrist | Florida | 12041 | 4517 | 83 |
2298111 | 2298111 | 2022-03-12 | Gilchrist | Florida | 12041 | 4517 | 83 |
2294859 | 2294859 | 2022-03-11 | Gilchrist | Florida | 12041 | 4517 | 83 |
2291607 | 2291607 | 2022-03-10 | Gilchrist | Florida | 12041 | 4496 | 83 |
2288355 | 2288355 | 2022-03-09 | Gilchrist | Florida | 12041 | 4496 | 83 |
2285104 | 2285104 | 2022-03-08 | Gilchrist | Florida | 12041 | 4496 | 80 |
2281852 | 2281852 | 2022-03-07 | Gilchrist | Florida | 12041 | 4496 | 80 |
2278599 | 2278599 | 2022-03-06 | Gilchrist | Florida | 12041 | 4496 | 80 |
2275346 | 2275346 | 2022-03-05 | Gilchrist | Florida | 12041 | 4496 | 80 |
2272093 | 2272093 | 2022-03-04 | Gilchrist | Florida | 12041 | 4496 | 80 |
2268841 | 2268841 | 2022-03-03 | Gilchrist | Florida | 12041 | 4472 | 80 |
2265588 | 2265588 | 2022-03-02 | Gilchrist | Florida | 12041 | 4472 | 80 |
2262337 | 2262337 | 2022-03-01 | Gilchrist | Florida | 12041 | 4472 | 75 |
2259086 | 2259086 | 2022-02-28 | Gilchrist | Florida | 12041 | 4472 | 75 |
2255835 | 2255835 | 2022-02-27 | Gilchrist | Florida | 12041 | 4472 | 75 |
2252584 | 2252584 | 2022-02-26 | Gilchrist | Florida | 12041 | 4472 | 75 |
2249333 | 2249333 | 2022-02-25 | Gilchrist | Florida | 12041 | 4472 | 75 |
2246082 | 2246082 | 2022-02-24 | Gilchrist | Florida | 12041 | 4438 | 75 |
2242831 | 2242831 | 2022-02-23 | Gilchrist | Florida | 12041 | 4438 | 75 |
2239580 | 2239580 | 2022-02-22 | Gilchrist | Florida | 12041 | 4438 | 71 |
2236329 | 2236329 | 2022-02-21 | Gilchrist | Florida | 12041 | 4438 | 71 |
2233078 | 2233078 | 2022-02-20 | Gilchrist | Florida | 12041 | 4438 | 71 |
2229827 | 2229827 | 2022-02-19 | Gilchrist | Florida | 12041 | 4438 | 71 |
2226576 | 2226576 | 2022-02-18 | Gilchrist | Florida | 12041 | 4438 | 71 |
2223325 | 2223325 | 2022-02-17 | Gilchrist | Florida | 12041 | 4401 | 71 |
2220074 | 2220074 | 2022-02-16 | Gilchrist | Florida | 12041 | 4401 | 71 |
2216823 | 2216823 | 2022-02-15 | Gilchrist | Florida | 12041 | 4401 | 71 |
2213572 | 2213572 | 2022-02-14 | Gilchrist | Florida | 12041 | 4401 | 71 |
2210320 | 2210320 | 2022-02-13 | Gilchrist | Florida | 12041 | 4401 | 71 |
2207067 | 2207067 | 2022-02-12 | Gilchrist | Florida | 12041 | 4401 | 71 |
2203814 | 2203814 | 2022-02-11 | Gilchrist | Florida | 12041 | 4401 | 71 |
2200561 | 2200561 | 2022-02-10 | Gilchrist | Florida | 12041 | 4281 | 71 |
2197307 | 2197307 | 2022-02-09 | Gilchrist | Florida | 12041 | 4281 | 71 |
2194053 | 2194053 | 2022-02-08 | Gilchrist | Florida | 12041 | 4281 | 71 |
2190799 | 2190799 | 2022-02-07 | Gilchrist | Florida | 12041 | 4281 | 71 |
2187546 | 2187546 | 2022-02-06 | Gilchrist | Florida | 12041 | 4281 | 71 |
2184293 | 2184293 | 2022-02-05 | Gilchrist | Florida | 12041 | 4281 | 71 |
2181041 | 2181041 | 2022-02-04 | Gilchrist | Florida | 12041 | 4281 | 71 |
2177790 | 2177790 | 2022-02-03 | Gilchrist | Florida | 12041 | 4065 | 71 |
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);