ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 38093 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 |
---|---|---|---|---|---|---|---|
42294 | 42294 | 2020-04-08 | Stutsman | North Dakota | 38093 | 1 | 0 |
44879 | 44879 | 2020-04-09 | Stutsman | North Dakota | 38093 | 1 | 0 |
47493 | 47493 | 2020-04-10 | Stutsman | North Dakota | 38093 | 1 | 0 |
50149 | 50149 | 2020-04-11 | Stutsman | North Dakota | 38093 | 1 | 0 |
52822 | 52822 | 2020-04-12 | Stutsman | North Dakota | 38093 | 1 | 0 |
55506 | 55506 | 2020-04-13 | Stutsman | North Dakota | 38093 | 1 | 0 |
58207 | 58207 | 2020-04-14 | Stutsman | North Dakota | 38093 | 1 | 0 |
60921 | 60921 | 2020-04-15 | Stutsman | North Dakota | 38093 | 1 | 0 |
63647 | 63647 | 2020-04-16 | Stutsman | North Dakota | 38093 | 1 | 0 |
66390 | 66390 | 2020-04-17 | Stutsman | North Dakota | 38093 | 1 | 0 |
69147 | 69147 | 2020-04-18 | Stutsman | North Dakota | 38093 | 1 | 0 |
71914 | 71914 | 2020-04-19 | Stutsman | North Dakota | 38093 | 1 | 0 |
74689 | 74689 | 2020-04-20 | Stutsman | North Dakota | 38093 | 3 | 0 |
77470 | 77470 | 2020-04-21 | Stutsman | North Dakota | 38093 | 3 | 0 |
80259 | 80259 | 2020-04-22 | Stutsman | North Dakota | 38093 | 3 | 0 |
83058 | 83058 | 2020-04-23 | Stutsman | North Dakota | 38093 | 3 | 0 |
85862 | 85862 | 2020-04-24 | Stutsman | North Dakota | 38093 | 3 | 0 |
88676 | 88676 | 2020-04-25 | Stutsman | North Dakota | 38093 | 4 | 0 |
91492 | 91492 | 2020-04-26 | Stutsman | North Dakota | 38093 | 4 | 0 |
94318 | 94318 | 2020-04-27 | Stutsman | North Dakota | 38093 | 4 | 0 |
97155 | 97155 | 2020-04-28 | Stutsman | North Dakota | 38093 | 5 | 0 |
100004 | 100004 | 2020-04-29 | Stutsman | North Dakota | 38093 | 6 | 0 |
102857 | 102857 | 2020-04-30 | Stutsman | North Dakota | 38093 | 6 | 0 |
105720 | 105720 | 2020-05-01 | Stutsman | North Dakota | 38093 | 7 | 0 |
108587 | 108587 | 2020-05-02 | Stutsman | North Dakota | 38093 | 10 | 0 |
111461 | 111461 | 2020-05-03 | Stutsman | North Dakota | 38093 | 11 | 0 |
114342 | 114342 | 2020-05-04 | Stutsman | North Dakota | 38093 | 11 | 0 |
117223 | 117223 | 2020-05-05 | Stutsman | North Dakota | 38093 | 12 | 0 |
120184 | 120184 | 2020-05-06 | Stutsman | North Dakota | 38093 | 12 | 0 |
123160 | 123160 | 2020-05-07 | Stutsman | North Dakota | 38093 | 12 | 0 |
126143 | 126143 | 2020-05-08 | Stutsman | North Dakota | 38093 | 12 | 0 |
129132 | 129132 | 2020-05-09 | Stutsman | North Dakota | 38093 | 13 | 0 |
132121 | 132121 | 2020-05-10 | Stutsman | North Dakota | 38093 | 13 | 0 |
135112 | 135112 | 2020-05-11 | Stutsman | North Dakota | 38093 | 15 | 0 |
138102 | 138102 | 2020-05-12 | Stutsman | North Dakota | 38093 | 16 | 0 |
141098 | 141098 | 2020-05-13 | Stutsman | North Dakota | 38093 | 16 | 0 |
144093 | 144093 | 2020-05-14 | Stutsman | North Dakota | 38093 | 16 | 0 |
147094 | 147094 | 2020-05-15 | Stutsman | North Dakota | 38093 | 16 | 0 |
150101 | 150101 | 2020-05-16 | Stutsman | North Dakota | 38093 | 16 | 0 |
153112 | 153112 | 2020-05-17 | Stutsman | North Dakota | 38093 | 16 | 0 |
156129 | 156129 | 2020-05-18 | Stutsman | North Dakota | 38093 | 16 | 0 |
159149 | 159149 | 2020-05-19 | Stutsman | North Dakota | 38093 | 16 | 0 |
162176 | 162176 | 2020-05-20 | Stutsman | North Dakota | 38093 | 17 | 0 |
165205 | 165205 | 2020-05-21 | Stutsman | North Dakota | 38093 | 17 | 0 |
168241 | 168241 | 2020-05-22 | Stutsman | North Dakota | 38093 | 18 | 0 |
171280 | 171280 | 2020-05-23 | Stutsman | North Dakota | 38093 | 18 | 0 |
174322 | 174322 | 2020-05-24 | Stutsman | North Dakota | 38093 | 18 | 0 |
177366 | 177366 | 2020-05-25 | Stutsman | North Dakota | 38093 | 18 | 0 |
180409 | 180409 | 2020-05-26 | Stutsman | North Dakota | 38093 | 18 | 0 |
183457 | 183457 | 2020-05-27 | Stutsman | North Dakota | 38093 | 18 | 0 |
186514 | 186514 | 2020-05-28 | Stutsman | North Dakota | 38093 | 18 | 0 |
189574 | 189574 | 2020-05-29 | Stutsman | North Dakota | 38093 | 22 | 0 |
192638 | 192638 | 2020-05-30 | Stutsman | North Dakota | 38093 | 23 | 0 |
195708 | 195708 | 2020-05-31 | Stutsman | North Dakota | 38093 | 23 | 0 |
198781 | 198781 | 2020-06-01 | Stutsman | North Dakota | 38093 | 24 | 0 |
201856 | 201856 | 2020-06-02 | Stutsman | North Dakota | 38093 | 24 | 0 |
204933 | 204933 | 2020-06-03 | Stutsman | North Dakota | 38093 | 29 | 0 |
208014 | 208014 | 2020-06-04 | Stutsman | North Dakota | 38093 | 29 | 0 |
211096 | 211096 | 2020-06-05 | Stutsman | North Dakota | 38093 | 30 | 0 |
214182 | 214182 | 2020-06-06 | Stutsman | North Dakota | 38093 | 35 | 0 |
217272 | 217272 | 2020-06-07 | Stutsman | North Dakota | 38093 | 42 | 0 |
220364 | 220364 | 2020-06-08 | Stutsman | North Dakota | 38093 | 50 | 0 |
223459 | 223459 | 2020-06-09 | Stutsman | North Dakota | 38093 | 49 | 0 |
226559 | 226559 | 2020-06-10 | Stutsman | North Dakota | 38093 | 51 | 0 |
229663 | 229663 | 2020-06-11 | Stutsman | North Dakota | 38093 | 51 | 0 |
232768 | 232768 | 2020-06-12 | Stutsman | North Dakota | 38093 | 51 | 0 |
235873 | 235873 | 2020-06-13 | Stutsman | North Dakota | 38093 | 51 | 0 |
238981 | 238981 | 2020-06-14 | Stutsman | North Dakota | 38093 | 52 | 0 |
242090 | 242090 | 2020-06-15 | Stutsman | North Dakota | 38093 | 52 | 0 |
245202 | 245202 | 2020-06-16 | Stutsman | North Dakota | 38093 | 52 | 0 |
248315 | 248315 | 2020-06-17 | Stutsman | North Dakota | 38093 | 60 | 0 |
251430 | 251430 | 2020-06-18 | Stutsman | North Dakota | 38093 | 60 | 0 |
254545 | 254545 | 2020-06-19 | Stutsman | North Dakota | 38093 | 60 | 0 |
257670 | 257670 | 2020-06-20 | Stutsman | North Dakota | 38093 | 60 | 0 |
260797 | 260797 | 2020-06-21 | Stutsman | North Dakota | 38093 | 62 | 1 |
263925 | 263925 | 2020-06-22 | Stutsman | North Dakota | 38093 | 62 | 1 |
267053 | 267053 | 2020-06-23 | Stutsman | North Dakota | 38093 | 62 | 1 |
270187 | 270187 | 2020-06-24 | Stutsman | North Dakota | 38093 | 62 | 1 |
273326 | 273326 | 2020-06-25 | Stutsman | North Dakota | 38093 | 62 | 1 |
276473 | 276473 | 2020-06-26 | Stutsman | North Dakota | 38093 | 63 | 1 |
279621 | 279621 | 2020-06-27 | Stutsman | North Dakota | 38093 | 63 | 1 |
282767 | 282767 | 2020-06-28 | Stutsman | North Dakota | 38093 | 63 | 1 |
285912 | 285912 | 2020-06-29 | Stutsman | North Dakota | 38093 | 63 | 1 |
289062 | 289062 | 2020-06-30 | Stutsman | North Dakota | 38093 | 63 | 1 |
292214 | 292214 | 2020-07-01 | Stutsman | North Dakota | 38093 | 63 | 1 |
295369 | 295369 | 2020-07-02 | Stutsman | North Dakota | 38093 | 63 | 1 |
298529 | 298529 | 2020-07-03 | Stutsman | North Dakota | 38093 | 63 | 1 |
301692 | 301692 | 2020-07-04 | Stutsman | North Dakota | 38093 | 63 | 1 |
304855 | 304855 | 2020-07-05 | Stutsman | North Dakota | 38093 | 64 | 1 |
308022 | 308022 | 2020-07-06 | Stutsman | North Dakota | 38093 | 65 | 1 |
311190 | 311190 | 2020-07-07 | Stutsman | North Dakota | 38093 | 65 | 2 |
314362 | 314362 | 2020-07-08 | Stutsman | North Dakota | 38093 | 65 | 2 |
317535 | 317535 | 2020-07-09 | Stutsman | North Dakota | 38093 | 66 | 2 |
320712 | 320712 | 2020-07-10 | Stutsman | North Dakota | 38093 | 66 | 2 |
323892 | 323892 | 2020-07-11 | Stutsman | North Dakota | 38093 | 66 | 2 |
327077 | 327077 | 2020-07-12 | Stutsman | North Dakota | 38093 | 66 | 2 |
330264 | 330264 | 2020-07-13 | Stutsman | North Dakota | 38093 | 68 | 2 |
333455 | 333455 | 2020-07-14 | Stutsman | North Dakota | 38093 | 69 | 2 |
336649 | 336649 | 2020-07-15 | Stutsman | North Dakota | 38093 | 69 | 2 |
339845 | 339845 | 2020-07-16 | Stutsman | North Dakota | 38093 | 71 | 2 |
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);