ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38105 and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
23142 | 23142 | 2020-03-31 | Williams | North Dakota | 38105 | 3 | 0 |
25337 | 25337 | 2020-04-01 | Williams | North Dakota | 38105 | 3 | 0 |
27603 | 27603 | 2020-04-02 | Williams | North Dakota | 38105 | 4 | 0 |
29932 | 29932 | 2020-04-03 | Williams | North Dakota | 38105 | 5 | 0 |
32320 | 32320 | 2020-04-04 | Williams | North Dakota | 38105 | 5 | 0 |
34753 | 34753 | 2020-04-05 | Williams | North Dakota | 38105 | 5 | 0 |
37222 | 37222 | 2020-04-06 | Williams | North Dakota | 38105 | 5 | 0 |
39739 | 39739 | 2020-04-07 | Williams | North Dakota | 38105 | 5 | 0 |
42297 | 42297 | 2020-04-08 | Williams | North Dakota | 38105 | 5 | 0 |
44882 | 44882 | 2020-04-09 | Williams | North Dakota | 38105 | 6 | 0 |
47497 | 47497 | 2020-04-10 | Williams | North Dakota | 38105 | 6 | 0 |
50152 | 50152 | 2020-04-11 | Williams | North Dakota | 38105 | 8 | 0 |
52825 | 52825 | 2020-04-12 | Williams | North Dakota | 38105 | 8 | 0 |
55509 | 55509 | 2020-04-13 | Williams | North Dakota | 38105 | 8 | 0 |
58210 | 58210 | 2020-04-14 | Williams | North Dakota | 38105 | 8 | 0 |
60924 | 60924 | 2020-04-15 | Williams | North Dakota | 38105 | 8 | 0 |
63650 | 63650 | 2020-04-16 | Williams | North Dakota | 38105 | 8 | 0 |
66393 | 66393 | 2020-04-17 | Williams | North Dakota | 38105 | 9 | 0 |
69150 | 69150 | 2020-04-18 | Williams | North Dakota | 38105 | 10 | 0 |
71917 | 71917 | 2020-04-19 | Williams | North Dakota | 38105 | 9 | 0 |
74692 | 74692 | 2020-04-20 | Williams | North Dakota | 38105 | 9 | 0 |
77473 | 77473 | 2020-04-21 | Williams | North Dakota | 38105 | 9 | 0 |
80263 | 80263 | 2020-04-22 | Williams | North Dakota | 38105 | 9 | 0 |
83062 | 83062 | 2020-04-23 | Williams | North Dakota | 38105 | 9 | 0 |
85866 | 85866 | 2020-04-24 | Williams | North Dakota | 38105 | 10 | 0 |
88680 | 88680 | 2020-04-25 | Williams | North Dakota | 38105 | 10 | 0 |
91496 | 91496 | 2020-04-26 | Williams | North Dakota | 38105 | 10 | 0 |
94322 | 94322 | 2020-04-27 | Williams | North Dakota | 38105 | 10 | 0 |
97159 | 97159 | 2020-04-28 | Williams | North Dakota | 38105 | 10 | 0 |
100008 | 100008 | 2020-04-29 | Williams | North Dakota | 38105 | 10 | 0 |
102861 | 102861 | 2020-04-30 | Williams | North Dakota | 38105 | 10 | 0 |
105724 | 105724 | 2020-05-01 | Williams | North Dakota | 38105 | 10 | 0 |
108591 | 108591 | 2020-05-02 | Williams | North Dakota | 38105 | 10 | 0 |
111465 | 111465 | 2020-05-03 | Williams | North Dakota | 38105 | 11 | 0 |
114346 | 114346 | 2020-05-04 | Williams | North Dakota | 38105 | 11 | 0 |
117227 | 117227 | 2020-05-05 | Williams | North Dakota | 38105 | 13 | 0 |
120188 | 120188 | 2020-05-06 | Williams | North Dakota | 38105 | 13 | 0 |
123165 | 123165 | 2020-05-07 | Williams | North Dakota | 38105 | 18 | 0 |
126148 | 126148 | 2020-05-08 | Williams | North Dakota | 38105 | 18 | 0 |
129137 | 129137 | 2020-05-09 | Williams | North Dakota | 38105 | 18 | 0 |
132126 | 132126 | 2020-05-10 | Williams | North Dakota | 38105 | 18 | 0 |
135117 | 135117 | 2020-05-11 | Williams | North Dakota | 38105 | 19 | 0 |
138107 | 138107 | 2020-05-12 | Williams | North Dakota | 38105 | 20 | 0 |
141103 | 141103 | 2020-05-13 | Williams | North Dakota | 38105 | 20 | 0 |
144098 | 144098 | 2020-05-14 | Williams | North Dakota | 38105 | 21 | 0 |
147099 | 147099 | 2020-05-15 | Williams | North Dakota | 38105 | 21 | 0 |
150106 | 150106 | 2020-05-16 | Williams | North Dakota | 38105 | 21 | 0 |
153117 | 153117 | 2020-05-17 | Williams | North Dakota | 38105 | 21 | 0 |
156134 | 156134 | 2020-05-18 | Williams | North Dakota | 38105 | 21 | 0 |
159154 | 159154 | 2020-05-19 | Williams | North Dakota | 38105 | 21 | 0 |
162181 | 162181 | 2020-05-20 | Williams | North Dakota | 38105 | 22 | 0 |
165210 | 165210 | 2020-05-21 | Williams | North Dakota | 38105 | 22 | 0 |
168246 | 168246 | 2020-05-22 | Williams | North Dakota | 38105 | 25 | 0 |
171285 | 171285 | 2020-05-23 | Williams | North Dakota | 38105 | 25 | 0 |
174327 | 174327 | 2020-05-24 | Williams | North Dakota | 38105 | 25 | 0 |
177371 | 177371 | 2020-05-25 | Williams | North Dakota | 38105 | 25 | 0 |
180414 | 180414 | 2020-05-26 | Williams | North Dakota | 38105 | 24 | 0 |
183463 | 183463 | 2020-05-27 | Williams | North Dakota | 38105 | 24 | 0 |
186520 | 186520 | 2020-05-28 | Williams | North Dakota | 38105 | 24 | 0 |
189580 | 189580 | 2020-05-29 | Williams | North Dakota | 38105 | 24 | 0 |
192644 | 192644 | 2020-05-30 | Williams | North Dakota | 38105 | 25 | 0 |
195714 | 195714 | 2020-05-31 | Williams | North Dakota | 38105 | 25 | 0 |
198787 | 198787 | 2020-06-01 | Williams | North Dakota | 38105 | 25 | 0 |
201862 | 201862 | 2020-06-02 | Williams | North Dakota | 38105 | 25 | 0 |
204939 | 204939 | 2020-06-03 | Williams | North Dakota | 38105 | 25 | 0 |
208020 | 208020 | 2020-06-04 | Williams | North Dakota | 38105 | 25 | 0 |
211102 | 211102 | 2020-06-05 | Williams | North Dakota | 38105 | 25 | 0 |
214188 | 214188 | 2020-06-06 | Williams | North Dakota | 38105 | 25 | 0 |
217278 | 217278 | 2020-06-07 | Williams | North Dakota | 38105 | 25 | 0 |
220370 | 220370 | 2020-06-08 | Williams | North Dakota | 38105 | 25 | 0 |
223465 | 223465 | 2020-06-09 | Williams | North Dakota | 38105 | 25 | 0 |
226565 | 226565 | 2020-06-10 | Williams | North Dakota | 38105 | 25 | 0 |
229669 | 229669 | 2020-06-11 | Williams | North Dakota | 38105 | 26 | 0 |
232774 | 232774 | 2020-06-12 | Williams | North Dakota | 38105 | 26 | 0 |
235879 | 235879 | 2020-06-13 | Williams | North Dakota | 38105 | 26 | 0 |
238987 | 238987 | 2020-06-14 | Williams | North Dakota | 38105 | 26 | 0 |
242096 | 242096 | 2020-06-15 | Williams | North Dakota | 38105 | 26 | 0 |
245208 | 245208 | 2020-06-16 | Williams | North Dakota | 38105 | 26 | 0 |
248321 | 248321 | 2020-06-17 | Williams | North Dakota | 38105 | 26 | 0 |
251436 | 251436 | 2020-06-18 | Williams | North Dakota | 38105 | 26 | 0 |
254551 | 254551 | 2020-06-19 | Williams | North Dakota | 38105 | 26 | 0 |
257676 | 257676 | 2020-06-20 | Williams | North Dakota | 38105 | 26 | 0 |
260803 | 260803 | 2020-06-21 | Williams | North Dakota | 38105 | 26 | 0 |
263931 | 263931 | 2020-06-22 | Williams | North Dakota | 38105 | 26 | 0 |
267059 | 267059 | 2020-06-23 | Williams | North Dakota | 38105 | 26 | 0 |
270193 | 270193 | 2020-06-24 | Williams | North Dakota | 38105 | 26 | 0 |
273332 | 273332 | 2020-06-25 | Williams | North Dakota | 38105 | 28 | 0 |
276479 | 276479 | 2020-06-26 | Williams | North Dakota | 38105 | 29 | 0 |
279627 | 279627 | 2020-06-27 | Williams | North Dakota | 38105 | 29 | 0 |
282773 | 282773 | 2020-06-28 | Williams | North Dakota | 38105 | 32 | 0 |
285918 | 285918 | 2020-06-29 | Williams | North Dakota | 38105 | 32 | 0 |
289068 | 289068 | 2020-06-30 | Williams | North Dakota | 38105 | 32 | 0 |
292220 | 292220 | 2020-07-01 | Williams | North Dakota | 38105 | 37 | 0 |
295375 | 295375 | 2020-07-02 | Williams | North Dakota | 38105 | 37 | 0 |
298535 | 298535 | 2020-07-03 | Williams | North Dakota | 38105 | 38 | 0 |
301698 | 301698 | 2020-07-04 | Williams | North Dakota | 38105 | 39 | 0 |
304861 | 304861 | 2020-07-05 | Williams | North Dakota | 38105 | 43 | 0 |
308028 | 308028 | 2020-07-06 | Williams | North Dakota | 38105 | 43 | 0 |
311197 | 311197 | 2020-07-07 | Williams | North Dakota | 38105 | 50 | 0 |
314369 | 314369 | 2020-07-08 | Williams | North Dakota | 38105 | 53 | 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);