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

785 rows where fips = 38069 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

  • 38069 · 785 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501620 2501620 2022-05-13 Pierce North Dakota 38069 1065 32
2498362 2498362 2022-05-12 Pierce North Dakota 38069 1062 32
2495104 2495104 2022-05-11 Pierce North Dakota 38069 1062 32
2491846 2491846 2022-05-10 Pierce North Dakota 38069 1062 32
2488588 2488588 2022-05-09 Pierce North Dakota 38069 1062 32
2485331 2485331 2022-05-08 Pierce North Dakota 38069 1062 32
2482073 2482073 2022-05-07 Pierce North Dakota 38069 1062 32
2478815 2478815 2022-05-06 Pierce North Dakota 38069 1062 32
2475557 2475557 2022-05-05 Pierce North Dakota 38069 1062 32
2472300 2472300 2022-05-04 Pierce North Dakota 38069 1062 32
2469044 2469044 2022-05-03 Pierce North Dakota 38069 1062 32
2465788 2465788 2022-05-02 Pierce North Dakota 38069 1062 32
2462533 2462533 2022-05-01 Pierce North Dakota 38069 1062 32
2459277 2459277 2022-04-30 Pierce North Dakota 38069 1062 32
2456021 2456021 2022-04-29 Pierce North Dakota 38069 1062 32
2452765 2452765 2022-04-28 Pierce North Dakota 38069 1060 32
2449509 2449509 2022-04-27 Pierce North Dakota 38069 1060 32
2446252 2446252 2022-04-26 Pierce North Dakota 38069 1060 32
2442997 2442997 2022-04-25 Pierce North Dakota 38069 1060 32
2439741 2439741 2022-04-24 Pierce North Dakota 38069 1060 32
2436485 2436485 2022-04-23 Pierce North Dakota 38069 1060 32
2433229 2433229 2022-04-22 Pierce North Dakota 38069 1060 32
2429973 2429973 2022-04-21 Pierce North Dakota 38069 1059 32
2426717 2426717 2022-04-20 Pierce North Dakota 38069 1059 32
2423461 2423461 2022-04-19 Pierce North Dakota 38069 1059 32
2420204 2420204 2022-04-18 Pierce North Dakota 38069 1059 32
2416949 2416949 2022-04-17 Pierce North Dakota 38069 1059 32
2413693 2413693 2022-04-16 Pierce North Dakota 38069 1059 32
2410437 2410437 2022-04-15 Pierce North Dakota 38069 1059 32
2407181 2407181 2022-04-14 Pierce North Dakota 38069 1059 32
2403925 2403925 2022-04-13 Pierce North Dakota 38069 1059 32
2400670 2400670 2022-04-12 Pierce North Dakota 38069 1059 32
2397415 2397415 2022-04-11 Pierce North Dakota 38069 1059 32
2394160 2394160 2022-04-10 Pierce North Dakota 38069 1059 32
2390904 2390904 2022-04-09 Pierce North Dakota 38069 1059 32
2387648 2387648 2022-04-08 Pierce North Dakota 38069 1059 32
2384393 2384393 2022-04-07 Pierce North Dakota 38069 1058 32
2381138 2381138 2022-04-06 Pierce North Dakota 38069 1058 32
2377883 2377883 2022-04-05 Pierce North Dakota 38069 1058 32
2374630 2374630 2022-04-04 Pierce North Dakota 38069 1058 32
2371378 2371378 2022-04-03 Pierce North Dakota 38069 1058 32
2368125 2368125 2022-04-02 Pierce North Dakota 38069 1058 32
2364872 2364872 2022-04-01 Pierce North Dakota 38069 1058 32
2361618 2361618 2022-03-31 Pierce North Dakota 38069 1059 32
2358364 2358364 2022-03-30 Pierce North Dakota 38069 1059 32
2355110 2355110 2022-03-29 Pierce North Dakota 38069 1059 32
2351857 2351857 2022-03-28 Pierce North Dakota 38069 1059 32
2348605 2348605 2022-03-27 Pierce North Dakota 38069 1059 32
2345352 2345352 2022-03-26 Pierce North Dakota 38069 1059 32
2342099 2342099 2022-03-25 Pierce North Dakota 38069 1059 32
2338846 2338846 2022-03-24 Pierce North Dakota 38069 1059 32
2335592 2335592 2022-03-23 Pierce North Dakota 38069 1059 32
2332338 2332338 2022-03-22 Pierce North Dakota 38069 1059 32
2329085 2329085 2022-03-21 Pierce North Dakota 38069 1059 32
2325833 2325833 2022-03-20 Pierce North Dakota 38069 1059 32
2322580 2322580 2022-03-19 Pierce North Dakota 38069 1059 32
2319326 2319326 2022-03-18 Pierce North Dakota 38069 1059 32
2316072 2316072 2022-03-17 Pierce North Dakota 38069 1059 32
2312819 2312819 2022-03-16 Pierce North Dakota 38069 1059 32
2309566 2309566 2022-03-15 Pierce North Dakota 38069 1059 32
2306313 2306313 2022-03-14 Pierce North Dakota 38069 1059 32
2303062 2303062 2022-03-13 Pierce North Dakota 38069 1059 32
2299810 2299810 2022-03-12 Pierce North Dakota 38069 1059 32
2296558 2296558 2022-03-11 Pierce North Dakota 38069 1059 32
2293306 2293306 2022-03-10 Pierce North Dakota 38069 1059 32
2290054 2290054 2022-03-09 Pierce North Dakota 38069 1058 32
2286802 2286802 2022-03-08 Pierce North Dakota 38069 1057 32
2283550 2283550 2022-03-07 Pierce North Dakota 38069 1057 32
2280298 2280298 2022-03-06 Pierce North Dakota 38069 1057 32
2277045 2277045 2022-03-05 Pierce North Dakota 38069 1057 32
2273792 2273792 2022-03-04 Pierce North Dakota 38069 1057 32
2270539 2270539 2022-03-03 Pierce North Dakota 38069 1056 32
2267287 2267287 2022-03-02 Pierce North Dakota 38069 1056 32
2264035 2264035 2022-03-01 Pierce North Dakota 38069 1056 32
2260784 2260784 2022-02-28 Pierce North Dakota 38069 1055 32
2257533 2257533 2022-02-27 Pierce North Dakota 38069 1055 32
2254282 2254282 2022-02-26 Pierce North Dakota 38069 1055 32
2251031 2251031 2022-02-25 Pierce North Dakota 38069 1055 32
2247780 2247780 2022-02-24 Pierce North Dakota 38069 1055 32
2244529 2244529 2022-02-23 Pierce North Dakota 38069 1052 31
2241278 2241278 2022-02-22 Pierce North Dakota 38069 1052 31
2238027 2238027 2022-02-21 Pierce North Dakota 38069 1052 31
2234776 2234776 2022-02-20 Pierce North Dakota 38069 1052 31
2231525 2231525 2022-02-19 Pierce North Dakota 38069 1052 31
2228274 2228274 2022-02-18 Pierce North Dakota 38069 1045 31
2225023 2225023 2022-02-17 Pierce North Dakota 38069 1045 31
2221772 2221772 2022-02-16 Pierce North Dakota 38069 1045 31
2218521 2218521 2022-02-15 Pierce North Dakota 38069 1044 31
2215270 2215270 2022-02-14 Pierce North Dakota 38069 1036 31
2212019 2212019 2022-02-13 Pierce North Dakota 38069 1036 31
2208766 2208766 2022-02-12 Pierce North Dakota 38069 1034 31
2205513 2205513 2022-02-11 Pierce North Dakota 38069 1033 31
2202260 2202260 2022-02-10 Pierce North Dakota 38069 1032 31
2199006 2199006 2022-02-09 Pierce North Dakota 38069 1033 31
2195752 2195752 2022-02-08 Pierce North Dakota 38069 1032 31
2192498 2192498 2022-02-07 Pierce North Dakota 38069 1030 31
2189244 2189244 2022-02-06 Pierce North Dakota 38069 1028 31
2185991 2185991 2022-02-05 Pierce North Dakota 38069 1028 31
2182739 2182739 2022-02-04 Pierce North Dakota 38069 1028 31
2179487 2179487 2022-02-03 Pierce North Dakota 38069 1024 31

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