ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where deaths = 18 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501600 | 2501600 | 2022-05-13 | Emmons | North Dakota | 38029 | 728 | 18 |
2501617 | 2501617 | 2022-05-13 | Nelson | North Dakota | 38063 | 768 | 18 |
2498342 | 2498342 | 2022-05-12 | Emmons | North Dakota | 38029 | 728 | 18 |
2498359 | 2498359 | 2022-05-12 | Nelson | North Dakota | 38063 | 765 | 18 |
2495084 | 2495084 | 2022-05-11 | Emmons | North Dakota | 38029 | 728 | 18 |
2495101 | 2495101 | 2022-05-11 | Nelson | North Dakota | 38063 | 765 | 18 |
2491826 | 2491826 | 2022-05-10 | Emmons | North Dakota | 38029 | 728 | 18 |
2491843 | 2491843 | 2022-05-10 | Nelson | North Dakota | 38063 | 765 | 18 |
2488568 | 2488568 | 2022-05-09 | Emmons | North Dakota | 38029 | 728 | 18 |
2488585 | 2488585 | 2022-05-09 | Nelson | North Dakota | 38063 | 765 | 18 |
2485311 | 2485311 | 2022-05-08 | Emmons | North Dakota | 38029 | 728 | 18 |
2485328 | 2485328 | 2022-05-08 | Nelson | North Dakota | 38063 | 765 | 18 |
2482053 | 2482053 | 2022-05-07 | Emmons | North Dakota | 38029 | 728 | 18 |
2482070 | 2482070 | 2022-05-07 | Nelson | North Dakota | 38063 | 765 | 18 |
2478795 | 2478795 | 2022-05-06 | Emmons | North Dakota | 38029 | 728 | 18 |
2478812 | 2478812 | 2022-05-06 | Nelson | North Dakota | 38063 | 765 | 18 |
2475537 | 2475537 | 2022-05-05 | Emmons | North Dakota | 38029 | 728 | 18 |
2475554 | 2475554 | 2022-05-05 | Nelson | North Dakota | 38063 | 763 | 18 |
2472280 | 2472280 | 2022-05-04 | Emmons | North Dakota | 38029 | 728 | 18 |
2472297 | 2472297 | 2022-05-04 | Nelson | North Dakota | 38063 | 763 | 18 |
2469024 | 2469024 | 2022-05-03 | Emmons | North Dakota | 38029 | 728 | 18 |
2469041 | 2469041 | 2022-05-03 | Nelson | North Dakota | 38063 | 763 | 18 |
2465768 | 2465768 | 2022-05-02 | Emmons | North Dakota | 38029 | 728 | 18 |
2465785 | 2465785 | 2022-05-02 | Nelson | North Dakota | 38063 | 763 | 18 |
2462513 | 2462513 | 2022-05-01 | Emmons | North Dakota | 38029 | 728 | 18 |
2462530 | 2462530 | 2022-05-01 | Nelson | North Dakota | 38063 | 763 | 18 |
2459257 | 2459257 | 2022-04-30 | Emmons | North Dakota | 38029 | 728 | 18 |
2459274 | 2459274 | 2022-04-30 | Nelson | North Dakota | 38063 | 763 | 18 |
2456001 | 2456001 | 2022-04-29 | Emmons | North Dakota | 38029 | 728 | 18 |
2456018 | 2456018 | 2022-04-29 | Nelson | North Dakota | 38063 | 763 | 18 |
2452745 | 2452745 | 2022-04-28 | Emmons | North Dakota | 38029 | 727 | 18 |
2452762 | 2452762 | 2022-04-28 | Nelson | North Dakota | 38063 | 762 | 18 |
2449489 | 2449489 | 2022-04-27 | Emmons | North Dakota | 38029 | 727 | 18 |
2449506 | 2449506 | 2022-04-27 | Nelson | North Dakota | 38063 | 762 | 18 |
2446232 | 2446232 | 2022-04-26 | Emmons | North Dakota | 38029 | 727 | 18 |
2446249 | 2446249 | 2022-04-26 | Nelson | North Dakota | 38063 | 762 | 18 |
2442977 | 2442977 | 2022-04-25 | Emmons | North Dakota | 38029 | 727 | 18 |
2442994 | 2442994 | 2022-04-25 | Nelson | North Dakota | 38063 | 762 | 18 |
2439721 | 2439721 | 2022-04-24 | Emmons | North Dakota | 38029 | 727 | 18 |
2439738 | 2439738 | 2022-04-24 | Nelson | North Dakota | 38063 | 762 | 18 |
2436465 | 2436465 | 2022-04-23 | Emmons | North Dakota | 38029 | 727 | 18 |
2436482 | 2436482 | 2022-04-23 | Nelson | North Dakota | 38063 | 762 | 18 |
2433209 | 2433209 | 2022-04-22 | Emmons | North Dakota | 38029 | 727 | 18 |
2433226 | 2433226 | 2022-04-22 | Nelson | North Dakota | 38063 | 762 | 18 |
2429953 | 2429953 | 2022-04-21 | Emmons | North Dakota | 38029 | 727 | 18 |
2429970 | 2429970 | 2022-04-21 | Nelson | North Dakota | 38063 | 761 | 18 |
2426697 | 2426697 | 2022-04-20 | Emmons | North Dakota | 38029 | 727 | 18 |
2426714 | 2426714 | 2022-04-20 | Nelson | North Dakota | 38063 | 761 | 18 |
2423441 | 2423441 | 2022-04-19 | Emmons | North Dakota | 38029 | 727 | 18 |
2423458 | 2423458 | 2022-04-19 | Nelson | North Dakota | 38063 | 761 | 18 |
2420184 | 2420184 | 2022-04-18 | Emmons | North Dakota | 38029 | 727 | 18 |
2420201 | 2420201 | 2022-04-18 | Nelson | North Dakota | 38063 | 761 | 18 |
2416929 | 2416929 | 2022-04-17 | Emmons | North Dakota | 38029 | 727 | 18 |
2416946 | 2416946 | 2022-04-17 | Nelson | North Dakota | 38063 | 761 | 18 |
2413673 | 2413673 | 2022-04-16 | Emmons | North Dakota | 38029 | 727 | 18 |
2413690 | 2413690 | 2022-04-16 | Nelson | North Dakota | 38063 | 761 | 18 |
2410417 | 2410417 | 2022-04-15 | Emmons | North Dakota | 38029 | 727 | 18 |
2410434 | 2410434 | 2022-04-15 | Nelson | North Dakota | 38063 | 761 | 18 |
2407161 | 2407161 | 2022-04-14 | Emmons | North Dakota | 38029 | 727 | 18 |
2407178 | 2407178 | 2022-04-14 | Nelson | North Dakota | 38063 | 761 | 18 |
2403905 | 2403905 | 2022-04-13 | Emmons | North Dakota | 38029 | 727 | 18 |
2403922 | 2403922 | 2022-04-13 | Nelson | North Dakota | 38063 | 761 | 18 |
2400650 | 2400650 | 2022-04-12 | Emmons | North Dakota | 38029 | 727 | 18 |
2400667 | 2400667 | 2022-04-12 | Nelson | North Dakota | 38063 | 761 | 18 |
2397395 | 2397395 | 2022-04-11 | Emmons | North Dakota | 38029 | 727 | 18 |
2397412 | 2397412 | 2022-04-11 | Nelson | North Dakota | 38063 | 761 | 18 |
2394140 | 2394140 | 2022-04-10 | Emmons | North Dakota | 38029 | 727 | 18 |
2394157 | 2394157 | 2022-04-10 | Nelson | North Dakota | 38063 | 761 | 18 |
2390884 | 2390884 | 2022-04-09 | Emmons | North Dakota | 38029 | 727 | 18 |
2390901 | 2390901 | 2022-04-09 | Nelson | North Dakota | 38063 | 761 | 18 |
2387628 | 2387628 | 2022-04-08 | Emmons | North Dakota | 38029 | 727 | 18 |
2387645 | 2387645 | 2022-04-08 | Nelson | North Dakota | 38063 | 761 | 18 |
2384373 | 2384373 | 2022-04-07 | Emmons | North Dakota | 38029 | 726 | 18 |
2384390 | 2384390 | 2022-04-07 | Nelson | North Dakota | 38063 | 761 | 18 |
2381118 | 2381118 | 2022-04-06 | Emmons | North Dakota | 38029 | 726 | 18 |
2381135 | 2381135 | 2022-04-06 | Nelson | North Dakota | 38063 | 761 | 18 |
2377863 | 2377863 | 2022-04-05 | Emmons | North Dakota | 38029 | 726 | 18 |
2377880 | 2377880 | 2022-04-05 | Nelson | North Dakota | 38063 | 761 | 18 |
2374610 | 2374610 | 2022-04-04 | Emmons | North Dakota | 38029 | 726 | 18 |
2374627 | 2374627 | 2022-04-04 | Nelson | North Dakota | 38063 | 761 | 18 |
2371358 | 2371358 | 2022-04-03 | Emmons | North Dakota | 38029 | 726 | 18 |
2371375 | 2371375 | 2022-04-03 | Nelson | North Dakota | 38063 | 761 | 18 |
2368105 | 2368105 | 2022-04-02 | Emmons | North Dakota | 38029 | 726 | 18 |
2368122 | 2368122 | 2022-04-02 | Nelson | North Dakota | 38063 | 761 | 18 |
2364852 | 2364852 | 2022-04-01 | Emmons | North Dakota | 38029 | 726 | 18 |
2364869 | 2364869 | 2022-04-01 | Nelson | North Dakota | 38063 | 761 | 18 |
2361598 | 2361598 | 2022-03-31 | Emmons | North Dakota | 38029 | 726 | 18 |
2361615 | 2361615 | 2022-03-31 | Nelson | North Dakota | 38063 | 761 | 18 |
2358344 | 2358344 | 2022-03-30 | Emmons | North Dakota | 38029 | 726 | 18 |
2358361 | 2358361 | 2022-03-30 | Nelson | North Dakota | 38063 | 761 | 18 |
2355090 | 2355090 | 2022-03-29 | Emmons | North Dakota | 38029 | 726 | 18 |
2355107 | 2355107 | 2022-03-29 | Nelson | North Dakota | 38063 | 761 | 18 |
2351837 | 2351837 | 2022-03-28 | Emmons | North Dakota | 38029 | 726 | 18 |
2351854 | 2351854 | 2022-03-28 | Nelson | North Dakota | 38063 | 761 | 18 |
2348585 | 2348585 | 2022-03-27 | Emmons | North Dakota | 38029 | 726 | 18 |
2348602 | 2348602 | 2022-03-27 | Nelson | North Dakota | 38063 | 761 | 18 |
2345332 | 2345332 | 2022-03-26 | Emmons | North Dakota | 38029 | 726 | 18 |
2345349 | 2345349 | 2022-03-26 | Nelson | North Dakota | 38063 | 761 | 18 |
2342079 | 2342079 | 2022-03-25 | Emmons | North Dakota | 38029 | 726 | 18 |
2342096 | 2342096 | 2022-03-25 | Nelson | North Dakota | 38063 | 761 | 18 |
Advanced export
JSON shape: default, array, newline-delimited
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);