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

2,309 rows where county = "Baker" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 3

fips 3

county 1

  • Baker · 2,309 ✖
Link rowid date ▲ county state fips cases deaths
2499899 2499899 2022-05-13 Baker Florida 12003 8712 142
2499969 2499969 2022-05-13 Baker Georgia 13007 536 15
2501811 2501811 2022-05-13 Baker Oregon 41001 3231 48
2496641 2496641 2022-05-12 Baker Florida 12003 8712 142
2496711 2496711 2022-05-12 Baker Georgia 13007 536 15
2498553 2498553 2022-05-12 Baker Oregon 41001 3230 48
2493383 2493383 2022-05-11 Baker Florida 12003 8712 142
2493453 2493453 2022-05-11 Baker Georgia 13007 536 15
2495295 2495295 2022-05-11 Baker Oregon 41001 3226 48
2490125 2490125 2022-05-10 Baker Florida 12003 8712 142
2490195 2490195 2022-05-10 Baker Georgia 13007 536 15
2492037 2492037 2022-05-10 Baker Oregon 41001 3226 48
2486868 2486868 2022-05-09 Baker Florida 12003 8712 142
2486938 2486938 2022-05-09 Baker Georgia 13007 536 15
2488779 2488779 2022-05-09 Baker Oregon 41001 3226 48
2483610 2483610 2022-05-08 Baker Florida 12003 8712 142
2483680 2483680 2022-05-08 Baker Georgia 13007 536 15
2485522 2485522 2022-05-08 Baker Oregon 41001 3226 48
2480352 2480352 2022-05-07 Baker Florida 12003 8712 142
2480422 2480422 2022-05-07 Baker Georgia 13007 536 15
2482264 2482264 2022-05-07 Baker Oregon 41001 3226 48
2477094 2477094 2022-05-06 Baker Florida 12003 8712 142
2477164 2477164 2022-05-06 Baker Georgia 13007 536 15
2479006 2479006 2022-05-06 Baker Oregon 41001 3226 48
2473836 2473836 2022-05-05 Baker Florida 12003 8685 142
2473906 2473906 2022-05-05 Baker Georgia 13007 536 15
2475748 2475748 2022-05-05 Baker Oregon 41001 3220 48
2470579 2470579 2022-05-04 Baker Florida 12003 8685 142
2470649 2470649 2022-05-04 Baker Georgia 13007 536 15
2472491 2472491 2022-05-04 Baker Oregon 41001 3219 48
2467323 2467323 2022-05-03 Baker Florida 12003 8685 142
2467393 2467393 2022-05-03 Baker Georgia 13007 536 15
2469235 2469235 2022-05-03 Baker Oregon 41001 3217 48
2464068 2464068 2022-05-02 Baker Florida 12003 8685 142
2464138 2464138 2022-05-02 Baker Georgia 13007 536 15
2465979 2465979 2022-05-02 Baker Oregon 41001 3217 48
2460812 2460812 2022-05-01 Baker Florida 12003 8685 142
2460882 2460882 2022-05-01 Baker Georgia 13007 536 15
2462724 2462724 2022-05-01 Baker Oregon 41001 3215 48
2457556 2457556 2022-04-30 Baker Florida 12003 8685 142
2457626 2457626 2022-04-30 Baker Georgia 13007 536 15
2459468 2459468 2022-04-30 Baker Oregon 41001 3215 48
2454300 2454300 2022-04-29 Baker Florida 12003 8685 142
2454370 2454370 2022-04-29 Baker Georgia 13007 536 15
2456212 2456212 2022-04-29 Baker Oregon 41001 3215 48
2451044 2451044 2022-04-28 Baker Florida 12003 8685 142
2451114 2451114 2022-04-28 Baker Georgia 13007 536 15
2452956 2452956 2022-04-28 Baker Oregon 41001 3214 48
2447788 2447788 2022-04-27 Baker Florida 12003 8685 142
2447858 2447858 2022-04-27 Baker Georgia 13007 536 15
2449700 2449700 2022-04-27 Baker Oregon 41001 3214 48
2444532 2444532 2022-04-26 Baker Florida 12003 8685 142
2444602 2444602 2022-04-26 Baker Georgia 13007 536 15
2446443 2446443 2022-04-26 Baker Oregon 41001 3214 48
2441276 2441276 2022-04-25 Baker Florida 12003 8685 142
2441346 2441346 2022-04-25 Baker Georgia 13007 536 15
2443188 2443188 2022-04-25 Baker Oregon 41001 3214 48
2438020 2438020 2022-04-24 Baker Florida 12003 8685 142
2438090 2438090 2022-04-24 Baker Georgia 13007 536 15
2439932 2439932 2022-04-24 Baker Oregon 41001 3214 48
2434764 2434764 2022-04-23 Baker Florida 12003 8685 142
2434834 2434834 2022-04-23 Baker Georgia 13007 536 15
2436676 2436676 2022-04-23 Baker Oregon 41001 3214 48
2431508 2431508 2022-04-22 Baker Florida 12003 8685 142
2431578 2431578 2022-04-22 Baker Georgia 13007 536 15
2433420 2433420 2022-04-22 Baker Oregon 41001 3214 48
2428252 2428252 2022-04-21 Baker Florida 12003 8674 142
2428322 2428322 2022-04-21 Baker Georgia 13007 536 15
2430164 2430164 2022-04-21 Baker Oregon 41001 3214 48
2424996 2424996 2022-04-20 Baker Florida 12003 8674 142
2425066 2425066 2022-04-20 Baker Georgia 13007 536 15
2426908 2426908 2022-04-20 Baker Oregon 41001 3212 48
2421740 2421740 2022-04-19 Baker Florida 12003 8674 142
2421810 2421810 2022-04-19 Baker Georgia 13007 536 15
2423652 2423652 2022-04-19 Baker Oregon 41001 3210 48
2418484 2418484 2022-04-18 Baker Florida 12003 8674 142
2418554 2418554 2022-04-18 Baker Georgia 13007 536 15
2420395 2420395 2022-04-18 Baker Oregon 41001 3210 48
2415228 2415228 2022-04-17 Baker Florida 12003 8674 142
2415298 2415298 2022-04-17 Baker Georgia 13007 536 15
2417140 2417140 2022-04-17 Baker Oregon 41001 3210 48
2411972 2411972 2022-04-16 Baker Florida 12003 8674 142
2412042 2412042 2022-04-16 Baker Georgia 13007 536 15
2413884 2413884 2022-04-16 Baker Oregon 41001 3210 48
2408716 2408716 2022-04-15 Baker Florida 12003 8674 142
2408786 2408786 2022-04-15 Baker Georgia 13007 536 15
2410628 2410628 2022-04-15 Baker Oregon 41001 3210 48
2405460 2405460 2022-04-14 Baker Florida 12003 8674 142
2405530 2405530 2022-04-14 Baker Georgia 13007 535 14
2407372 2407372 2022-04-14 Baker Oregon 41001 3210 48
2402205 2402205 2022-04-13 Baker Florida 12003 8674 142
2402275 2402275 2022-04-13 Baker Georgia 13007 535 14
2404116 2404116 2022-04-13 Baker Oregon 41001 3210 48
2398950 2398950 2022-04-12 Baker Florida 12003 8674 141
2399020 2399020 2022-04-12 Baker Georgia 13007 535 14
2400861 2400861 2022-04-12 Baker Oregon 41001 3210 48
2395695 2395695 2022-04-11 Baker Florida 12003 8674 141
2395765 2395765 2022-04-11 Baker Georgia 13007 535 14
2397606 2397606 2022-04-11 Baker Oregon 41001 3210 48
2392439 2392439 2022-04-10 Baker Florida 12003 8674 141

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