ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 1059 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- North Dakota · 40 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
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 |
1906361 | 1906361 | 2021-11-11 | Dickey | North Dakota | 38021 | 1059 | 35 |
1588011 | 1588011 | 2021-08-05 | Traill | North Dakota | 38097 | 1059 | 18 |
1269809 | 1269809 | 2021-04-29 | Benson | North Dakota | 38005 | 1059 | 18 |
1019835 | 1019835 | 2021-02-11 | Mercer | North Dakota | 38057 | 1059 | 9 |
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);