ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "McLean" and state = "North Dakota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17025 | 17025 | 2020-03-28 | McLean | North Dakota | 38055 | 2 | 0 |
18959 | 18959 | 2020-03-29 | McLean | North Dakota | 38055 | 2 | 0 |
21001 | 21001 | 2020-03-30 | McLean | North Dakota | 38055 | 2 | 0 |
23132 | 23132 | 2020-03-31 | McLean | North Dakota | 38055 | 2 | 0 |
25327 | 25327 | 2020-04-01 | McLean | North Dakota | 38055 | 2 | 0 |
27593 | 27593 | 2020-04-02 | McLean | North Dakota | 38055 | 2 | 0 |
29921 | 29921 | 2020-04-03 | McLean | North Dakota | 38055 | 2 | 0 |
32309 | 32309 | 2020-04-04 | McLean | North Dakota | 38055 | 2 | 0 |
34742 | 34742 | 2020-04-05 | McLean | North Dakota | 38055 | 2 | 0 |
37211 | 37211 | 2020-04-06 | McLean | North Dakota | 38055 | 2 | 0 |
39728 | 39728 | 2020-04-07 | McLean | North Dakota | 38055 | 2 | 0 |
42285 | 42285 | 2020-04-08 | McLean | North Dakota | 38055 | 2 | 0 |
44869 | 44869 | 2020-04-09 | McLean | North Dakota | 38055 | 2 | 0 |
47482 | 47482 | 2020-04-10 | McLean | North Dakota | 38055 | 2 | 0 |
50137 | 50137 | 2020-04-11 | McLean | North Dakota | 38055 | 2 | 0 |
52810 | 52810 | 2020-04-12 | McLean | North Dakota | 38055 | 2 | 0 |
55494 | 55494 | 2020-04-13 | McLean | North Dakota | 38055 | 2 | 0 |
58195 | 58195 | 2020-04-14 | McLean | North Dakota | 38055 | 2 | 0 |
60909 | 60909 | 2020-04-15 | McLean | North Dakota | 38055 | 3 | 0 |
63635 | 63635 | 2020-04-16 | McLean | North Dakota | 38055 | 3 | 0 |
66378 | 66378 | 2020-04-17 | McLean | North Dakota | 38055 | 3 | 0 |
69135 | 69135 | 2020-04-18 | McLean | North Dakota | 38055 | 3 | 0 |
71901 | 71901 | 2020-04-19 | McLean | North Dakota | 38055 | 3 | 0 |
74676 | 74676 | 2020-04-20 | McLean | North Dakota | 38055 | 3 | 0 |
77457 | 77457 | 2020-04-21 | McLean | North Dakota | 38055 | 3 | 0 |
80246 | 80246 | 2020-04-22 | McLean | North Dakota | 38055 | 3 | 0 |
83045 | 83045 | 2020-04-23 | McLean | North Dakota | 38055 | 3 | 0 |
85849 | 85849 | 2020-04-24 | McLean | North Dakota | 38055 | 3 | 0 |
88662 | 88662 | 2020-04-25 | McLean | North Dakota | 38055 | 3 | 0 |
91477 | 91477 | 2020-04-26 | McLean | North Dakota | 38055 | 3 | 0 |
94303 | 94303 | 2020-04-27 | McLean | North Dakota | 38055 | 3 | 0 |
97140 | 97140 | 2020-04-28 | McLean | North Dakota | 38055 | 3 | 0 |
99989 | 99989 | 2020-04-29 | McLean | North Dakota | 38055 | 3 | 0 |
102842 | 102842 | 2020-04-30 | McLean | North Dakota | 38055 | 3 | 0 |
105704 | 105704 | 2020-05-01 | McLean | North Dakota | 38055 | 3 | 0 |
108571 | 108571 | 2020-05-02 | McLean | North Dakota | 38055 | 5 | 0 |
111445 | 111445 | 2020-05-03 | McLean | North Dakota | 38055 | 5 | 0 |
114326 | 114326 | 2020-05-04 | McLean | North Dakota | 38055 | 5 | 0 |
117206 | 117206 | 2020-05-05 | McLean | North Dakota | 38055 | 5 | 0 |
120167 | 120167 | 2020-05-06 | McLean | North Dakota | 38055 | 5 | 0 |
123143 | 123143 | 2020-05-07 | McLean | North Dakota | 38055 | 5 | 0 |
126126 | 126126 | 2020-05-08 | McLean | North Dakota | 38055 | 5 | 0 |
129115 | 129115 | 2020-05-09 | McLean | North Dakota | 38055 | 5 | 0 |
132104 | 132104 | 2020-05-10 | McLean | North Dakota | 38055 | 5 | 0 |
135095 | 135095 | 2020-05-11 | McLean | North Dakota | 38055 | 5 | 0 |
138085 | 138085 | 2020-05-12 | McLean | North Dakota | 38055 | 5 | 0 |
141081 | 141081 | 2020-05-13 | McLean | North Dakota | 38055 | 5 | 0 |
144076 | 144076 | 2020-05-14 | McLean | North Dakota | 38055 | 5 | 0 |
147077 | 147077 | 2020-05-15 | McLean | North Dakota | 38055 | 5 | 0 |
150084 | 150084 | 2020-05-16 | McLean | North Dakota | 38055 | 5 | 0 |
153094 | 153094 | 2020-05-17 | McLean | North Dakota | 38055 | 6 | 0 |
156111 | 156111 | 2020-05-18 | McLean | North Dakota | 38055 | 6 | 0 |
159131 | 159131 | 2020-05-19 | McLean | North Dakota | 38055 | 7 | 0 |
162158 | 162158 | 2020-05-20 | McLean | North Dakota | 38055 | 7 | 0 |
165187 | 165187 | 2020-05-21 | McLean | North Dakota | 38055 | 7 | 0 |
168223 | 168223 | 2020-05-22 | McLean | North Dakota | 38055 | 7 | 0 |
171262 | 171262 | 2020-05-23 | McLean | North Dakota | 38055 | 7 | 0 |
174304 | 174304 | 2020-05-24 | McLean | North Dakota | 38055 | 7 | 0 |
177348 | 177348 | 2020-05-25 | McLean | North Dakota | 38055 | 7 | 0 |
180391 | 180391 | 2020-05-26 | McLean | North Dakota | 38055 | 7 | 0 |
183439 | 183439 | 2020-05-27 | McLean | North Dakota | 38055 | 7 | 0 |
186496 | 186496 | 2020-05-28 | McLean | North Dakota | 38055 | 7 | 0 |
189556 | 189556 | 2020-05-29 | McLean | North Dakota | 38055 | 7 | 0 |
192620 | 192620 | 2020-05-30 | McLean | North Dakota | 38055 | 7 | 0 |
195690 | 195690 | 2020-05-31 | McLean | North Dakota | 38055 | 7 | 0 |
198763 | 198763 | 2020-06-01 | McLean | North Dakota | 38055 | 7 | 0 |
201838 | 201838 | 2020-06-02 | McLean | North Dakota | 38055 | 7 | 0 |
204915 | 204915 | 2020-06-03 | McLean | North Dakota | 38055 | 7 | 0 |
207996 | 207996 | 2020-06-04 | McLean | North Dakota | 38055 | 7 | 0 |
211078 | 211078 | 2020-06-05 | McLean | North Dakota | 38055 | 7 | 0 |
214163 | 214163 | 2020-06-06 | McLean | North Dakota | 38055 | 7 | 0 |
217253 | 217253 | 2020-06-07 | McLean | North Dakota | 38055 | 7 | 0 |
220345 | 220345 | 2020-06-08 | McLean | North Dakota | 38055 | 7 | 0 |
223440 | 223440 | 2020-06-09 | McLean | North Dakota | 38055 | 8 | 0 |
226540 | 226540 | 2020-06-10 | McLean | North Dakota | 38055 | 8 | 0 |
229644 | 229644 | 2020-06-11 | McLean | North Dakota | 38055 | 8 | 0 |
232749 | 232749 | 2020-06-12 | McLean | North Dakota | 38055 | 9 | 0 |
235854 | 235854 | 2020-06-13 | McLean | North Dakota | 38055 | 9 | 0 |
238962 | 238962 | 2020-06-14 | McLean | North Dakota | 38055 | 10 | 0 |
242071 | 242071 | 2020-06-15 | McLean | North Dakota | 38055 | 10 | 0 |
245183 | 245183 | 2020-06-16 | McLean | North Dakota | 38055 | 11 | 0 |
248296 | 248296 | 2020-06-17 | McLean | North Dakota | 38055 | 11 | 0 |
251411 | 251411 | 2020-06-18 | McLean | North Dakota | 38055 | 11 | 0 |
254526 | 254526 | 2020-06-19 | McLean | North Dakota | 38055 | 11 | 0 |
257651 | 257651 | 2020-06-20 | McLean | North Dakota | 38055 | 11 | 0 |
260778 | 260778 | 2020-06-21 | McLean | North Dakota | 38055 | 11 | 0 |
263906 | 263906 | 2020-06-22 | McLean | North Dakota | 38055 | 11 | 0 |
267034 | 267034 | 2020-06-23 | McLean | North Dakota | 38055 | 11 | 0 |
270168 | 270168 | 2020-06-24 | McLean | North Dakota | 38055 | 11 | 0 |
273307 | 273307 | 2020-06-25 | McLean | North Dakota | 38055 | 11 | 0 |
276454 | 276454 | 2020-06-26 | McLean | North Dakota | 38055 | 11 | 0 |
279602 | 279602 | 2020-06-27 | McLean | North Dakota | 38055 | 11 | 0 |
282748 | 282748 | 2020-06-28 | McLean | North Dakota | 38055 | 11 | 0 |
285893 | 285893 | 2020-06-29 | McLean | North Dakota | 38055 | 11 | 0 |
289043 | 289043 | 2020-06-30 | McLean | North Dakota | 38055 | 11 | 0 |
292195 | 292195 | 2020-07-01 | McLean | North Dakota | 38055 | 11 | 0 |
295350 | 295350 | 2020-07-02 | McLean | North Dakota | 38055 | 11 | 0 |
298510 | 298510 | 2020-07-03 | McLean | North Dakota | 38055 | 11 | 0 |
301673 | 301673 | 2020-07-04 | McLean | North Dakota | 38055 | 11 | 0 |
304836 | 304836 | 2020-07-05 | McLean | North Dakota | 38055 | 11 | 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);