ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Slope" 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 |
---|---|---|---|---|---|---|---|
29928 | 29928 | 2020-04-03 | Slope | North Dakota | 38087 | 1 | 0 |
32316 | 32316 | 2020-04-04 | Slope | North Dakota | 38087 | 1 | 0 |
34749 | 34749 | 2020-04-05 | Slope | North Dakota | 38087 | 1 | 0 |
37218 | 37218 | 2020-04-06 | Slope | North Dakota | 38087 | 2 | 0 |
39735 | 39735 | 2020-04-07 | Slope | North Dakota | 38087 | 3 | 0 |
42292 | 42292 | 2020-04-08 | Slope | North Dakota | 38087 | 3 | 0 |
44877 | 44877 | 2020-04-09 | Slope | North Dakota | 38087 | 3 | 0 |
47491 | 47491 | 2020-04-10 | Slope | North Dakota | 38087 | 3 | 0 |
50147 | 50147 | 2020-04-11 | Slope | North Dakota | 38087 | 3 | 0 |
52820 | 52820 | 2020-04-12 | Slope | North Dakota | 38087 | 3 | 0 |
55504 | 55504 | 2020-04-13 | Slope | North Dakota | 38087 | 3 | 0 |
58205 | 58205 | 2020-04-14 | Slope | North Dakota | 38087 | 3 | 0 |
60919 | 60919 | 2020-04-15 | Slope | North Dakota | 38087 | 3 | 0 |
63645 | 63645 | 2020-04-16 | Slope | North Dakota | 38087 | 3 | 0 |
66388 | 66388 | 2020-04-17 | Slope | North Dakota | 38087 | 3 | 0 |
69145 | 69145 | 2020-04-18 | Slope | North Dakota | 38087 | 3 | 0 |
71912 | 71912 | 2020-04-19 | Slope | North Dakota | 38087 | 3 | 0 |
74687 | 74687 | 2020-04-20 | Slope | North Dakota | 38087 | 3 | 0 |
77468 | 77468 | 2020-04-21 | Slope | North Dakota | 38087 | 3 | 0 |
80257 | 80257 | 2020-04-22 | Slope | North Dakota | 38087 | 3 | 0 |
83056 | 83056 | 2020-04-23 | Slope | North Dakota | 38087 | 3 | 0 |
85860 | 85860 | 2020-04-24 | Slope | North Dakota | 38087 | 3 | 0 |
88674 | 88674 | 2020-04-25 | Slope | North Dakota | 38087 | 3 | 0 |
91490 | 91490 | 2020-04-26 | Slope | North Dakota | 38087 | 3 | 0 |
94316 | 94316 | 2020-04-27 | Slope | North Dakota | 38087 | 3 | 0 |
97153 | 97153 | 2020-04-28 | Slope | North Dakota | 38087 | 3 | 0 |
100002 | 100002 | 2020-04-29 | Slope | North Dakota | 38087 | 3 | 0 |
102855 | 102855 | 2020-04-30 | Slope | North Dakota | 38087 | 3 | 0 |
105718 | 105718 | 2020-05-01 | Slope | North Dakota | 38087 | 3 | 0 |
108585 | 108585 | 2020-05-02 | Slope | North Dakota | 38087 | 3 | 0 |
111459 | 111459 | 2020-05-03 | Slope | North Dakota | 38087 | 3 | 0 |
114340 | 114340 | 2020-05-04 | Slope | North Dakota | 38087 | 3 | 0 |
117221 | 117221 | 2020-05-05 | Slope | North Dakota | 38087 | 3 | 0 |
120182 | 120182 | 2020-05-06 | Slope | North Dakota | 38087 | 3 | 0 |
123158 | 123158 | 2020-05-07 | Slope | North Dakota | 38087 | 3 | 0 |
126141 | 126141 | 2020-05-08 | Slope | North Dakota | 38087 | 3 | 0 |
129130 | 129130 | 2020-05-09 | Slope | North Dakota | 38087 | 3 | 0 |
132119 | 132119 | 2020-05-10 | Slope | North Dakota | 38087 | 3 | 0 |
135110 | 135110 | 2020-05-11 | Slope | North Dakota | 38087 | 3 | 0 |
138100 | 138100 | 2020-05-12 | Slope | North Dakota | 38087 | 3 | 0 |
141096 | 141096 | 2020-05-13 | Slope | North Dakota | 38087 | 3 | 0 |
144091 | 144091 | 2020-05-14 | Slope | North Dakota | 38087 | 3 | 0 |
147092 | 147092 | 2020-05-15 | Slope | North Dakota | 38087 | 3 | 0 |
150099 | 150099 | 2020-05-16 | Slope | North Dakota | 38087 | 3 | 0 |
153109 | 153109 | 2020-05-17 | Slope | North Dakota | 38087 | 3 | 0 |
156126 | 156126 | 2020-05-18 | Slope | North Dakota | 38087 | 3 | 0 |
159146 | 159146 | 2020-05-19 | Slope | North Dakota | 38087 | 3 | 0 |
162173 | 162173 | 2020-05-20 | Slope | North Dakota | 38087 | 3 | 0 |
165202 | 165202 | 2020-05-21 | Slope | North Dakota | 38087 | 3 | 0 |
168238 | 168238 | 2020-05-22 | Slope | North Dakota | 38087 | 3 | 0 |
171277 | 171277 | 2020-05-23 | Slope | North Dakota | 38087 | 3 | 0 |
174319 | 174319 | 2020-05-24 | Slope | North Dakota | 38087 | 3 | 0 |
177363 | 177363 | 2020-05-25 | Slope | North Dakota | 38087 | 3 | 0 |
180406 | 180406 | 2020-05-26 | Slope | North Dakota | 38087 | 3 | 0 |
183454 | 183454 | 2020-05-27 | Slope | North Dakota | 38087 | 3 | 0 |
186511 | 186511 | 2020-05-28 | Slope | North Dakota | 38087 | 3 | 0 |
189571 | 189571 | 2020-05-29 | Slope | North Dakota | 38087 | 3 | 0 |
192635 | 192635 | 2020-05-30 | Slope | North Dakota | 38087 | 3 | 0 |
195705 | 195705 | 2020-05-31 | Slope | North Dakota | 38087 | 3 | 0 |
198778 | 198778 | 2020-06-01 | Slope | North Dakota | 38087 | 3 | 0 |
201853 | 201853 | 2020-06-02 | Slope | North Dakota | 38087 | 3 | 0 |
204930 | 204930 | 2020-06-03 | Slope | North Dakota | 38087 | 3 | 0 |
208011 | 208011 | 2020-06-04 | Slope | North Dakota | 38087 | 3 | 0 |
211093 | 211093 | 2020-06-05 | Slope | North Dakota | 38087 | 3 | 0 |
214179 | 214179 | 2020-06-06 | Slope | North Dakota | 38087 | 3 | 0 |
217269 | 217269 | 2020-06-07 | Slope | North Dakota | 38087 | 3 | 0 |
220361 | 220361 | 2020-06-08 | Slope | North Dakota | 38087 | 3 | 0 |
223456 | 223456 | 2020-06-09 | Slope | North Dakota | 38087 | 3 | 0 |
226556 | 226556 | 2020-06-10 | Slope | North Dakota | 38087 | 3 | 0 |
229660 | 229660 | 2020-06-11 | Slope | North Dakota | 38087 | 3 | 0 |
232765 | 232765 | 2020-06-12 | Slope | North Dakota | 38087 | 3 | 0 |
235870 | 235870 | 2020-06-13 | Slope | North Dakota | 38087 | 3 | 0 |
238978 | 238978 | 2020-06-14 | Slope | North Dakota | 38087 | 3 | 0 |
242087 | 242087 | 2020-06-15 | Slope | North Dakota | 38087 | 3 | 0 |
245199 | 245199 | 2020-06-16 | Slope | North Dakota | 38087 | 3 | 0 |
248312 | 248312 | 2020-06-17 | Slope | North Dakota | 38087 | 3 | 0 |
251427 | 251427 | 2020-06-18 | Slope | North Dakota | 38087 | 3 | 0 |
254542 | 254542 | 2020-06-19 | Slope | North Dakota | 38087 | 3 | 0 |
257667 | 257667 | 2020-06-20 | Slope | North Dakota | 38087 | 3 | 0 |
260794 | 260794 | 2020-06-21 | Slope | North Dakota | 38087 | 3 | 0 |
263922 | 263922 | 2020-06-22 | Slope | North Dakota | 38087 | 3 | 0 |
267050 | 267050 | 2020-06-23 | Slope | North Dakota | 38087 | 3 | 0 |
270184 | 270184 | 2020-06-24 | Slope | North Dakota | 38087 | 3 | 0 |
273323 | 273323 | 2020-06-25 | Slope | North Dakota | 38087 | 3 | 0 |
276470 | 276470 | 2020-06-26 | Slope | North Dakota | 38087 | 3 | 0 |
279618 | 279618 | 2020-06-27 | Slope | North Dakota | 38087 | 3 | 0 |
282764 | 282764 | 2020-06-28 | Slope | North Dakota | 38087 | 3 | 0 |
285909 | 285909 | 2020-06-29 | Slope | North Dakota | 38087 | 3 | 0 |
289059 | 289059 | 2020-06-30 | Slope | North Dakota | 38087 | 3 | 0 |
292211 | 292211 | 2020-07-01 | Slope | North Dakota | 38087 | 3 | 0 |
295366 | 295366 | 2020-07-02 | Slope | North Dakota | 38087 | 3 | 0 |
298526 | 298526 | 2020-07-03 | Slope | North Dakota | 38087 | 3 | 0 |
301689 | 301689 | 2020-07-04 | Slope | North Dakota | 38087 | 3 | 0 |
304852 | 304852 | 2020-07-05 | Slope | North Dakota | 38087 | 3 | 0 |
308019 | 308019 | 2020-07-06 | Slope | North Dakota | 38087 | 3 | 0 |
311187 | 311187 | 2020-07-07 | Slope | North Dakota | 38087 | 3 | 0 |
314359 | 314359 | 2020-07-08 | Slope | North Dakota | 38087 | 3 | 0 |
317532 | 317532 | 2020-07-09 | Slope | North Dakota | 38087 | 3 | 0 |
320709 | 320709 | 2020-07-10 | Slope | North Dakota | 38087 | 3 | 0 |
323889 | 323889 | 2020-07-11 | Slope | North Dakota | 38087 | 3 | 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);