ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 38027 and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
29914 | 29914 | 2020-04-03 | Eddy | North Dakota | 38027 | 1 | 0 |
32302 | 32302 | 2020-04-04 | Eddy | North Dakota | 38027 | 1 | 0 |
34734 | 34734 | 2020-04-05 | Eddy | North Dakota | 38027 | 1 | 0 |
37203 | 37203 | 2020-04-06 | Eddy | North Dakota | 38027 | 1 | 0 |
39720 | 39720 | 2020-04-07 | Eddy | North Dakota | 38027 | 1 | 0 |
42277 | 42277 | 2020-04-08 | Eddy | North Dakota | 38027 | 1 | 0 |
44861 | 44861 | 2020-04-09 | Eddy | North Dakota | 38027 | 1 | 0 |
47474 | 47474 | 2020-04-10 | Eddy | North Dakota | 38027 | 1 | 0 |
50129 | 50129 | 2020-04-11 | Eddy | North Dakota | 38027 | 1 | 0 |
52802 | 52802 | 2020-04-12 | Eddy | North Dakota | 38027 | 1 | 0 |
55486 | 55486 | 2020-04-13 | Eddy | North Dakota | 38027 | 1 | 0 |
58187 | 58187 | 2020-04-14 | Eddy | North Dakota | 38027 | 1 | 0 |
60901 | 60901 | 2020-04-15 | Eddy | North Dakota | 38027 | 1 | 0 |
63627 | 63627 | 2020-04-16 | Eddy | North Dakota | 38027 | 1 | 0 |
66370 | 66370 | 2020-04-17 | Eddy | North Dakota | 38027 | 1 | 0 |
69127 | 69127 | 2020-04-18 | Eddy | North Dakota | 38027 | 1 | 0 |
71893 | 71893 | 2020-04-19 | Eddy | North Dakota | 38027 | 1 | 0 |
74668 | 74668 | 2020-04-20 | Eddy | North Dakota | 38027 | 1 | 0 |
77449 | 77449 | 2020-04-21 | Eddy | North Dakota | 38027 | 1 | 0 |
80238 | 80238 | 2020-04-22 | Eddy | North Dakota | 38027 | 1 | 0 |
83037 | 83037 | 2020-04-23 | Eddy | North Dakota | 38027 | 1 | 0 |
85841 | 85841 | 2020-04-24 | Eddy | North Dakota | 38027 | 1 | 0 |
88654 | 88654 | 2020-04-25 | Eddy | North Dakota | 38027 | 1 | 0 |
91469 | 91469 | 2020-04-26 | Eddy | North Dakota | 38027 | 1 | 0 |
94295 | 94295 | 2020-04-27 | Eddy | North Dakota | 38027 | 1 | 0 |
97132 | 97132 | 2020-04-28 | Eddy | North Dakota | 38027 | 1 | 0 |
99981 | 99981 | 2020-04-29 | Eddy | North Dakota | 38027 | 1 | 0 |
102834 | 102834 | 2020-04-30 | Eddy | North Dakota | 38027 | 1 | 0 |
105696 | 105696 | 2020-05-01 | Eddy | North Dakota | 38027 | 1 | 0 |
108563 | 108563 | 2020-05-02 | Eddy | North Dakota | 38027 | 1 | 0 |
111437 | 111437 | 2020-05-03 | Eddy | North Dakota | 38027 | 1 | 0 |
114318 | 114318 | 2020-05-04 | Eddy | North Dakota | 38027 | 1 | 0 |
117198 | 117198 | 2020-05-05 | Eddy | North Dakota | 38027 | 1 | 0 |
120159 | 120159 | 2020-05-06 | Eddy | North Dakota | 38027 | 1 | 0 |
123135 | 123135 | 2020-05-07 | Eddy | North Dakota | 38027 | 1 | 0 |
126118 | 126118 | 2020-05-08 | Eddy | North Dakota | 38027 | 1 | 0 |
129107 | 129107 | 2020-05-09 | Eddy | North Dakota | 38027 | 1 | 0 |
132096 | 132096 | 2020-05-10 | Eddy | North Dakota | 38027 | 1 | 0 |
135087 | 135087 | 2020-05-11 | Eddy | North Dakota | 38027 | 2 | 0 |
138077 | 138077 | 2020-05-12 | Eddy | North Dakota | 38027 | 2 | 0 |
141073 | 141073 | 2020-05-13 | Eddy | North Dakota | 38027 | 2 | 0 |
144068 | 144068 | 2020-05-14 | Eddy | North Dakota | 38027 | 2 | 0 |
147069 | 147069 | 2020-05-15 | Eddy | North Dakota | 38027 | 2 | 0 |
150076 | 150076 | 2020-05-16 | Eddy | North Dakota | 38027 | 2 | 0 |
153086 | 153086 | 2020-05-17 | Eddy | North Dakota | 38027 | 2 | 0 |
156103 | 156103 | 2020-05-18 | Eddy | North Dakota | 38027 | 2 | 0 |
159123 | 159123 | 2020-05-19 | Eddy | North Dakota | 38027 | 2 | 0 |
162150 | 162150 | 2020-05-20 | Eddy | North Dakota | 38027 | 2 | 0 |
165179 | 165179 | 2020-05-21 | Eddy | North Dakota | 38027 | 2 | 0 |
168214 | 168214 | 2020-05-22 | Eddy | North Dakota | 38027 | 8 | 0 |
171253 | 171253 | 2020-05-23 | Eddy | North Dakota | 38027 | 7 | 0 |
174295 | 174295 | 2020-05-24 | Eddy | North Dakota | 38027 | 7 | 0 |
177339 | 177339 | 2020-05-25 | Eddy | North Dakota | 38027 | 7 | 0 |
180382 | 180382 | 2020-05-26 | Eddy | North Dakota | 38027 | 4 | 0 |
183430 | 183430 | 2020-05-27 | Eddy | North Dakota | 38027 | 4 | 0 |
186487 | 186487 | 2020-05-28 | Eddy | North Dakota | 38027 | 4 | 0 |
189547 | 189547 | 2020-05-29 | Eddy | North Dakota | 38027 | 4 | 0 |
192611 | 192611 | 2020-05-30 | Eddy | North Dakota | 38027 | 4 | 0 |
195681 | 195681 | 2020-05-31 | Eddy | North Dakota | 38027 | 4 | 0 |
198754 | 198754 | 2020-06-01 | Eddy | North Dakota | 38027 | 4 | 0 |
201829 | 201829 | 2020-06-02 | Eddy | North Dakota | 38027 | 4 | 0 |
204906 | 204906 | 2020-06-03 | Eddy | North Dakota | 38027 | 4 | 0 |
207987 | 207987 | 2020-06-04 | Eddy | North Dakota | 38027 | 4 | 0 |
211069 | 211069 | 2020-06-05 | Eddy | North Dakota | 38027 | 4 | 0 |
214153 | 214153 | 2020-06-06 | Eddy | North Dakota | 38027 | 4 | 0 |
217243 | 217243 | 2020-06-07 | Eddy | North Dakota | 38027 | 5 | 0 |
220335 | 220335 | 2020-06-08 | Eddy | North Dakota | 38027 | 5 | 0 |
223429 | 223429 | 2020-06-09 | Eddy | North Dakota | 38027 | 5 | 0 |
226529 | 226529 | 2020-06-10 | Eddy | North Dakota | 38027 | 5 | 0 |
229633 | 229633 | 2020-06-11 | Eddy | North Dakota | 38027 | 5 | 0 |
232738 | 232738 | 2020-06-12 | Eddy | North Dakota | 38027 | 5 | 0 |
235843 | 235843 | 2020-06-13 | Eddy | North Dakota | 38027 | 5 | 0 |
238951 | 238951 | 2020-06-14 | Eddy | North Dakota | 38027 | 5 | 0 |
242060 | 242060 | 2020-06-15 | Eddy | North Dakota | 38027 | 5 | 0 |
245172 | 245172 | 2020-06-16 | Eddy | North Dakota | 38027 | 5 | 0 |
248285 | 248285 | 2020-06-17 | Eddy | North Dakota | 38027 | 5 | 0 |
251400 | 251400 | 2020-06-18 | Eddy | North Dakota | 38027 | 5 | 0 |
254515 | 254515 | 2020-06-19 | Eddy | North Dakota | 38027 | 5 | 0 |
257640 | 257640 | 2020-06-20 | Eddy | North Dakota | 38027 | 5 | 0 |
260767 | 260767 | 2020-06-21 | Eddy | North Dakota | 38027 | 5 | 0 |
263895 | 263895 | 2020-06-22 | Eddy | North Dakota | 38027 | 5 | 0 |
267023 | 267023 | 2020-06-23 | Eddy | North Dakota | 38027 | 5 | 0 |
270157 | 270157 | 2020-06-24 | Eddy | North Dakota | 38027 | 5 | 0 |
273296 | 273296 | 2020-06-25 | Eddy | North Dakota | 38027 | 5 | 0 |
276442 | 276442 | 2020-06-26 | Eddy | North Dakota | 38027 | 5 | 0 |
279590 | 279590 | 2020-06-27 | Eddy | North Dakota | 38027 | 5 | 0 |
282736 | 282736 | 2020-06-28 | Eddy | North Dakota | 38027 | 5 | 0 |
285881 | 285881 | 2020-06-29 | Eddy | North Dakota | 38027 | 5 | 0 |
289031 | 289031 | 2020-06-30 | Eddy | North Dakota | 38027 | 5 | 0 |
292183 | 292183 | 2020-07-01 | Eddy | North Dakota | 38027 | 5 | 0 |
295338 | 295338 | 2020-07-02 | Eddy | North Dakota | 38027 | 5 | 0 |
298498 | 298498 | 2020-07-03 | Eddy | North Dakota | 38027 | 5 | 0 |
301661 | 301661 | 2020-07-04 | Eddy | North Dakota | 38027 | 5 | 0 |
304824 | 304824 | 2020-07-05 | Eddy | North Dakota | 38027 | 5 | 0 |
307991 | 307991 | 2020-07-06 | Eddy | North Dakota | 38027 | 5 | 0 |
311159 | 311159 | 2020-07-07 | Eddy | North Dakota | 38027 | 5 | 0 |
314330 | 314330 | 2020-07-08 | Eddy | North Dakota | 38027 | 5 | 0 |
317504 | 317504 | 2020-07-09 | Eddy | North Dakota | 38027 | 5 | 0 |
320681 | 320681 | 2020-07-10 | Eddy | North Dakota | 38027 | 5 | 0 |
323861 | 323861 | 2020-07-11 | Eddy | North Dakota | 38027 | 5 | 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);