ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 38071 and state = "North Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5785 | 5785 | 2020-03-20 | Ramsey | North Dakota | 38071 | 1 | 0 |
6782 | 6782 | 2020-03-21 | Ramsey | North Dakota | 38071 | 1 | 0 |
7888 | 7888 | 2020-03-22 | Ramsey | North Dakota | 38071 | 1 | 0 |
9090 | 9090 | 2020-03-23 | Ramsey | North Dakota | 38071 | 1 | 0 |
10402 | 10402 | 2020-03-24 | Ramsey | North Dakota | 38071 | 1 | 0 |
11848 | 11848 | 2020-03-25 | Ramsey | North Dakota | 38071 | 3 | 0 |
13454 | 13454 | 2020-03-26 | Ramsey | North Dakota | 38071 | 3 | 0 |
15191 | 15191 | 2020-03-27 | Ramsey | North Dakota | 38071 | 3 | 0 |
17029 | 17029 | 2020-03-28 | Ramsey | North Dakota | 38071 | 3 | 0 |
18963 | 18963 | 2020-03-29 | Ramsey | North Dakota | 38071 | 3 | 0 |
21006 | 21006 | 2020-03-30 | Ramsey | North Dakota | 38071 | 3 | 0 |
23137 | 23137 | 2020-03-31 | Ramsey | North Dakota | 38071 | 3 | 0 |
25332 | 25332 | 2020-04-01 | Ramsey | North Dakota | 38071 | 3 | 0 |
27598 | 27598 | 2020-04-02 | Ramsey | North Dakota | 38071 | 3 | 0 |
29926 | 29926 | 2020-04-03 | Ramsey | North Dakota | 38071 | 3 | 0 |
32314 | 32314 | 2020-04-04 | Ramsey | North Dakota | 38071 | 3 | 0 |
34747 | 34747 | 2020-04-05 | Ramsey | North Dakota | 38071 | 3 | 0 |
37216 | 37216 | 2020-04-06 | Ramsey | North Dakota | 38071 | 3 | 0 |
39733 | 39733 | 2020-04-07 | Ramsey | North Dakota | 38071 | 3 | 0 |
42290 | 42290 | 2020-04-08 | Ramsey | North Dakota | 38071 | 3 | 0 |
44874 | 44874 | 2020-04-09 | Ramsey | North Dakota | 38071 | 3 | 0 |
47487 | 47487 | 2020-04-10 | Ramsey | North Dakota | 38071 | 3 | 0 |
50142 | 50142 | 2020-04-11 | Ramsey | North Dakota | 38071 | 3 | 0 |
52815 | 52815 | 2020-04-12 | Ramsey | North Dakota | 38071 | 3 | 0 |
55499 | 55499 | 2020-04-13 | Ramsey | North Dakota | 38071 | 3 | 0 |
58200 | 58200 | 2020-04-14 | Ramsey | North Dakota | 38071 | 3 | 0 |
60914 | 60914 | 2020-04-15 | Ramsey | North Dakota | 38071 | 3 | 0 |
63640 | 63640 | 2020-04-16 | Ramsey | North Dakota | 38071 | 3 | 0 |
66383 | 66383 | 2020-04-17 | Ramsey | North Dakota | 38071 | 3 | 0 |
69140 | 69140 | 2020-04-18 | Ramsey | North Dakota | 38071 | 3 | 0 |
71907 | 71907 | 2020-04-19 | Ramsey | North Dakota | 38071 | 3 | 0 |
74682 | 74682 | 2020-04-20 | Ramsey | North Dakota | 38071 | 3 | 0 |
77463 | 77463 | 2020-04-21 | Ramsey | North Dakota | 38071 | 3 | 0 |
80252 | 80252 | 2020-04-22 | Ramsey | North Dakota | 38071 | 3 | 0 |
83051 | 83051 | 2020-04-23 | Ramsey | North Dakota | 38071 | 3 | 0 |
85855 | 85855 | 2020-04-24 | Ramsey | North Dakota | 38071 | 3 | 0 |
88669 | 88669 | 2020-04-25 | Ramsey | North Dakota | 38071 | 3 | 0 |
91484 | 91484 | 2020-04-26 | Ramsey | North Dakota | 38071 | 3 | 0 |
94310 | 94310 | 2020-04-27 | Ramsey | North Dakota | 38071 | 4 | 0 |
97147 | 97147 | 2020-04-28 | Ramsey | North Dakota | 38071 | 4 | 0 |
99996 | 99996 | 2020-04-29 | Ramsey | North Dakota | 38071 | 3 | 0 |
102849 | 102849 | 2020-04-30 | Ramsey | North Dakota | 38071 | 3 | 0 |
105711 | 105711 | 2020-05-01 | Ramsey | North Dakota | 38071 | 3 | 0 |
108578 | 108578 | 2020-05-02 | Ramsey | North Dakota | 38071 | 3 | 0 |
111452 | 111452 | 2020-05-03 | Ramsey | North Dakota | 38071 | 3 | 0 |
114333 | 114333 | 2020-05-04 | Ramsey | North Dakota | 38071 | 3 | 0 |
117214 | 117214 | 2020-05-05 | Ramsey | North Dakota | 38071 | 3 | 0 |
120175 | 120175 | 2020-05-06 | Ramsey | North Dakota | 38071 | 3 | 0 |
123151 | 123151 | 2020-05-07 | Ramsey | North Dakota | 38071 | 5 | 0 |
126134 | 126134 | 2020-05-08 | Ramsey | North Dakota | 38071 | 5 | 0 |
129123 | 129123 | 2020-05-09 | Ramsey | North Dakota | 38071 | 7 | 0 |
132112 | 132112 | 2020-05-10 | Ramsey | North Dakota | 38071 | 7 | 0 |
135103 | 135103 | 2020-05-11 | Ramsey | North Dakota | 38071 | 7 | 0 |
138093 | 138093 | 2020-05-12 | Ramsey | North Dakota | 38071 | 7 | 0 |
141089 | 141089 | 2020-05-13 | Ramsey | North Dakota | 38071 | 7 | 0 |
144084 | 144084 | 2020-05-14 | Ramsey | North Dakota | 38071 | 7 | 0 |
147085 | 147085 | 2020-05-15 | Ramsey | North Dakota | 38071 | 7 | 0 |
150092 | 150092 | 2020-05-16 | Ramsey | North Dakota | 38071 | 7 | 0 |
153102 | 153102 | 2020-05-17 | Ramsey | North Dakota | 38071 | 7 | 0 |
156119 | 156119 | 2020-05-18 | Ramsey | North Dakota | 38071 | 7 | 1 |
159139 | 159139 | 2020-05-19 | Ramsey | North Dakota | 38071 | 8 | 1 |
162166 | 162166 | 2020-05-20 | Ramsey | North Dakota | 38071 | 8 | 1 |
165195 | 165195 | 2020-05-21 | Ramsey | North Dakota | 38071 | 9 | 1 |
168231 | 168231 | 2020-05-22 | Ramsey | North Dakota | 38071 | 9 | 1 |
171270 | 171270 | 2020-05-23 | Ramsey | North Dakota | 38071 | 9 | 1 |
174312 | 174312 | 2020-05-24 | Ramsey | North Dakota | 38071 | 9 | 1 |
177356 | 177356 | 2020-05-25 | Ramsey | North Dakota | 38071 | 9 | 1 |
180399 | 180399 | 2020-05-26 | Ramsey | North Dakota | 38071 | 8 | 1 |
183447 | 183447 | 2020-05-27 | Ramsey | North Dakota | 38071 | 8 | 1 |
186504 | 186504 | 2020-05-28 | Ramsey | North Dakota | 38071 | 8 | 1 |
189564 | 189564 | 2020-05-29 | Ramsey | North Dakota | 38071 | 8 | 1 |
192628 | 192628 | 2020-05-30 | Ramsey | North Dakota | 38071 | 8 | 1 |
195698 | 195698 | 2020-05-31 | Ramsey | North Dakota | 38071 | 8 | 1 |
198771 | 198771 | 2020-06-01 | Ramsey | North Dakota | 38071 | 8 | 1 |
201846 | 201846 | 2020-06-02 | Ramsey | North Dakota | 38071 | 8 | 1 |
204923 | 204923 | 2020-06-03 | Ramsey | North Dakota | 38071 | 8 | 1 |
208004 | 208004 | 2020-06-04 | Ramsey | North Dakota | 38071 | 8 | 1 |
211086 | 211086 | 2020-06-05 | Ramsey | North Dakota | 38071 | 8 | 1 |
214171 | 214171 | 2020-06-06 | Ramsey | North Dakota | 38071 | 8 | 1 |
217261 | 217261 | 2020-06-07 | Ramsey | North Dakota | 38071 | 8 | 1 |
220353 | 220353 | 2020-06-08 | Ramsey | North Dakota | 38071 | 8 | 1 |
223448 | 223448 | 2020-06-09 | Ramsey | North Dakota | 38071 | 8 | 1 |
226548 | 226548 | 2020-06-10 | Ramsey | North Dakota | 38071 | 8 | 1 |
229652 | 229652 | 2020-06-11 | Ramsey | North Dakota | 38071 | 8 | 1 |
232757 | 232757 | 2020-06-12 | Ramsey | North Dakota | 38071 | 8 | 1 |
235862 | 235862 | 2020-06-13 | Ramsey | North Dakota | 38071 | 8 | 1 |
238970 | 238970 | 2020-06-14 | Ramsey | North Dakota | 38071 | 8 | 1 |
242079 | 242079 | 2020-06-15 | Ramsey | North Dakota | 38071 | 8 | 1 |
245191 | 245191 | 2020-06-16 | Ramsey | North Dakota | 38071 | 8 | 1 |
248304 | 248304 | 2020-06-17 | Ramsey | North Dakota | 38071 | 8 | 1 |
251419 | 251419 | 2020-06-18 | Ramsey | North Dakota | 38071 | 8 | 1 |
254534 | 254534 | 2020-06-19 | Ramsey | North Dakota | 38071 | 8 | 1 |
257659 | 257659 | 2020-06-20 | Ramsey | North Dakota | 38071 | 8 | 1 |
260786 | 260786 | 2020-06-21 | Ramsey | North Dakota | 38071 | 8 | 1 |
263914 | 263914 | 2020-06-22 | Ramsey | North Dakota | 38071 | 9 | 1 |
267042 | 267042 | 2020-06-23 | Ramsey | North Dakota | 38071 | 9 | 1 |
270176 | 270176 | 2020-06-24 | Ramsey | North Dakota | 38071 | 11 | 1 |
273315 | 273315 | 2020-06-25 | Ramsey | North Dakota | 38071 | 10 | 1 |
276462 | 276462 | 2020-06-26 | Ramsey | North Dakota | 38071 | 10 | 1 |
279610 | 279610 | 2020-06-27 | Ramsey | North Dakota | 38071 | 10 | 1 |
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);