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

780 rows where county = "Foster", fips = 38031 and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • North Dakota · 780 ✖

fips 1

  • 38031 · 780 ✖

county 1

  • Foster · 780 ✖
Link rowid date ▲ county state fips cases deaths
2501601 2501601 2022-05-13 Foster North Dakota 38031 992 23
2498343 2498343 2022-05-12 Foster North Dakota 38031 991 23
2495085 2495085 2022-05-11 Foster North Dakota 38031 991 23
2491827 2491827 2022-05-10 Foster North Dakota 38031 991 23
2488569 2488569 2022-05-09 Foster North Dakota 38031 991 23
2485312 2485312 2022-05-08 Foster North Dakota 38031 991 23
2482054 2482054 2022-05-07 Foster North Dakota 38031 991 23
2478796 2478796 2022-05-06 Foster North Dakota 38031 991 23
2475538 2475538 2022-05-05 Foster North Dakota 38031 989 23
2472281 2472281 2022-05-04 Foster North Dakota 38031 989 23
2469025 2469025 2022-05-03 Foster North Dakota 38031 989 23
2465769 2465769 2022-05-02 Foster North Dakota 38031 989 23
2462514 2462514 2022-05-01 Foster North Dakota 38031 989 23
2459258 2459258 2022-04-30 Foster North Dakota 38031 989 23
2456002 2456002 2022-04-29 Foster North Dakota 38031 989 23
2452746 2452746 2022-04-28 Foster North Dakota 38031 987 23
2449490 2449490 2022-04-27 Foster North Dakota 38031 987 23
2446233 2446233 2022-04-26 Foster North Dakota 38031 987 23
2442978 2442978 2022-04-25 Foster North Dakota 38031 987 23
2439722 2439722 2022-04-24 Foster North Dakota 38031 987 23
2436466 2436466 2022-04-23 Foster North Dakota 38031 987 23
2433210 2433210 2022-04-22 Foster North Dakota 38031 987 23
2429954 2429954 2022-04-21 Foster North Dakota 38031 986 23
2426698 2426698 2022-04-20 Foster North Dakota 38031 986 23
2423442 2423442 2022-04-19 Foster North Dakota 38031 986 23
2420185 2420185 2022-04-18 Foster North Dakota 38031 986 23
2416930 2416930 2022-04-17 Foster North Dakota 38031 986 23
2413674 2413674 2022-04-16 Foster North Dakota 38031 986 23
2410418 2410418 2022-04-15 Foster North Dakota 38031 986 23
2407162 2407162 2022-04-14 Foster North Dakota 38031 986 23
2403906 2403906 2022-04-13 Foster North Dakota 38031 986 23
2400651 2400651 2022-04-12 Foster North Dakota 38031 986 23
2397396 2397396 2022-04-11 Foster North Dakota 38031 986 23
2394141 2394141 2022-04-10 Foster North Dakota 38031 986 23
2390885 2390885 2022-04-09 Foster North Dakota 38031 986 23
2387629 2387629 2022-04-08 Foster North Dakota 38031 986 23
2384374 2384374 2022-04-07 Foster North Dakota 38031 986 23
2381119 2381119 2022-04-06 Foster North Dakota 38031 986 23
2377864 2377864 2022-04-05 Foster North Dakota 38031 986 23
2374611 2374611 2022-04-04 Foster North Dakota 38031 986 23
2371359 2371359 2022-04-03 Foster North Dakota 38031 986 23
2368106 2368106 2022-04-02 Foster North Dakota 38031 986 23
2364853 2364853 2022-04-01 Foster North Dakota 38031 986 23
2361599 2361599 2022-03-31 Foster North Dakota 38031 986 23
2358345 2358345 2022-03-30 Foster North Dakota 38031 986 23
2355091 2355091 2022-03-29 Foster North Dakota 38031 986 23
2351838 2351838 2022-03-28 Foster North Dakota 38031 986 23
2348586 2348586 2022-03-27 Foster North Dakota 38031 986 23
2345333 2345333 2022-03-26 Foster North Dakota 38031 986 23
2342080 2342080 2022-03-25 Foster North Dakota 38031 986 23
2338827 2338827 2022-03-24 Foster North Dakota 38031 986 23
2335573 2335573 2022-03-23 Foster North Dakota 38031 986 23
2332319 2332319 2022-03-22 Foster North Dakota 38031 986 23
2329066 2329066 2022-03-21 Foster North Dakota 38031 986 23
2325814 2325814 2022-03-20 Foster North Dakota 38031 986 23
2322561 2322561 2022-03-19 Foster North Dakota 38031 986 23
2319307 2319307 2022-03-18 Foster North Dakota 38031 986 23
2316053 2316053 2022-03-17 Foster North Dakota 38031 984 23
2312800 2312800 2022-03-16 Foster North Dakota 38031 984 23
2309547 2309547 2022-03-15 Foster North Dakota 38031 984 23
2306294 2306294 2022-03-14 Foster North Dakota 38031 983 23
2303043 2303043 2022-03-13 Foster North Dakota 38031 983 23
2299791 2299791 2022-03-12 Foster North Dakota 38031 983 23
2296539 2296539 2022-03-11 Foster North Dakota 38031 982 23
2293287 2293287 2022-03-10 Foster North Dakota 38031 982 23
2290035 2290035 2022-03-09 Foster North Dakota 38031 982 23
2286783 2286783 2022-03-08 Foster North Dakota 38031 979 23
2283531 2283531 2022-03-07 Foster North Dakota 38031 979 23
2280279 2280279 2022-03-06 Foster North Dakota 38031 978 23
2277026 2277026 2022-03-05 Foster North Dakota 38031 977 23
2273773 2273773 2022-03-04 Foster North Dakota 38031 977 22
2270520 2270520 2022-03-03 Foster North Dakota 38031 977 22
2267268 2267268 2022-03-02 Foster North Dakota 38031 976 22
2264016 2264016 2022-03-01 Foster North Dakota 38031 976 22
2260765 2260765 2022-02-28 Foster North Dakota 38031 978 22
2257514 2257514 2022-02-27 Foster North Dakota 38031 978 22
2254263 2254263 2022-02-26 Foster North Dakota 38031 978 22
2251012 2251012 2022-02-25 Foster North Dakota 38031 978 22
2247761 2247761 2022-02-24 Foster North Dakota 38031 978 22
2244510 2244510 2022-02-23 Foster North Dakota 38031 976 22
2241259 2241259 2022-02-22 Foster North Dakota 38031 973 21
2238008 2238008 2022-02-21 Foster North Dakota 38031 973 21
2234757 2234757 2022-02-20 Foster North Dakota 38031 973 21
2231506 2231506 2022-02-19 Foster North Dakota 38031 973 21
2228255 2228255 2022-02-18 Foster North Dakota 38031 969 21
2225004 2225004 2022-02-17 Foster North Dakota 38031 969 21
2221753 2221753 2022-02-16 Foster North Dakota 38031 965 21
2218502 2218502 2022-02-15 Foster North Dakota 38031 965 21
2215251 2215251 2022-02-14 Foster North Dakota 38031 966 21
2212000 2212000 2022-02-13 Foster North Dakota 38031 966 21
2208747 2208747 2022-02-12 Foster North Dakota 38031 966 21
2205494 2205494 2022-02-11 Foster North Dakota 38031 962 21
2202241 2202241 2022-02-10 Foster North Dakota 38031 959 20
2198987 2198987 2022-02-09 Foster North Dakota 38031 951 20
2195733 2195733 2022-02-08 Foster North Dakota 38031 948 20
2192479 2192479 2022-02-07 Foster North Dakota 38031 943 20
2189225 2189225 2022-02-06 Foster North Dakota 38031 939 20
2185972 2185972 2022-02-05 Foster North Dakota 38031 939 20
2182720 2182720 2022-02-04 Foster North Dakota 38031 937 20
2179468 2179468 2022-02-03 Foster North Dakota 38031 934 20

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