ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 38029 and state = "North Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
34735 | 34735 | 2020-04-05 | Emmons | North Dakota | 38029 | 1 | 0 |
37204 | 37204 | 2020-04-06 | Emmons | North Dakota | 38029 | 1 | 0 |
39721 | 39721 | 2020-04-07 | Emmons | North Dakota | 38029 | 1 | 1 |
42278 | 42278 | 2020-04-08 | Emmons | North Dakota | 38029 | 1 | 1 |
44862 | 44862 | 2020-04-09 | Emmons | North Dakota | 38029 | 1 | 1 |
47475 | 47475 | 2020-04-10 | Emmons | North Dakota | 38029 | 1 | 1 |
50130 | 50130 | 2020-04-11 | Emmons | North Dakota | 38029 | 1 | 1 |
52803 | 52803 | 2020-04-12 | Emmons | North Dakota | 38029 | 1 | 1 |
55487 | 55487 | 2020-04-13 | Emmons | North Dakota | 38029 | 1 | 1 |
58188 | 58188 | 2020-04-14 | Emmons | North Dakota | 38029 | 1 | 1 |
60902 | 60902 | 2020-04-15 | Emmons | North Dakota | 38029 | 1 | 1 |
63628 | 63628 | 2020-04-16 | Emmons | North Dakota | 38029 | 1 | 1 |
66371 | 66371 | 2020-04-17 | Emmons | North Dakota | 38029 | 1 | 1 |
69128 | 69128 | 2020-04-18 | Emmons | North Dakota | 38029 | 1 | 1 |
71894 | 71894 | 2020-04-19 | Emmons | North Dakota | 38029 | 1 | 1 |
74669 | 74669 | 2020-04-20 | Emmons | North Dakota | 38029 | 1 | 1 |
77450 | 77450 | 2020-04-21 | Emmons | North Dakota | 38029 | 1 | 1 |
80239 | 80239 | 2020-04-22 | Emmons | North Dakota | 38029 | 1 | 1 |
83038 | 83038 | 2020-04-23 | Emmons | North Dakota | 38029 | 1 | 1 |
85842 | 85842 | 2020-04-24 | Emmons | North Dakota | 38029 | 1 | 1 |
88655 | 88655 | 2020-04-25 | Emmons | North Dakota | 38029 | 1 | 1 |
91470 | 91470 | 2020-04-26 | Emmons | North Dakota | 38029 | 1 | 1 |
94296 | 94296 | 2020-04-27 | Emmons | North Dakota | 38029 | 1 | 1 |
97133 | 97133 | 2020-04-28 | Emmons | North Dakota | 38029 | 1 | 1 |
99982 | 99982 | 2020-04-29 | Emmons | North Dakota | 38029 | 1 | 1 |
102835 | 102835 | 2020-04-30 | Emmons | North Dakota | 38029 | 1 | 1 |
105697 | 105697 | 2020-05-01 | Emmons | North Dakota | 38029 | 1 | 1 |
108564 | 108564 | 2020-05-02 | Emmons | North Dakota | 38029 | 1 | 1 |
111438 | 111438 | 2020-05-03 | Emmons | North Dakota | 38029 | 1 | 1 |
114319 | 114319 | 2020-05-04 | Emmons | North Dakota | 38029 | 1 | 1 |
117199 | 117199 | 2020-05-05 | Emmons | North Dakota | 38029 | 1 | 1 |
120160 | 120160 | 2020-05-06 | Emmons | North Dakota | 38029 | 1 | 1 |
123136 | 123136 | 2020-05-07 | Emmons | North Dakota | 38029 | 1 | 1 |
126119 | 126119 | 2020-05-08 | Emmons | North Dakota | 38029 | 1 | 1 |
129108 | 129108 | 2020-05-09 | Emmons | North Dakota | 38029 | 1 | 1 |
132097 | 132097 | 2020-05-10 | Emmons | North Dakota | 38029 | 1 | 1 |
135088 | 135088 | 2020-05-11 | Emmons | North Dakota | 38029 | 1 | 1 |
138078 | 138078 | 2020-05-12 | Emmons | North Dakota | 38029 | 1 | 1 |
141074 | 141074 | 2020-05-13 | Emmons | North Dakota | 38029 | 1 | 1 |
144069 | 144069 | 2020-05-14 | Emmons | North Dakota | 38029 | 1 | 1 |
147070 | 147070 | 2020-05-15 | Emmons | North Dakota | 38029 | 1 | 1 |
150077 | 150077 | 2020-05-16 | Emmons | North Dakota | 38029 | 1 | 1 |
153087 | 153087 | 2020-05-17 | Emmons | North Dakota | 38029 | 1 | 1 |
156104 | 156104 | 2020-05-18 | Emmons | North Dakota | 38029 | 1 | 1 |
159124 | 159124 | 2020-05-19 | Emmons | North Dakota | 38029 | 1 | 1 |
162151 | 162151 | 2020-05-20 | Emmons | North Dakota | 38029 | 1 | 1 |
165180 | 165180 | 2020-05-21 | Emmons | North Dakota | 38029 | 5 | 1 |
168215 | 168215 | 2020-05-22 | Emmons | North Dakota | 38029 | 6 | 1 |
171254 | 171254 | 2020-05-23 | Emmons | North Dakota | 38029 | 6 | 1 |
174296 | 174296 | 2020-05-24 | Emmons | North Dakota | 38029 | 6 | 1 |
177340 | 177340 | 2020-05-25 | Emmons | North Dakota | 38029 | 6 | 1 |
180383 | 180383 | 2020-05-26 | Emmons | North Dakota | 38029 | 4 | 1 |
183431 | 183431 | 2020-05-27 | Emmons | North Dakota | 38029 | 4 | 1 |
186488 | 186488 | 2020-05-28 | Emmons | North Dakota | 38029 | 4 | 1 |
189548 | 189548 | 2020-05-29 | Emmons | North Dakota | 38029 | 4 | 1 |
192612 | 192612 | 2020-05-30 | Emmons | North Dakota | 38029 | 4 | 1 |
195682 | 195682 | 2020-05-31 | Emmons | North Dakota | 38029 | 4 | 1 |
198755 | 198755 | 2020-06-01 | Emmons | North Dakota | 38029 | 4 | 1 |
201830 | 201830 | 2020-06-02 | Emmons | North Dakota | 38029 | 4 | 1 |
204907 | 204907 | 2020-06-03 | Emmons | North Dakota | 38029 | 4 | 1 |
207988 | 207988 | 2020-06-04 | Emmons | North Dakota | 38029 | 4 | 1 |
211070 | 211070 | 2020-06-05 | Emmons | North Dakota | 38029 | 4 | 1 |
214154 | 214154 | 2020-06-06 | Emmons | North Dakota | 38029 | 4 | 1 |
217244 | 217244 | 2020-06-07 | Emmons | North Dakota | 38029 | 4 | 1 |
220336 | 220336 | 2020-06-08 | Emmons | North Dakota | 38029 | 4 | 1 |
223430 | 223430 | 2020-06-09 | Emmons | North Dakota | 38029 | 4 | 1 |
226530 | 226530 | 2020-06-10 | Emmons | North Dakota | 38029 | 4 | 1 |
229634 | 229634 | 2020-06-11 | Emmons | North Dakota | 38029 | 4 | 1 |
232739 | 232739 | 2020-06-12 | Emmons | North Dakota | 38029 | 4 | 1 |
235844 | 235844 | 2020-06-13 | Emmons | North Dakota | 38029 | 4 | 1 |
238952 | 238952 | 2020-06-14 | Emmons | North Dakota | 38029 | 4 | 1 |
242061 | 242061 | 2020-06-15 | Emmons | North Dakota | 38029 | 4 | 1 |
245173 | 245173 | 2020-06-16 | Emmons | North Dakota | 38029 | 4 | 1 |
248286 | 248286 | 2020-06-17 | Emmons | North Dakota | 38029 | 4 | 1 |
251401 | 251401 | 2020-06-18 | Emmons | North Dakota | 38029 | 4 | 1 |
254516 | 254516 | 2020-06-19 | Emmons | North Dakota | 38029 | 4 | 1 |
257641 | 257641 | 2020-06-20 | Emmons | North Dakota | 38029 | 4 | 1 |
260768 | 260768 | 2020-06-21 | Emmons | North Dakota | 38029 | 4 | 1 |
263896 | 263896 | 2020-06-22 | Emmons | North Dakota | 38029 | 4 | 1 |
267024 | 267024 | 2020-06-23 | Emmons | North Dakota | 38029 | 4 | 1 |
270158 | 270158 | 2020-06-24 | Emmons | North Dakota | 38029 | 4 | 1 |
273297 | 273297 | 2020-06-25 | Emmons | North Dakota | 38029 | 4 | 1 |
276443 | 276443 | 2020-06-26 | Emmons | North Dakota | 38029 | 4 | 1 |
279591 | 279591 | 2020-06-27 | Emmons | North Dakota | 38029 | 4 | 1 |
282737 | 282737 | 2020-06-28 | Emmons | North Dakota | 38029 | 4 | 1 |
285882 | 285882 | 2020-06-29 | Emmons | North Dakota | 38029 | 4 | 1 |
289032 | 289032 | 2020-06-30 | Emmons | North Dakota | 38029 | 4 | 1 |
292184 | 292184 | 2020-07-01 | Emmons | North Dakota | 38029 | 4 | 1 |
295339 | 295339 | 2020-07-02 | Emmons | North Dakota | 38029 | 4 | 1 |
298499 | 298499 | 2020-07-03 | Emmons | North Dakota | 38029 | 4 | 1 |
301662 | 301662 | 2020-07-04 | Emmons | North Dakota | 38029 | 4 | 1 |
304825 | 304825 | 2020-07-05 | Emmons | North Dakota | 38029 | 4 | 1 |
307992 | 307992 | 2020-07-06 | Emmons | North Dakota | 38029 | 4 | 1 |
311160 | 311160 | 2020-07-07 | Emmons | North Dakota | 38029 | 4 | 1 |
314331 | 314331 | 2020-07-08 | Emmons | North Dakota | 38029 | 4 | 1 |
317505 | 317505 | 2020-07-09 | Emmons | North Dakota | 38029 | 4 | 1 |
320682 | 320682 | 2020-07-10 | Emmons | North Dakota | 38029 | 4 | 1 |
323862 | 323862 | 2020-07-11 | Emmons | North Dakota | 38029 | 4 | 1 |
327046 | 327046 | 2020-07-12 | Emmons | North Dakota | 38029 | 4 | 1 |
330233 | 330233 | 2020-07-13 | Emmons | North Dakota | 38029 | 4 | 1 |
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);