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

773 rows where fips = 38013 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 38013 · 773 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501592 2501592 2022-05-13 Burke North Dakota 38013 433 3
2498334 2498334 2022-05-12 Burke North Dakota 38013 433 3
2495076 2495076 2022-05-11 Burke North Dakota 38013 433 3
2491818 2491818 2022-05-10 Burke North Dakota 38013 433 3
2488560 2488560 2022-05-09 Burke North Dakota 38013 433 3
2485303 2485303 2022-05-08 Burke North Dakota 38013 433 3
2482045 2482045 2022-05-07 Burke North Dakota 38013 433 3
2478787 2478787 2022-05-06 Burke North Dakota 38013 433 3
2475529 2475529 2022-05-05 Burke North Dakota 38013 432 3
2472272 2472272 2022-05-04 Burke North Dakota 38013 432 3
2469016 2469016 2022-05-03 Burke North Dakota 38013 432 3
2465760 2465760 2022-05-02 Burke North Dakota 38013 432 3
2462505 2462505 2022-05-01 Burke North Dakota 38013 432 3
2459249 2459249 2022-04-30 Burke North Dakota 38013 432 3
2455993 2455993 2022-04-29 Burke North Dakota 38013 432 3
2452737 2452737 2022-04-28 Burke North Dakota 38013 432 3
2449481 2449481 2022-04-27 Burke North Dakota 38013 432 3
2446224 2446224 2022-04-26 Burke North Dakota 38013 432 3
2442969 2442969 2022-04-25 Burke North Dakota 38013 432 3
2439713 2439713 2022-04-24 Burke North Dakota 38013 432 3
2436457 2436457 2022-04-23 Burke North Dakota 38013 432 3
2433201 2433201 2022-04-22 Burke North Dakota 38013 432 3
2429945 2429945 2022-04-21 Burke North Dakota 38013 432 3
2426689 2426689 2022-04-20 Burke North Dakota 38013 432 3
2423433 2423433 2022-04-19 Burke North Dakota 38013 432 3
2420176 2420176 2022-04-18 Burke North Dakota 38013 432 3
2416921 2416921 2022-04-17 Burke North Dakota 38013 432 3
2413665 2413665 2022-04-16 Burke North Dakota 38013 432 3
2410409 2410409 2022-04-15 Burke North Dakota 38013 432 3
2407153 2407153 2022-04-14 Burke North Dakota 38013 432 3
2403897 2403897 2022-04-13 Burke North Dakota 38013 432 3
2400642 2400642 2022-04-12 Burke North Dakota 38013 432 3
2397387 2397387 2022-04-11 Burke North Dakota 38013 432 3
2394132 2394132 2022-04-10 Burke North Dakota 38013 432 3
2390876 2390876 2022-04-09 Burke North Dakota 38013 432 3
2387620 2387620 2022-04-08 Burke North Dakota 38013 432 3
2384365 2384365 2022-04-07 Burke North Dakota 38013 432 3
2381110 2381110 2022-04-06 Burke North Dakota 38013 432 3
2377855 2377855 2022-04-05 Burke North Dakota 38013 432 3
2374602 2374602 2022-04-04 Burke North Dakota 38013 432 3
2371350 2371350 2022-04-03 Burke North Dakota 38013 432 3
2368097 2368097 2022-04-02 Burke North Dakota 38013 432 3
2364844 2364844 2022-04-01 Burke North Dakota 38013 432 3
2361590 2361590 2022-03-31 Burke North Dakota 38013 432 3
2358336 2358336 2022-03-30 Burke North Dakota 38013 432 3
2355082 2355082 2022-03-29 Burke North Dakota 38013 432 3
2351829 2351829 2022-03-28 Burke North Dakota 38013 432 3
2348577 2348577 2022-03-27 Burke North Dakota 38013 432 3
2345324 2345324 2022-03-26 Burke North Dakota 38013 432 3
2342071 2342071 2022-03-25 Burke North Dakota 38013 432 3
2338818 2338818 2022-03-24 Burke North Dakota 38013 432 3
2335564 2335564 2022-03-23 Burke North Dakota 38013 432 3
2332310 2332310 2022-03-22 Burke North Dakota 38013 432 3
2329057 2329057 2022-03-21 Burke North Dakota 38013 432 3
2325805 2325805 2022-03-20 Burke North Dakota 38013 432 3
2322552 2322552 2022-03-19 Burke North Dakota 38013 432 3
2319298 2319298 2022-03-18 Burke North Dakota 38013 432 3
2316044 2316044 2022-03-17 Burke North Dakota 38013 432 3
2312791 2312791 2022-03-16 Burke North Dakota 38013 432 3
2309538 2309538 2022-03-15 Burke North Dakota 38013 432 3
2306285 2306285 2022-03-14 Burke North Dakota 38013 432 3
2303034 2303034 2022-03-13 Burke North Dakota 38013 432 3
2299782 2299782 2022-03-12 Burke North Dakota 38013 432 3
2296530 2296530 2022-03-11 Burke North Dakota 38013 432 3
2293278 2293278 2022-03-10 Burke North Dakota 38013 431 3
2290026 2290026 2022-03-09 Burke North Dakota 38013 430 3
2286774 2286774 2022-03-08 Burke North Dakota 38013 430 3
2283522 2283522 2022-03-07 Burke North Dakota 38013 430 3
2280270 2280270 2022-03-06 Burke North Dakota 38013 430 3
2277017 2277017 2022-03-05 Burke North Dakota 38013 430 3
2273764 2273764 2022-03-04 Burke North Dakota 38013 430 3
2270511 2270511 2022-03-03 Burke North Dakota 38013 430 3
2267259 2267259 2022-03-02 Burke North Dakota 38013 430 3
2264007 2264007 2022-03-01 Burke North Dakota 38013 430 3
2260756 2260756 2022-02-28 Burke North Dakota 38013 430 3
2257505 2257505 2022-02-27 Burke North Dakota 38013 430 3
2254254 2254254 2022-02-26 Burke North Dakota 38013 430 3
2251003 2251003 2022-02-25 Burke North Dakota 38013 429 3
2247752 2247752 2022-02-24 Burke North Dakota 38013 429 3
2244501 2244501 2022-02-23 Burke North Dakota 38013 429 3
2241250 2241250 2022-02-22 Burke North Dakota 38013 429 3
2237999 2237999 2022-02-21 Burke North Dakota 38013 429 3
2234748 2234748 2022-02-20 Burke North Dakota 38013 429 3
2231497 2231497 2022-02-19 Burke North Dakota 38013 428 3
2228246 2228246 2022-02-18 Burke North Dakota 38013 428 3
2224995 2224995 2022-02-17 Burke North Dakota 38013 428 3
2221744 2221744 2022-02-16 Burke North Dakota 38013 428 3
2218493 2218493 2022-02-15 Burke North Dakota 38013 428 3
2215242 2215242 2022-02-14 Burke North Dakota 38013 428 3
2211991 2211991 2022-02-13 Burke North Dakota 38013 428 3
2208738 2208738 2022-02-12 Burke North Dakota 38013 427 3
2205485 2205485 2022-02-11 Burke North Dakota 38013 427 3
2202232 2202232 2022-02-10 Burke North Dakota 38013 426 3
2198978 2198978 2022-02-09 Burke North Dakota 38013 426 3
2195724 2195724 2022-02-08 Burke North Dakota 38013 425 3
2192470 2192470 2022-02-07 Burke North Dakota 38013 424 3
2189216 2189216 2022-02-06 Burke North Dakota 38013 424 3
2185963 2185963 2022-02-05 Burke North Dakota 38013 424 3
2182711 2182711 2022-02-04 Burke North Dakota 38013 424 3
2179459 2179459 2022-02-03 Burke North Dakota 38013 421 3

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