ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

790 rows where county = "Baker" and state = "Florida" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Florida · 790 ✖

fips 1

county 1

  • Baker · 790 ✖
Link rowid date ▲ county state fips cases deaths
2499899 2499899 2022-05-13 Baker Florida 12003 8712 142
2496641 2496641 2022-05-12 Baker Florida 12003 8712 142
2493383 2493383 2022-05-11 Baker Florida 12003 8712 142
2490125 2490125 2022-05-10 Baker Florida 12003 8712 142
2486868 2486868 2022-05-09 Baker Florida 12003 8712 142
2483610 2483610 2022-05-08 Baker Florida 12003 8712 142
2480352 2480352 2022-05-07 Baker Florida 12003 8712 142
2477094 2477094 2022-05-06 Baker Florida 12003 8712 142
2473836 2473836 2022-05-05 Baker Florida 12003 8685 142
2470579 2470579 2022-05-04 Baker Florida 12003 8685 142
2467323 2467323 2022-05-03 Baker Florida 12003 8685 142
2464068 2464068 2022-05-02 Baker Florida 12003 8685 142
2460812 2460812 2022-05-01 Baker Florida 12003 8685 142
2457556 2457556 2022-04-30 Baker Florida 12003 8685 142
2454300 2454300 2022-04-29 Baker Florida 12003 8685 142
2451044 2451044 2022-04-28 Baker Florida 12003 8685 142
2447788 2447788 2022-04-27 Baker Florida 12003 8685 142
2444532 2444532 2022-04-26 Baker Florida 12003 8685 142
2441276 2441276 2022-04-25 Baker Florida 12003 8685 142
2438020 2438020 2022-04-24 Baker Florida 12003 8685 142
2434764 2434764 2022-04-23 Baker Florida 12003 8685 142
2431508 2431508 2022-04-22 Baker Florida 12003 8685 142
2428252 2428252 2022-04-21 Baker Florida 12003 8674 142
2424996 2424996 2022-04-20 Baker Florida 12003 8674 142
2421740 2421740 2022-04-19 Baker Florida 12003 8674 142
2418484 2418484 2022-04-18 Baker Florida 12003 8674 142
2415228 2415228 2022-04-17 Baker Florida 12003 8674 142
2411972 2411972 2022-04-16 Baker Florida 12003 8674 142
2408716 2408716 2022-04-15 Baker Florida 12003 8674 142
2405460 2405460 2022-04-14 Baker Florida 12003 8674 142
2402205 2402205 2022-04-13 Baker Florida 12003 8674 142
2398950 2398950 2022-04-12 Baker Florida 12003 8674 141
2395695 2395695 2022-04-11 Baker Florida 12003 8674 141
2392439 2392439 2022-04-10 Baker Florida 12003 8674 141
2389183 2389183 2022-04-09 Baker Florida 12003 8674 141
2385928 2385928 2022-04-08 Baker Florida 12003 8674 141
2382673 2382673 2022-04-07 Baker Florida 12003 8669 141
2379418 2379418 2022-04-06 Baker Florida 12003 8669 141
2376164 2376164 2022-04-05 Baker Florida 12003 8669 140
2372912 2372912 2022-04-04 Baker Florida 12003 8669 140
2369659 2369659 2022-04-03 Baker Florida 12003 8669 140
2366406 2366406 2022-04-02 Baker Florida 12003 8669 140
2363153 2363153 2022-04-01 Baker Florida 12003 8669 140
2359899 2359899 2022-03-31 Baker Florida 12003 8669 140
2356645 2356645 2022-03-30 Baker Florida 12003 8669 140
2353392 2353392 2022-03-29 Baker Florida 12003 8669 139
2350140 2350140 2022-03-28 Baker Florida 12003 8669 139
2346887 2346887 2022-03-27 Baker Florida 12003 8669 139
2343634 2343634 2022-03-26 Baker Florida 12003 8669 139
2340381 2340381 2022-03-25 Baker Florida 12003 8669 139
2337128 2337128 2022-03-24 Baker Florida 12003 8635 139
2333874 2333874 2022-03-23 Baker Florida 12003 8635 138
2330620 2330620 2022-03-22 Baker Florida 12003 8635 138
2327368 2327368 2022-03-21 Baker Florida 12003 8635 138
2324115 2324115 2022-03-20 Baker Florida 12003 8635 138
2320861 2320861 2022-03-19 Baker Florida 12003 8635 138
2317607 2317607 2022-03-18 Baker Florida 12003 8635 138
2314354 2314354 2022-03-17 Baker Florida 12003 8635 138
2311101 2311101 2022-03-16 Baker Florida 12003 8635 138
2307848 2307848 2022-03-15 Baker Florida 12003 8635 138
2304597 2304597 2022-03-14 Baker Florida 12003 8635 138
2301345 2301345 2022-03-13 Baker Florida 12003 8635 138
2298093 2298093 2022-03-12 Baker Florida 12003 8635 138
2294841 2294841 2022-03-11 Baker Florida 12003 8635 138
2291589 2291589 2022-03-10 Baker Florida 12003 8628 138
2288337 2288337 2022-03-09 Baker Florida 12003 8628 138
2285086 2285086 2022-03-08 Baker Florida 12003 8628 135
2281834 2281834 2022-03-07 Baker Florida 12003 8628 135
2278581 2278581 2022-03-06 Baker Florida 12003 8628 135
2275328 2275328 2022-03-05 Baker Florida 12003 8628 135
2272075 2272075 2022-03-04 Baker Florida 12003 8628 135
2268823 2268823 2022-03-03 Baker Florida 12003 8617 135
2265570 2265570 2022-03-02 Baker Florida 12003 8617 135
2262319 2262319 2022-03-01 Baker Florida 12003 8617 132
2259068 2259068 2022-02-28 Baker Florida 12003 8617 132
2255817 2255817 2022-02-27 Baker Florida 12003 8617 132
2252566 2252566 2022-02-26 Baker Florida 12003 8617 132
2249315 2249315 2022-02-25 Baker Florida 12003 8617 132
2246064 2246064 2022-02-24 Baker Florida 12003 8588 132
2242813 2242813 2022-02-23 Baker Florida 12003 8588 132
2239562 2239562 2022-02-22 Baker Florida 12003 8588 130
2236311 2236311 2022-02-21 Baker Florida 12003 8588 130
2233060 2233060 2022-02-20 Baker Florida 12003 8588 130
2229809 2229809 2022-02-19 Baker Florida 12003 8588 130
2226558 2226558 2022-02-18 Baker Florida 12003 8588 130
2223307 2223307 2022-02-17 Baker Florida 12003 8506 130
2220056 2220056 2022-02-16 Baker Florida 12003 8506 130
2216805 2216805 2022-02-15 Baker Florida 12003 8506 129
2213554 2213554 2022-02-14 Baker Florida 12003 8506 129
2210302 2210302 2022-02-13 Baker Florida 12003 8506 129
2207049 2207049 2022-02-12 Baker Florida 12003 8506 129
2203796 2203796 2022-02-11 Baker Florida 12003 8506 129
2200543 2200543 2022-02-10 Baker Florida 12003 8272 129
2197289 2197289 2022-02-09 Baker Florida 12003 8272 129
2194035 2194035 2022-02-08 Baker Florida 12003 8272 127
2190781 2190781 2022-02-07 Baker Florida 12003 8272 127
2187528 2187528 2022-02-06 Baker Florida 12003 8272 127
2184275 2184275 2022-02-05 Baker Florida 12003 8272 127
2181023 2181023 2022-02-04 Baker Florida 12003 8272 127
2177772 2177772 2022-02-03 Baker Florida 12003 7942 127

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);