ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 38023 and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
17020 | 17020 | 2020-03-28 | Divide | North Dakota | 38023 | 1 | 0 |
18954 | 18954 | 2020-03-29 | Divide | North Dakota | 38023 | 1 | 0 |
20995 | 20995 | 2020-03-30 | Divide | North Dakota | 38023 | 1 | 0 |
23124 | 23124 | 2020-03-31 | Divide | North Dakota | 38023 | 1 | 0 |
25319 | 25319 | 2020-04-01 | Divide | North Dakota | 38023 | 1 | 0 |
27585 | 27585 | 2020-04-02 | Divide | North Dakota | 38023 | 1 | 0 |
29912 | 29912 | 2020-04-03 | Divide | North Dakota | 38023 | 1 | 0 |
32300 | 32300 | 2020-04-04 | Divide | North Dakota | 38023 | 1 | 0 |
34732 | 34732 | 2020-04-05 | Divide | North Dakota | 38023 | 1 | 0 |
37201 | 37201 | 2020-04-06 | Divide | North Dakota | 38023 | 1 | 0 |
39718 | 39718 | 2020-04-07 | Divide | North Dakota | 38023 | 1 | 0 |
42275 | 42275 | 2020-04-08 | Divide | North Dakota | 38023 | 1 | 0 |
44859 | 44859 | 2020-04-09 | Divide | North Dakota | 38023 | 1 | 0 |
47472 | 47472 | 2020-04-10 | Divide | North Dakota | 38023 | 1 | 0 |
50127 | 50127 | 2020-04-11 | Divide | North Dakota | 38023 | 1 | 0 |
52800 | 52800 | 2020-04-12 | Divide | North Dakota | 38023 | 1 | 0 |
55484 | 55484 | 2020-04-13 | Divide | North Dakota | 38023 | 1 | 0 |
58185 | 58185 | 2020-04-14 | Divide | North Dakota | 38023 | 1 | 0 |
60899 | 60899 | 2020-04-15 | Divide | North Dakota | 38023 | 1 | 0 |
63625 | 63625 | 2020-04-16 | Divide | North Dakota | 38023 | 1 | 0 |
66368 | 66368 | 2020-04-17 | Divide | North Dakota | 38023 | 1 | 0 |
69125 | 69125 | 2020-04-18 | Divide | North Dakota | 38023 | 1 | 0 |
71891 | 71891 | 2020-04-19 | Divide | North Dakota | 38023 | 1 | 0 |
74666 | 74666 | 2020-04-20 | Divide | North Dakota | 38023 | 1 | 0 |
77447 | 77447 | 2020-04-21 | Divide | North Dakota | 38023 | 1 | 0 |
80236 | 80236 | 2020-04-22 | Divide | North Dakota | 38023 | 1 | 0 |
83035 | 83035 | 2020-04-23 | Divide | North Dakota | 38023 | 1 | 0 |
85839 | 85839 | 2020-04-24 | Divide | North Dakota | 38023 | 1 | 0 |
88652 | 88652 | 2020-04-25 | Divide | North Dakota | 38023 | 1 | 0 |
91467 | 91467 | 2020-04-26 | Divide | North Dakota | 38023 | 1 | 0 |
94293 | 94293 | 2020-04-27 | Divide | North Dakota | 38023 | 1 | 0 |
97130 | 97130 | 2020-04-28 | Divide | North Dakota | 38023 | 1 | 0 |
99979 | 99979 | 2020-04-29 | Divide | North Dakota | 38023 | 1 | 0 |
102832 | 102832 | 2020-04-30 | Divide | North Dakota | 38023 | 1 | 0 |
105694 | 105694 | 2020-05-01 | Divide | North Dakota | 38023 | 1 | 0 |
108561 | 108561 | 2020-05-02 | Divide | North Dakota | 38023 | 1 | 0 |
111435 | 111435 | 2020-05-03 | Divide | North Dakota | 38023 | 1 | 0 |
114316 | 114316 | 2020-05-04 | Divide | North Dakota | 38023 | 1 | 0 |
117196 | 117196 | 2020-05-05 | Divide | North Dakota | 38023 | 1 | 0 |
120157 | 120157 | 2020-05-06 | Divide | North Dakota | 38023 | 1 | 0 |
123133 | 123133 | 2020-05-07 | Divide | North Dakota | 38023 | 1 | 0 |
126116 | 126116 | 2020-05-08 | Divide | North Dakota | 38023 | 1 | 0 |
129105 | 129105 | 2020-05-09 | Divide | North Dakota | 38023 | 1 | 0 |
132094 | 132094 | 2020-05-10 | Divide | North Dakota | 38023 | 1 | 0 |
135085 | 135085 | 2020-05-11 | Divide | North Dakota | 38023 | 1 | 0 |
138075 | 138075 | 2020-05-12 | Divide | North Dakota | 38023 | 1 | 0 |
141071 | 141071 | 2020-05-13 | Divide | North Dakota | 38023 | 1 | 0 |
144066 | 144066 | 2020-05-14 | Divide | North Dakota | 38023 | 1 | 0 |
147067 | 147067 | 2020-05-15 | Divide | North Dakota | 38023 | 1 | 0 |
150074 | 150074 | 2020-05-16 | Divide | North Dakota | 38023 | 1 | 0 |
153084 | 153084 | 2020-05-17 | Divide | North Dakota | 38023 | 1 | 0 |
156101 | 156101 | 2020-05-18 | Divide | North Dakota | 38023 | 1 | 0 |
159121 | 159121 | 2020-05-19 | Divide | North Dakota | 38023 | 1 | 0 |
162148 | 162148 | 2020-05-20 | Divide | North Dakota | 38023 | 1 | 0 |
165177 | 165177 | 2020-05-21 | Divide | North Dakota | 38023 | 1 | 0 |
168212 | 168212 | 2020-05-22 | Divide | North Dakota | 38023 | 1 | 0 |
171251 | 171251 | 2020-05-23 | Divide | North Dakota | 38023 | 1 | 0 |
174293 | 174293 | 2020-05-24 | Divide | North Dakota | 38023 | 1 | 0 |
177337 | 177337 | 2020-05-25 | Divide | North Dakota | 38023 | 1 | 0 |
180380 | 180380 | 2020-05-26 | Divide | North Dakota | 38023 | 1 | 0 |
183428 | 183428 | 2020-05-27 | Divide | North Dakota | 38023 | 1 | 0 |
186485 | 186485 | 2020-05-28 | Divide | North Dakota | 38023 | 1 | 0 |
189545 | 189545 | 2020-05-29 | Divide | North Dakota | 38023 | 1 | 0 |
192609 | 192609 | 2020-05-30 | Divide | North Dakota | 38023 | 1 | 0 |
195679 | 195679 | 2020-05-31 | Divide | North Dakota | 38023 | 1 | 0 |
198752 | 198752 | 2020-06-01 | Divide | North Dakota | 38023 | 1 | 0 |
201827 | 201827 | 2020-06-02 | Divide | North Dakota | 38023 | 1 | 0 |
204904 | 204904 | 2020-06-03 | Divide | North Dakota | 38023 | 1 | 0 |
207985 | 207985 | 2020-06-04 | Divide | North Dakota | 38023 | 1 | 0 |
211067 | 211067 | 2020-06-05 | Divide | North Dakota | 38023 | 1 | 0 |
214151 | 214151 | 2020-06-06 | Divide | North Dakota | 38023 | 1 | 0 |
217241 | 217241 | 2020-06-07 | Divide | North Dakota | 38023 | 1 | 0 |
220333 | 220333 | 2020-06-08 | Divide | North Dakota | 38023 | 1 | 0 |
223427 | 223427 | 2020-06-09 | Divide | North Dakota | 38023 | 1 | 0 |
226527 | 226527 | 2020-06-10 | Divide | North Dakota | 38023 | 1 | 0 |
229631 | 229631 | 2020-06-11 | Divide | North Dakota | 38023 | 1 | 0 |
232736 | 232736 | 2020-06-12 | Divide | North Dakota | 38023 | 1 | 0 |
235841 | 235841 | 2020-06-13 | Divide | North Dakota | 38023 | 1 | 0 |
238949 | 238949 | 2020-06-14 | Divide | North Dakota | 38023 | 1 | 0 |
242058 | 242058 | 2020-06-15 | Divide | North Dakota | 38023 | 1 | 0 |
245170 | 245170 | 2020-06-16 | Divide | North Dakota | 38023 | 1 | 0 |
248283 | 248283 | 2020-06-17 | Divide | North Dakota | 38023 | 1 | 0 |
251398 | 251398 | 2020-06-18 | Divide | North Dakota | 38023 | 1 | 0 |
254513 | 254513 | 2020-06-19 | Divide | North Dakota | 38023 | 1 | 0 |
257638 | 257638 | 2020-06-20 | Divide | North Dakota | 38023 | 1 | 0 |
260765 | 260765 | 2020-06-21 | Divide | North Dakota | 38023 | 1 | 0 |
263893 | 263893 | 2020-06-22 | Divide | North Dakota | 38023 | 1 | 0 |
267021 | 267021 | 2020-06-23 | Divide | North Dakota | 38023 | 1 | 0 |
270155 | 270155 | 2020-06-24 | Divide | North Dakota | 38023 | 1 | 0 |
273294 | 273294 | 2020-06-25 | Divide | North Dakota | 38023 | 1 | 0 |
276440 | 276440 | 2020-06-26 | Divide | North Dakota | 38023 | 1 | 0 |
279588 | 279588 | 2020-06-27 | Divide | North Dakota | 38023 | 1 | 0 |
282734 | 282734 | 2020-06-28 | Divide | North Dakota | 38023 | 1 | 0 |
285879 | 285879 | 2020-06-29 | Divide | North Dakota | 38023 | 1 | 0 |
289029 | 289029 | 2020-06-30 | Divide | North Dakota | 38023 | 1 | 0 |
292181 | 292181 | 2020-07-01 | Divide | North Dakota | 38023 | 1 | 0 |
295336 | 295336 | 2020-07-02 | Divide | North Dakota | 38023 | 1 | 0 |
298496 | 298496 | 2020-07-03 | Divide | North Dakota | 38023 | 1 | 0 |
301659 | 301659 | 2020-07-04 | Divide | North Dakota | 38023 | 1 | 0 |
304822 | 304822 | 2020-07-05 | Divide | North Dakota | 38023 | 1 | 0 |
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);