ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 38061 and state = "North Dakota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- …
state 1
- North Dakota · 777 ✖
fips 1
- 38061 · 777 ✖
county 1
- Mountrail 777
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17027 | 17027 | 2020-03-28 | Mountrail | North Dakota | 38061 | 2 | 0 |
18961 | 18961 | 2020-03-29 | Mountrail | North Dakota | 38061 | 2 | 0 |
21003 | 21003 | 2020-03-30 | Mountrail | North Dakota | 38061 | 4 | 0 |
23134 | 23134 | 2020-03-31 | Mountrail | North Dakota | 38061 | 5 | 0 |
25329 | 25329 | 2020-04-01 | Mountrail | North Dakota | 38061 | 6 | 0 |
27595 | 27595 | 2020-04-02 | Mountrail | North Dakota | 38061 | 8 | 0 |
29923 | 29923 | 2020-04-03 | Mountrail | North Dakota | 38061 | 11 | 0 |
32311 | 32311 | 2020-04-04 | Mountrail | North Dakota | 38061 | 13 | 0 |
34744 | 34744 | 2020-04-05 | Mountrail | North Dakota | 38061 | 19 | 0 |
37213 | 37213 | 2020-04-06 | Mountrail | North Dakota | 38061 | 19 | 0 |
39730 | 39730 | 2020-04-07 | Mountrail | North Dakota | 38061 | 20 | 0 |
42287 | 42287 | 2020-04-08 | Mountrail | North Dakota | 38061 | 20 | 0 |
44871 | 44871 | 2020-04-09 | Mountrail | North Dakota | 38061 | 20 | 0 |
47484 | 47484 | 2020-04-10 | Mountrail | North Dakota | 38061 | 20 | 0 |
50139 | 50139 | 2020-04-11 | Mountrail | North Dakota | 38061 | 21 | 0 |
52812 | 52812 | 2020-04-12 | Mountrail | North Dakota | 38061 | 21 | 0 |
55496 | 55496 | 2020-04-13 | Mountrail | North Dakota | 38061 | 27 | 0 |
58197 | 58197 | 2020-04-14 | Mountrail | North Dakota | 38061 | 27 | 0 |
60911 | 60911 | 2020-04-15 | Mountrail | North Dakota | 38061 | 29 | 0 |
63637 | 63637 | 2020-04-16 | Mountrail | North Dakota | 38061 | 29 | 0 |
66380 | 66380 | 2020-04-17 | Mountrail | North Dakota | 38061 | 29 | 0 |
69137 | 69137 | 2020-04-18 | Mountrail | North Dakota | 38061 | 29 | 0 |
71903 | 71903 | 2020-04-19 | Mountrail | North Dakota | 38061 | 30 | 0 |
74678 | 74678 | 2020-04-20 | Mountrail | North Dakota | 38061 | 30 | 0 |
77459 | 77459 | 2020-04-21 | Mountrail | North Dakota | 38061 | 31 | 0 |
80248 | 80248 | 2020-04-22 | Mountrail | North Dakota | 38061 | 31 | 0 |
83047 | 83047 | 2020-04-23 | Mountrail | North Dakota | 38061 | 33 | 0 |
85851 | 85851 | 2020-04-24 | Mountrail | North Dakota | 38061 | 33 | 0 |
88664 | 88664 | 2020-04-25 | Mountrail | North Dakota | 38061 | 33 | 0 |
91479 | 91479 | 2020-04-26 | Mountrail | North Dakota | 38061 | 33 | 0 |
94305 | 94305 | 2020-04-27 | Mountrail | North Dakota | 38061 | 34 | 0 |
97142 | 97142 | 2020-04-28 | Mountrail | North Dakota | 38061 | 35 | 0 |
99991 | 99991 | 2020-04-29 | Mountrail | North Dakota | 38061 | 35 | 0 |
102844 | 102844 | 2020-04-30 | Mountrail | North Dakota | 38061 | 35 | 0 |
105706 | 105706 | 2020-05-01 | Mountrail | North Dakota | 38061 | 35 | 0 |
108573 | 108573 | 2020-05-02 | Mountrail | North Dakota | 38061 | 35 | 0 |
111447 | 111447 | 2020-05-03 | Mountrail | North Dakota | 38061 | 35 | 0 |
114328 | 114328 | 2020-05-04 | Mountrail | North Dakota | 38061 | 35 | 0 |
117209 | 117209 | 2020-05-05 | Mountrail | North Dakota | 38061 | 35 | 0 |
120170 | 120170 | 2020-05-06 | Mountrail | North Dakota | 38061 | 36 | 0 |
123146 | 123146 | 2020-05-07 | Mountrail | North Dakota | 38061 | 35 | 0 |
126129 | 126129 | 2020-05-08 | Mountrail | North Dakota | 38061 | 37 | 0 |
129118 | 129118 | 2020-05-09 | Mountrail | North Dakota | 38061 | 37 | 0 |
132107 | 132107 | 2020-05-10 | Mountrail | North Dakota | 38061 | 37 | 0 |
135098 | 135098 | 2020-05-11 | Mountrail | North Dakota | 38061 | 37 | 0 |
138088 | 138088 | 2020-05-12 | Mountrail | North Dakota | 38061 | 37 | 0 |
141084 | 141084 | 2020-05-13 | Mountrail | North Dakota | 38061 | 37 | 0 |
144079 | 144079 | 2020-05-14 | Mountrail | North Dakota | 38061 | 38 | 0 |
147080 | 147080 | 2020-05-15 | Mountrail | North Dakota | 38061 | 38 | 0 |
150087 | 150087 | 2020-05-16 | Mountrail | North Dakota | 38061 | 40 | 0 |
153097 | 153097 | 2020-05-17 | Mountrail | North Dakota | 38061 | 42 | 0 |
156114 | 156114 | 2020-05-18 | Mountrail | North Dakota | 38061 | 42 | 0 |
159134 | 159134 | 2020-05-19 | Mountrail | North Dakota | 38061 | 39 | 0 |
162161 | 162161 | 2020-05-20 | Mountrail | North Dakota | 38061 | 39 | 0 |
165190 | 165190 | 2020-05-21 | Mountrail | North Dakota | 38061 | 39 | 0 |
168226 | 168226 | 2020-05-22 | Mountrail | North Dakota | 38061 | 39 | 0 |
171265 | 171265 | 2020-05-23 | Mountrail | North Dakota | 38061 | 39 | 0 |
174307 | 174307 | 2020-05-24 | Mountrail | North Dakota | 38061 | 39 | 0 |
177351 | 177351 | 2020-05-25 | Mountrail | North Dakota | 38061 | 39 | 0 |
180394 | 180394 | 2020-05-26 | Mountrail | North Dakota | 38061 | 39 | 0 |
183442 | 183442 | 2020-05-27 | Mountrail | North Dakota | 38061 | 39 | 0 |
186499 | 186499 | 2020-05-28 | Mountrail | North Dakota | 38061 | 39 | 0 |
189559 | 189559 | 2020-05-29 | Mountrail | North Dakota | 38061 | 39 | 0 |
192623 | 192623 | 2020-05-30 | Mountrail | North Dakota | 38061 | 39 | 0 |
195693 | 195693 | 2020-05-31 | Mountrail | North Dakota | 38061 | 39 | 0 |
198766 | 198766 | 2020-06-01 | Mountrail | North Dakota | 38061 | 40 | 0 |
201841 | 201841 | 2020-06-02 | Mountrail | North Dakota | 38061 | 41 | 0 |
204918 | 204918 | 2020-06-03 | Mountrail | North Dakota | 38061 | 41 | 0 |
207999 | 207999 | 2020-06-04 | Mountrail | North Dakota | 38061 | 42 | 0 |
211081 | 211081 | 2020-06-05 | Mountrail | North Dakota | 38061 | 42 | 0 |
214166 | 214166 | 2020-06-06 | Mountrail | North Dakota | 38061 | 42 | 0 |
217256 | 217256 | 2020-06-07 | Mountrail | North Dakota | 38061 | 43 | 0 |
220348 | 220348 | 2020-06-08 | Mountrail | North Dakota | 38061 | 43 | 0 |
223443 | 223443 | 2020-06-09 | Mountrail | North Dakota | 38061 | 43 | 0 |
226543 | 226543 | 2020-06-10 | Mountrail | North Dakota | 38061 | 43 | 0 |
229647 | 229647 | 2020-06-11 | Mountrail | North Dakota | 38061 | 43 | 0 |
232752 | 232752 | 2020-06-12 | Mountrail | North Dakota | 38061 | 43 | 0 |
235857 | 235857 | 2020-06-13 | Mountrail | North Dakota | 38061 | 43 | 0 |
238965 | 238965 | 2020-06-14 | Mountrail | North Dakota | 38061 | 43 | 0 |
242074 | 242074 | 2020-06-15 | Mountrail | North Dakota | 38061 | 43 | 0 |
245186 | 245186 | 2020-06-16 | Mountrail | North Dakota | 38061 | 43 | 0 |
248299 | 248299 | 2020-06-17 | Mountrail | North Dakota | 38061 | 43 | 0 |
251414 | 251414 | 2020-06-18 | Mountrail | North Dakota | 38061 | 43 | 0 |
254529 | 254529 | 2020-06-19 | Mountrail | North Dakota | 38061 | 43 | 0 |
257654 | 257654 | 2020-06-20 | Mountrail | North Dakota | 38061 | 43 | 0 |
260781 | 260781 | 2020-06-21 | Mountrail | North Dakota | 38061 | 43 | 0 |
263909 | 263909 | 2020-06-22 | Mountrail | North Dakota | 38061 | 43 | 0 |
267037 | 267037 | 2020-06-23 | Mountrail | North Dakota | 38061 | 43 | 0 |
270171 | 270171 | 2020-06-24 | Mountrail | North Dakota | 38061 | 43 | 0 |
273310 | 273310 | 2020-06-25 | Mountrail | North Dakota | 38061 | 43 | 0 |
276457 | 276457 | 2020-06-26 | Mountrail | North Dakota | 38061 | 44 | 0 |
279605 | 279605 | 2020-06-27 | Mountrail | North Dakota | 38061 | 44 | 0 |
282751 | 282751 | 2020-06-28 | Mountrail | North Dakota | 38061 | 45 | 0 |
285896 | 285896 | 2020-06-29 | Mountrail | North Dakota | 38061 | 47 | 0 |
289046 | 289046 | 2020-06-30 | Mountrail | North Dakota | 38061 | 50 | 0 |
292198 | 292198 | 2020-07-01 | Mountrail | North Dakota | 38061 | 50 | 0 |
295353 | 295353 | 2020-07-02 | Mountrail | North Dakota | 38061 | 50 | 0 |
298513 | 298513 | 2020-07-03 | Mountrail | North Dakota | 38061 | 51 | 0 |
301676 | 301676 | 2020-07-04 | Mountrail | North Dakota | 38061 | 54 | 0 |
304839 | 304839 | 2020-07-05 | Mountrail | North Dakota | 38061 | 54 | 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);