ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38053 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 |
---|---|---|---|---|---|---|---|
23131 | 23131 | 2020-03-31 | McKenzie | North Dakota | 38053 | 1 | 0 |
25326 | 25326 | 2020-04-01 | McKenzie | North Dakota | 38053 | 2 | 0 |
27592 | 27592 | 2020-04-02 | McKenzie | North Dakota | 38053 | 2 | 0 |
29920 | 29920 | 2020-04-03 | McKenzie | North Dakota | 38053 | 2 | 0 |
32308 | 32308 | 2020-04-04 | McKenzie | North Dakota | 38053 | 2 | 0 |
34741 | 34741 | 2020-04-05 | McKenzie | North Dakota | 38053 | 3 | 0 |
37210 | 37210 | 2020-04-06 | McKenzie | North Dakota | 38053 | 3 | 0 |
39727 | 39727 | 2020-04-07 | McKenzie | North Dakota | 38053 | 5 | 0 |
42284 | 42284 | 2020-04-08 | McKenzie | North Dakota | 38053 | 5 | 0 |
44868 | 44868 | 2020-04-09 | McKenzie | North Dakota | 38053 | 6 | 0 |
47481 | 47481 | 2020-04-10 | McKenzie | North Dakota | 38053 | 6 | 0 |
50136 | 50136 | 2020-04-11 | McKenzie | North Dakota | 38053 | 6 | 0 |
52809 | 52809 | 2020-04-12 | McKenzie | North Dakota | 38053 | 6 | 0 |
55493 | 55493 | 2020-04-13 | McKenzie | North Dakota | 38053 | 8 | 0 |
58194 | 58194 | 2020-04-14 | McKenzie | North Dakota | 38053 | 8 | 0 |
60908 | 60908 | 2020-04-15 | McKenzie | North Dakota | 38053 | 9 | 0 |
63634 | 63634 | 2020-04-16 | McKenzie | North Dakota | 38053 | 10 | 0 |
66377 | 66377 | 2020-04-17 | McKenzie | North Dakota | 38053 | 10 | 0 |
69134 | 69134 | 2020-04-18 | McKenzie | North Dakota | 38053 | 10 | 0 |
71900 | 71900 | 2020-04-19 | McKenzie | North Dakota | 38053 | 10 | 0 |
74675 | 74675 | 2020-04-20 | McKenzie | North Dakota | 38053 | 10 | 0 |
77456 | 77456 | 2020-04-21 | McKenzie | North Dakota | 38053 | 10 | 0 |
80245 | 80245 | 2020-04-22 | McKenzie | North Dakota | 38053 | 10 | 0 |
83044 | 83044 | 2020-04-23 | McKenzie | North Dakota | 38053 | 10 | 0 |
85848 | 85848 | 2020-04-24 | McKenzie | North Dakota | 38053 | 10 | 0 |
88661 | 88661 | 2020-04-25 | McKenzie | North Dakota | 38053 | 12 | 0 |
91476 | 91476 | 2020-04-26 | McKenzie | North Dakota | 38053 | 12 | 0 |
94302 | 94302 | 2020-04-27 | McKenzie | North Dakota | 38053 | 12 | 0 |
97139 | 97139 | 2020-04-28 | McKenzie | North Dakota | 38053 | 12 | 0 |
99988 | 99988 | 2020-04-29 | McKenzie | North Dakota | 38053 | 13 | 0 |
102841 | 102841 | 2020-04-30 | McKenzie | North Dakota | 38053 | 13 | 0 |
105703 | 105703 | 2020-05-01 | McKenzie | North Dakota | 38053 | 13 | 0 |
108570 | 108570 | 2020-05-02 | McKenzie | North Dakota | 38053 | 13 | 0 |
111444 | 111444 | 2020-05-03 | McKenzie | North Dakota | 38053 | 13 | 0 |
114325 | 114325 | 2020-05-04 | McKenzie | North Dakota | 38053 | 13 | 0 |
117205 | 117205 | 2020-05-05 | McKenzie | North Dakota | 38053 | 13 | 0 |
120166 | 120166 | 2020-05-06 | McKenzie | North Dakota | 38053 | 13 | 0 |
123142 | 123142 | 2020-05-07 | McKenzie | North Dakota | 38053 | 15 | 0 |
126125 | 126125 | 2020-05-08 | McKenzie | North Dakota | 38053 | 15 | 0 |
129114 | 129114 | 2020-05-09 | McKenzie | North Dakota | 38053 | 15 | 0 |
132103 | 132103 | 2020-05-10 | McKenzie | North Dakota | 38053 | 15 | 0 |
135094 | 135094 | 2020-05-11 | McKenzie | North Dakota | 38053 | 15 | 0 |
138084 | 138084 | 2020-05-12 | McKenzie | North Dakota | 38053 | 15 | 0 |
141080 | 141080 | 2020-05-13 | McKenzie | North Dakota | 38053 | 15 | 0 |
144075 | 144075 | 2020-05-14 | McKenzie | North Dakota | 38053 | 15 | 0 |
147076 | 147076 | 2020-05-15 | McKenzie | North Dakota | 38053 | 15 | 0 |
150083 | 150083 | 2020-05-16 | McKenzie | North Dakota | 38053 | 15 | 0 |
153093 | 153093 | 2020-05-17 | McKenzie | North Dakota | 38053 | 15 | 0 |
156110 | 156110 | 2020-05-18 | McKenzie | North Dakota | 38053 | 15 | 0 |
159130 | 159130 | 2020-05-19 | McKenzie | North Dakota | 38053 | 16 | 0 |
162157 | 162157 | 2020-05-20 | McKenzie | North Dakota | 38053 | 16 | 0 |
165186 | 165186 | 2020-05-21 | McKenzie | North Dakota | 38053 | 16 | 0 |
168222 | 168222 | 2020-05-22 | McKenzie | North Dakota | 38053 | 16 | 0 |
171261 | 171261 | 2020-05-23 | McKenzie | North Dakota | 38053 | 16 | 0 |
174303 | 174303 | 2020-05-24 | McKenzie | North Dakota | 38053 | 16 | 0 |
177347 | 177347 | 2020-05-25 | McKenzie | North Dakota | 38053 | 16 | 0 |
180390 | 180390 | 2020-05-26 | McKenzie | North Dakota | 38053 | 16 | 0 |
183438 | 183438 | 2020-05-27 | McKenzie | North Dakota | 38053 | 16 | 0 |
186495 | 186495 | 2020-05-28 | McKenzie | North Dakota | 38053 | 16 | 0 |
189555 | 189555 | 2020-05-29 | McKenzie | North Dakota | 38053 | 16 | 0 |
192619 | 192619 | 2020-05-30 | McKenzie | North Dakota | 38053 | 17 | 0 |
195689 | 195689 | 2020-05-31 | McKenzie | North Dakota | 38053 | 17 | 0 |
198762 | 198762 | 2020-06-01 | McKenzie | North Dakota | 38053 | 17 | 0 |
201837 | 201837 | 2020-06-02 | McKenzie | North Dakota | 38053 | 17 | 0 |
204914 | 204914 | 2020-06-03 | McKenzie | North Dakota | 38053 | 17 | 0 |
207995 | 207995 | 2020-06-04 | McKenzie | North Dakota | 38053 | 17 | 0 |
211077 | 211077 | 2020-06-05 | McKenzie | North Dakota | 38053 | 18 | 0 |
214162 | 214162 | 2020-06-06 | McKenzie | North Dakota | 38053 | 18 | 0 |
217252 | 217252 | 2020-06-07 | McKenzie | North Dakota | 38053 | 18 | 0 |
220344 | 220344 | 2020-06-08 | McKenzie | North Dakota | 38053 | 18 | 0 |
223439 | 223439 | 2020-06-09 | McKenzie | North Dakota | 38053 | 18 | 0 |
226539 | 226539 | 2020-06-10 | McKenzie | North Dakota | 38053 | 18 | 0 |
229643 | 229643 | 2020-06-11 | McKenzie | North Dakota | 38053 | 21 | 0 |
232748 | 232748 | 2020-06-12 | McKenzie | North Dakota | 38053 | 21 | 0 |
235853 | 235853 | 2020-06-13 | McKenzie | North Dakota | 38053 | 21 | 0 |
238961 | 238961 | 2020-06-14 | McKenzie | North Dakota | 38053 | 21 | 0 |
242070 | 242070 | 2020-06-15 | McKenzie | North Dakota | 38053 | 21 | 0 |
245182 | 245182 | 2020-06-16 | McKenzie | North Dakota | 38053 | 21 | 0 |
248295 | 248295 | 2020-06-17 | McKenzie | North Dakota | 38053 | 22 | 0 |
251410 | 251410 | 2020-06-18 | McKenzie | North Dakota | 38053 | 22 | 0 |
254525 | 254525 | 2020-06-19 | McKenzie | North Dakota | 38053 | 23 | 0 |
257650 | 257650 | 2020-06-20 | McKenzie | North Dakota | 38053 | 24 | 0 |
260777 | 260777 | 2020-06-21 | McKenzie | North Dakota | 38053 | 24 | 0 |
263905 | 263905 | 2020-06-22 | McKenzie | North Dakota | 38053 | 24 | 0 |
267033 | 267033 | 2020-06-23 | McKenzie | North Dakota | 38053 | 24 | 0 |
270167 | 270167 | 2020-06-24 | McKenzie | North Dakota | 38053 | 25 | 0 |
273306 | 273306 | 2020-06-25 | McKenzie | North Dakota | 38053 | 27 | 0 |
276453 | 276453 | 2020-06-26 | McKenzie | North Dakota | 38053 | 27 | 0 |
279601 | 279601 | 2020-06-27 | McKenzie | North Dakota | 38053 | 27 | 0 |
282747 | 282747 | 2020-06-28 | McKenzie | North Dakota | 38053 | 27 | 0 |
285892 | 285892 | 2020-06-29 | McKenzie | North Dakota | 38053 | 27 | 0 |
289042 | 289042 | 2020-06-30 | McKenzie | North Dakota | 38053 | 27 | 0 |
292194 | 292194 | 2020-07-01 | McKenzie | North Dakota | 38053 | 27 | 0 |
295349 | 295349 | 2020-07-02 | McKenzie | North Dakota | 38053 | 27 | 0 |
298509 | 298509 | 2020-07-03 | McKenzie | North Dakota | 38053 | 27 | 0 |
301672 | 301672 | 2020-07-04 | McKenzie | North Dakota | 38053 | 27 | 0 |
304835 | 304835 | 2020-07-05 | McKenzie | North Dakota | 38053 | 27 | 0 |
308002 | 308002 | 2020-07-06 | McKenzie | North Dakota | 38053 | 27 | 0 |
311170 | 311170 | 2020-07-07 | McKenzie | North Dakota | 38053 | 28 | 0 |
314342 | 314342 | 2020-07-08 | McKenzie | North Dakota | 38053 | 29 | 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);