ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 38011 and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
date (date) >30 ✖
- 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
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-05-05 1
- 2020-05-06 1
- …
state 1
- North Dakota · 767 ✖
fips 1
- 38011 · 767 ✖
county 1
- Bowman 767
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
39714 | 39714 | 2020-04-07 | Bowman | North Dakota | 38011 | 1 | 0 |
42271 | 42271 | 2020-04-08 | Bowman | North Dakota | 38011 | 1 | 0 |
44855 | 44855 | 2020-04-09 | Bowman | North Dakota | 38011 | 1 | 0 |
47468 | 47468 | 2020-04-10 | Bowman | North Dakota | 38011 | 1 | 0 |
50123 | 50123 | 2020-04-11 | Bowman | North Dakota | 38011 | 1 | 0 |
52796 | 52796 | 2020-04-12 | Bowman | North Dakota | 38011 | 1 | 0 |
55480 | 55480 | 2020-04-13 | Bowman | North Dakota | 38011 | 1 | 0 |
58181 | 58181 | 2020-04-14 | Bowman | North Dakota | 38011 | 1 | 0 |
60895 | 60895 | 2020-04-15 | Bowman | North Dakota | 38011 | 1 | 0 |
63621 | 63621 | 2020-04-16 | Bowman | North Dakota | 38011 | 1 | 0 |
66364 | 66364 | 2020-04-17 | Bowman | North Dakota | 38011 | 1 | 0 |
69121 | 69121 | 2020-04-18 | Bowman | North Dakota | 38011 | 1 | 0 |
71887 | 71887 | 2020-04-19 | Bowman | North Dakota | 38011 | 1 | 0 |
74662 | 74662 | 2020-04-20 | Bowman | North Dakota | 38011 | 1 | 0 |
77443 | 77443 | 2020-04-21 | Bowman | North Dakota | 38011 | 1 | 0 |
80232 | 80232 | 2020-04-22 | Bowman | North Dakota | 38011 | 1 | 0 |
83031 | 83031 | 2020-04-23 | Bowman | North Dakota | 38011 | 1 | 0 |
85835 | 85835 | 2020-04-24 | Bowman | North Dakota | 38011 | 1 | 0 |
88648 | 88648 | 2020-04-25 | Bowman | North Dakota | 38011 | 1 | 0 |
91463 | 91463 | 2020-04-26 | Bowman | North Dakota | 38011 | 1 | 0 |
94289 | 94289 | 2020-04-27 | Bowman | North Dakota | 38011 | 1 | 0 |
97126 | 97126 | 2020-04-28 | Bowman | North Dakota | 38011 | 1 | 0 |
99975 | 99975 | 2020-04-29 | Bowman | North Dakota | 38011 | 1 | 0 |
102828 | 102828 | 2020-04-30 | Bowman | North Dakota | 38011 | 1 | 0 |
105690 | 105690 | 2020-05-01 | Bowman | North Dakota | 38011 | 1 | 0 |
108557 | 108557 | 2020-05-02 | Bowman | North Dakota | 38011 | 1 | 0 |
111431 | 111431 | 2020-05-03 | Bowman | North Dakota | 38011 | 1 | 0 |
114312 | 114312 | 2020-05-04 | Bowman | North Dakota | 38011 | 1 | 0 |
117192 | 117192 | 2020-05-05 | Bowman | North Dakota | 38011 | 1 | 0 |
120153 | 120153 | 2020-05-06 | Bowman | North Dakota | 38011 | 1 | 0 |
123129 | 123129 | 2020-05-07 | Bowman | North Dakota | 38011 | 1 | 0 |
126112 | 126112 | 2020-05-08 | Bowman | North Dakota | 38011 | 1 | 0 |
129101 | 129101 | 2020-05-09 | Bowman | North Dakota | 38011 | 1 | 0 |
132090 | 132090 | 2020-05-10 | Bowman | North Dakota | 38011 | 1 | 0 |
135081 | 135081 | 2020-05-11 | Bowman | North Dakota | 38011 | 1 | 0 |
138071 | 138071 | 2020-05-12 | Bowman | North Dakota | 38011 | 1 | 0 |
141067 | 141067 | 2020-05-13 | Bowman | North Dakota | 38011 | 1 | 0 |
144062 | 144062 | 2020-05-14 | Bowman | North Dakota | 38011 | 1 | 0 |
147063 | 147063 | 2020-05-15 | Bowman | North Dakota | 38011 | 1 | 0 |
150070 | 150070 | 2020-05-16 | Bowman | North Dakota | 38011 | 1 | 0 |
153080 | 153080 | 2020-05-17 | Bowman | North Dakota | 38011 | 1 | 0 |
156097 | 156097 | 2020-05-18 | Bowman | North Dakota | 38011 | 1 | 0 |
159117 | 159117 | 2020-05-19 | Bowman | North Dakota | 38011 | 1 | 0 |
162144 | 162144 | 2020-05-20 | Bowman | North Dakota | 38011 | 1 | 0 |
165173 | 165173 | 2020-05-21 | Bowman | North Dakota | 38011 | 1 | 0 |
168208 | 168208 | 2020-05-22 | Bowman | North Dakota | 38011 | 1 | 0 |
171247 | 171247 | 2020-05-23 | Bowman | North Dakota | 38011 | 1 | 0 |
174289 | 174289 | 2020-05-24 | Bowman | North Dakota | 38011 | 1 | 0 |
177333 | 177333 | 2020-05-25 | Bowman | North Dakota | 38011 | 1 | 0 |
180376 | 180376 | 2020-05-26 | Bowman | North Dakota | 38011 | 1 | 0 |
183424 | 183424 | 2020-05-27 | Bowman | North Dakota | 38011 | 1 | 0 |
186481 | 186481 | 2020-05-28 | Bowman | North Dakota | 38011 | 1 | 0 |
189541 | 189541 | 2020-05-29 | Bowman | North Dakota | 38011 | 1 | 0 |
192605 | 192605 | 2020-05-30 | Bowman | North Dakota | 38011 | 1 | 0 |
195675 | 195675 | 2020-05-31 | Bowman | North Dakota | 38011 | 1 | 0 |
198748 | 198748 | 2020-06-01 | Bowman | North Dakota | 38011 | 1 | 0 |
201822 | 201822 | 2020-06-02 | Bowman | North Dakota | 38011 | 1 | 0 |
204899 | 204899 | 2020-06-03 | Bowman | North Dakota | 38011 | 1 | 0 |
207980 | 207980 | 2020-06-04 | Bowman | North Dakota | 38011 | 1 | 0 |
211062 | 211062 | 2020-06-05 | Bowman | North Dakota | 38011 | 1 | 0 |
214146 | 214146 | 2020-06-06 | Bowman | North Dakota | 38011 | 1 | 0 |
217236 | 217236 | 2020-06-07 | Bowman | North Dakota | 38011 | 1 | 0 |
220328 | 220328 | 2020-06-08 | Bowman | North Dakota | 38011 | 1 | 0 |
223422 | 223422 | 2020-06-09 | Bowman | North Dakota | 38011 | 1 | 0 |
226522 | 226522 | 2020-06-10 | Bowman | North Dakota | 38011 | 1 | 0 |
229626 | 229626 | 2020-06-11 | Bowman | North Dakota | 38011 | 1 | 0 |
232731 | 232731 | 2020-06-12 | Bowman | North Dakota | 38011 | 1 | 0 |
235836 | 235836 | 2020-06-13 | Bowman | North Dakota | 38011 | 1 | 0 |
238944 | 238944 | 2020-06-14 | Bowman | North Dakota | 38011 | 1 | 0 |
242053 | 242053 | 2020-06-15 | Bowman | North Dakota | 38011 | 1 | 0 |
245165 | 245165 | 2020-06-16 | Bowman | North Dakota | 38011 | 1 | 0 |
248278 | 248278 | 2020-06-17 | Bowman | North Dakota | 38011 | 1 | 0 |
251393 | 251393 | 2020-06-18 | Bowman | North Dakota | 38011 | 1 | 0 |
254508 | 254508 | 2020-06-19 | Bowman | North Dakota | 38011 | 1 | 0 |
257632 | 257632 | 2020-06-20 | Bowman | North Dakota | 38011 | 1 | 0 |
260759 | 260759 | 2020-06-21 | Bowman | North Dakota | 38011 | 1 | 0 |
263887 | 263887 | 2020-06-22 | Bowman | North Dakota | 38011 | 1 | 0 |
267015 | 267015 | 2020-06-23 | Bowman | North Dakota | 38011 | 1 | 0 |
270149 | 270149 | 2020-06-24 | Bowman | North Dakota | 38011 | 1 | 0 |
273288 | 273288 | 2020-06-25 | Bowman | North Dakota | 38011 | 1 | 0 |
276434 | 276434 | 2020-06-26 | Bowman | North Dakota | 38011 | 1 | 0 |
279582 | 279582 | 2020-06-27 | Bowman | North Dakota | 38011 | 1 | 0 |
282728 | 282728 | 2020-06-28 | Bowman | North Dakota | 38011 | 1 | 0 |
285873 | 285873 | 2020-06-29 | Bowman | North Dakota | 38011 | 1 | 0 |
289023 | 289023 | 2020-06-30 | Bowman | North Dakota | 38011 | 1 | 0 |
292175 | 292175 | 2020-07-01 | Bowman | North Dakota | 38011 | 1 | 0 |
295330 | 295330 | 2020-07-02 | Bowman | North Dakota | 38011 | 1 | 0 |
298490 | 298490 | 2020-07-03 | Bowman | North Dakota | 38011 | 1 | 0 |
301653 | 301653 | 2020-07-04 | Bowman | North Dakota | 38011 | 1 | 0 |
304816 | 304816 | 2020-07-05 | Bowman | North Dakota | 38011 | 1 | 0 |
307983 | 307983 | 2020-07-06 | Bowman | North Dakota | 38011 | 1 | 0 |
311151 | 311151 | 2020-07-07 | Bowman | North Dakota | 38011 | 1 | 0 |
314322 | 314322 | 2020-07-08 | Bowman | North Dakota | 38011 | 1 | 0 |
317496 | 317496 | 2020-07-09 | Bowman | North Dakota | 38011 | 1 | 0 |
320673 | 320673 | 2020-07-10 | Bowman | North Dakota | 38011 | 1 | 0 |
323853 | 323853 | 2020-07-11 | Bowman | North Dakota | 38011 | 1 | 0 |
327037 | 327037 | 2020-07-12 | Bowman | North Dakota | 38011 | 1 | 0 |
330224 | 330224 | 2020-07-13 | Bowman | North Dakota | 38011 | 1 | 0 |
333414 | 333414 | 2020-07-14 | Bowman | North Dakota | 38011 | 1 | 0 |
336608 | 336608 | 2020-07-15 | Bowman | North Dakota | 38011 | 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);