ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Sargent" 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 |
---|---|---|---|---|---|---|---|
47489 | 47489 | 2020-04-10 | Sargent | North Dakota | 38081 | 1 | 0 |
50145 | 50145 | 2020-04-11 | Sargent | North Dakota | 38081 | 1 | 0 |
52818 | 52818 | 2020-04-12 | Sargent | North Dakota | 38081 | 1 | 0 |
55502 | 55502 | 2020-04-13 | Sargent | North Dakota | 38081 | 1 | 0 |
58203 | 58203 | 2020-04-14 | Sargent | North Dakota | 38081 | 1 | 0 |
60917 | 60917 | 2020-04-15 | Sargent | North Dakota | 38081 | 1 | 0 |
63643 | 63643 | 2020-04-16 | Sargent | North Dakota | 38081 | 1 | 0 |
66386 | 66386 | 2020-04-17 | Sargent | North Dakota | 38081 | 1 | 0 |
69143 | 69143 | 2020-04-18 | Sargent | North Dakota | 38081 | 1 | 0 |
71910 | 71910 | 2020-04-19 | Sargent | North Dakota | 38081 | 1 | 0 |
74685 | 74685 | 2020-04-20 | Sargent | North Dakota | 38081 | 1 | 0 |
77466 | 77466 | 2020-04-21 | Sargent | North Dakota | 38081 | 1 | 0 |
80255 | 80255 | 2020-04-22 | Sargent | North Dakota | 38081 | 1 | 0 |
83054 | 83054 | 2020-04-23 | Sargent | North Dakota | 38081 | 1 | 0 |
85858 | 85858 | 2020-04-24 | Sargent | North Dakota | 38081 | 1 | 0 |
88672 | 88672 | 2020-04-25 | Sargent | North Dakota | 38081 | 1 | 0 |
91488 | 91488 | 2020-04-26 | Sargent | North Dakota | 38081 | 1 | 0 |
94314 | 94314 | 2020-04-27 | Sargent | North Dakota | 38081 | 1 | 0 |
97151 | 97151 | 2020-04-28 | Sargent | North Dakota | 38081 | 1 | 0 |
100000 | 100000 | 2020-04-29 | Sargent | North Dakota | 38081 | 1 | 0 |
102853 | 102853 | 2020-04-30 | Sargent | North Dakota | 38081 | 1 | 0 |
105716 | 105716 | 2020-05-01 | Sargent | North Dakota | 38081 | 1 | 0 |
108583 | 108583 | 2020-05-02 | Sargent | North Dakota | 38081 | 1 | 0 |
111457 | 111457 | 2020-05-03 | Sargent | North Dakota | 38081 | 1 | 0 |
114338 | 114338 | 2020-05-04 | Sargent | North Dakota | 38081 | 1 | 0 |
117219 | 117219 | 2020-05-05 | Sargent | North Dakota | 38081 | 1 | 0 |
120180 | 120180 | 2020-05-06 | Sargent | North Dakota | 38081 | 2 | 0 |
123156 | 123156 | 2020-05-07 | Sargent | North Dakota | 38081 | 3 | 0 |
126139 | 126139 | 2020-05-08 | Sargent | North Dakota | 38081 | 3 | 0 |
129128 | 129128 | 2020-05-09 | Sargent | North Dakota | 38081 | 3 | 0 |
132117 | 132117 | 2020-05-10 | Sargent | North Dakota | 38081 | 3 | 0 |
135108 | 135108 | 2020-05-11 | Sargent | North Dakota | 38081 | 3 | 0 |
138098 | 138098 | 2020-05-12 | Sargent | North Dakota | 38081 | 3 | 0 |
141094 | 141094 | 2020-05-13 | Sargent | North Dakota | 38081 | 3 | 0 |
144089 | 144089 | 2020-05-14 | Sargent | North Dakota | 38081 | 3 | 0 |
147090 | 147090 | 2020-05-15 | Sargent | North Dakota | 38081 | 3 | 0 |
150097 | 150097 | 2020-05-16 | Sargent | North Dakota | 38081 | 3 | 0 |
153107 | 153107 | 2020-05-17 | Sargent | North Dakota | 38081 | 3 | 0 |
156124 | 156124 | 2020-05-18 | Sargent | North Dakota | 38081 | 3 | 0 |
159144 | 159144 | 2020-05-19 | Sargent | North Dakota | 38081 | 3 | 0 |
162171 | 162171 | 2020-05-20 | Sargent | North Dakota | 38081 | 3 | 0 |
165200 | 165200 | 2020-05-21 | Sargent | North Dakota | 38081 | 3 | 0 |
168236 | 168236 | 2020-05-22 | Sargent | North Dakota | 38081 | 3 | 0 |
171275 | 171275 | 2020-05-23 | Sargent | North Dakota | 38081 | 3 | 0 |
174317 | 174317 | 2020-05-24 | Sargent | North Dakota | 38081 | 3 | 0 |
177361 | 177361 | 2020-05-25 | Sargent | North Dakota | 38081 | 3 | 0 |
180404 | 180404 | 2020-05-26 | Sargent | North Dakota | 38081 | 3 | 0 |
183452 | 183452 | 2020-05-27 | Sargent | North Dakota | 38081 | 3 | 0 |
186509 | 186509 | 2020-05-28 | Sargent | North Dakota | 38081 | 3 | 0 |
189569 | 189569 | 2020-05-29 | Sargent | North Dakota | 38081 | 3 | 0 |
192633 | 192633 | 2020-05-30 | Sargent | North Dakota | 38081 | 3 | 0 |
195703 | 195703 | 2020-05-31 | Sargent | North Dakota | 38081 | 3 | 0 |
198776 | 198776 | 2020-06-01 | Sargent | North Dakota | 38081 | 3 | 0 |
201851 | 201851 | 2020-06-02 | Sargent | North Dakota | 38081 | 3 | 0 |
204928 | 204928 | 2020-06-03 | Sargent | North Dakota | 38081 | 3 | 0 |
208009 | 208009 | 2020-06-04 | Sargent | North Dakota | 38081 | 4 | 0 |
211091 | 211091 | 2020-06-05 | Sargent | North Dakota | 38081 | 4 | 0 |
214176 | 214176 | 2020-06-06 | Sargent | North Dakota | 38081 | 4 | 0 |
217266 | 217266 | 2020-06-07 | Sargent | North Dakota | 38081 | 4 | 0 |
220358 | 220358 | 2020-06-08 | Sargent | North Dakota | 38081 | 4 | 0 |
223453 | 223453 | 2020-06-09 | Sargent | North Dakota | 38081 | 4 | 0 |
226553 | 226553 | 2020-06-10 | Sargent | North Dakota | 38081 | 4 | 0 |
229657 | 229657 | 2020-06-11 | Sargent | North Dakota | 38081 | 4 | 0 |
232762 | 232762 | 2020-06-12 | Sargent | North Dakota | 38081 | 4 | 0 |
235867 | 235867 | 2020-06-13 | Sargent | North Dakota | 38081 | 4 | 0 |
238975 | 238975 | 2020-06-14 | Sargent | North Dakota | 38081 | 4 | 0 |
242084 | 242084 | 2020-06-15 | Sargent | North Dakota | 38081 | 4 | 0 |
245196 | 245196 | 2020-06-16 | Sargent | North Dakota | 38081 | 4 | 0 |
248309 | 248309 | 2020-06-17 | Sargent | North Dakota | 38081 | 4 | 0 |
251424 | 251424 | 2020-06-18 | Sargent | North Dakota | 38081 | 5 | 0 |
254539 | 254539 | 2020-06-19 | Sargent | North Dakota | 38081 | 4 | 0 |
257664 | 257664 | 2020-06-20 | Sargent | North Dakota | 38081 | 4 | 0 |
260791 | 260791 | 2020-06-21 | Sargent | North Dakota | 38081 | 4 | 0 |
263919 | 263919 | 2020-06-22 | Sargent | North Dakota | 38081 | 4 | 0 |
267047 | 267047 | 2020-06-23 | Sargent | North Dakota | 38081 | 4 | 0 |
270181 | 270181 | 2020-06-24 | Sargent | North Dakota | 38081 | 4 | 0 |
273320 | 273320 | 2020-06-25 | Sargent | North Dakota | 38081 | 5 | 0 |
276467 | 276467 | 2020-06-26 | Sargent | North Dakota | 38081 | 6 | 0 |
279615 | 279615 | 2020-06-27 | Sargent | North Dakota | 38081 | 6 | 0 |
282761 | 282761 | 2020-06-28 | Sargent | North Dakota | 38081 | 6 | 0 |
285906 | 285906 | 2020-06-29 | Sargent | North Dakota | 38081 | 6 | 0 |
289056 | 289056 | 2020-06-30 | Sargent | North Dakota | 38081 | 6 | 0 |
292208 | 292208 | 2020-07-01 | Sargent | North Dakota | 38081 | 6 | 0 |
295363 | 295363 | 2020-07-02 | Sargent | North Dakota | 38081 | 6 | 0 |
298523 | 298523 | 2020-07-03 | Sargent | North Dakota | 38081 | 6 | 0 |
301686 | 301686 | 2020-07-04 | Sargent | North Dakota | 38081 | 6 | 0 |
304849 | 304849 | 2020-07-05 | Sargent | North Dakota | 38081 | 6 | 0 |
308016 | 308016 | 2020-07-06 | Sargent | North Dakota | 38081 | 6 | 0 |
311184 | 311184 | 2020-07-07 | Sargent | North Dakota | 38081 | 7 | 0 |
314356 | 314356 | 2020-07-08 | Sargent | North Dakota | 38081 | 7 | 0 |
317529 | 317529 | 2020-07-09 | Sargent | North Dakota | 38081 | 7 | 0 |
320706 | 320706 | 2020-07-10 | Sargent | North Dakota | 38081 | 7 | 0 |
323886 | 323886 | 2020-07-11 | Sargent | North Dakota | 38081 | 7 | 0 |
327071 | 327071 | 2020-07-12 | Sargent | North Dakota | 38081 | 8 | 0 |
330258 | 330258 | 2020-07-13 | Sargent | North Dakota | 38081 | 8 | 0 |
333449 | 333449 | 2020-07-14 | Sargent | North Dakota | 38081 | 8 | 0 |
336643 | 336643 | 2020-07-15 | Sargent | North Dakota | 38081 | 8 | 0 |
339839 | 339839 | 2020-07-16 | Sargent | North Dakota | 38081 | 8 | 0 |
343037 | 343037 | 2020-07-17 | Sargent | North Dakota | 38081 | 9 | 0 |
346236 | 346236 | 2020-07-18 | Sargent | North Dakota | 38081 | 8 | 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);