ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
715 rows where county = "Kingsbury" and state = "South 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 |
---|---|---|---|---|---|---|---|
190002 | 190002 | 2020-05-29 | Kingsbury | South Dakota | 46077 | 1 | 0 |
193067 | 193067 | 2020-05-30 | Kingsbury | South Dakota | 46077 | 1 | 0 |
196137 | 196137 | 2020-05-31 | Kingsbury | South Dakota | 46077 | 1 | 0 |
199210 | 199210 | 2020-06-01 | Kingsbury | South Dakota | 46077 | 1 | 0 |
202285 | 202285 | 2020-06-02 | Kingsbury | South Dakota | 46077 | 2 | 0 |
205364 | 205364 | 2020-06-03 | Kingsbury | South Dakota | 46077 | 3 | 0 |
208446 | 208446 | 2020-06-04 | Kingsbury | South Dakota | 46077 | 3 | 0 |
211528 | 211528 | 2020-06-05 | Kingsbury | South Dakota | 46077 | 3 | 0 |
214615 | 214615 | 2020-06-06 | Kingsbury | South Dakota | 46077 | 4 | 0 |
217705 | 217705 | 2020-06-07 | Kingsbury | South Dakota | 46077 | 5 | 0 |
220797 | 220797 | 2020-06-08 | Kingsbury | South Dakota | 46077 | 5 | 0 |
223892 | 223892 | 2020-06-09 | Kingsbury | South Dakota | 46077 | 5 | 0 |
226992 | 226992 | 2020-06-10 | Kingsbury | South Dakota | 46077 | 5 | 0 |
230096 | 230096 | 2020-06-11 | Kingsbury | South Dakota | 46077 | 5 | 0 |
233201 | 233201 | 2020-06-12 | Kingsbury | South Dakota | 46077 | 5 | 0 |
236306 | 236306 | 2020-06-13 | Kingsbury | South Dakota | 46077 | 5 | 0 |
239414 | 239414 | 2020-06-14 | Kingsbury | South Dakota | 46077 | 5 | 0 |
242524 | 242524 | 2020-06-15 | Kingsbury | South Dakota | 46077 | 5 | 0 |
245636 | 245636 | 2020-06-16 | Kingsbury | South Dakota | 46077 | 5 | 0 |
248749 | 248749 | 2020-06-17 | Kingsbury | South Dakota | 46077 | 5 | 0 |
251864 | 251864 | 2020-06-18 | Kingsbury | South Dakota | 46077 | 3 | 0 |
254979 | 254979 | 2020-06-19 | Kingsbury | South Dakota | 46077 | 3 | 0 |
258105 | 258105 | 2020-06-20 | Kingsbury | South Dakota | 46077 | 4 | 0 |
261232 | 261232 | 2020-06-21 | Kingsbury | South Dakota | 46077 | 5 | 0 |
264360 | 264360 | 2020-06-22 | Kingsbury | South Dakota | 46077 | 5 | 0 |
267488 | 267488 | 2020-06-23 | Kingsbury | South Dakota | 46077 | 5 | 0 |
270622 | 270622 | 2020-06-24 | Kingsbury | South Dakota | 46077 | 6 | 0 |
273761 | 273761 | 2020-06-25 | Kingsbury | South Dakota | 46077 | 6 | 0 |
276908 | 276908 | 2020-06-26 | Kingsbury | South Dakota | 46077 | 6 | 0 |
280056 | 280056 | 2020-06-27 | Kingsbury | South Dakota | 46077 | 6 | 0 |
283202 | 283202 | 2020-06-28 | Kingsbury | South Dakota | 46077 | 6 | 0 |
286347 | 286347 | 2020-06-29 | Kingsbury | South Dakota | 46077 | 6 | 0 |
289498 | 289498 | 2020-06-30 | Kingsbury | South Dakota | 46077 | 6 | 0 |
292650 | 292650 | 2020-07-01 | Kingsbury | South Dakota | 46077 | 6 | 0 |
295806 | 295806 | 2020-07-02 | Kingsbury | South Dakota | 46077 | 6 | 0 |
298966 | 298966 | 2020-07-03 | Kingsbury | South Dakota | 46077 | 6 | 0 |
302130 | 302130 | 2020-07-04 | Kingsbury | South Dakota | 46077 | 6 | 0 |
305293 | 305293 | 2020-07-05 | Kingsbury | South Dakota | 46077 | 6 | 0 |
308461 | 308461 | 2020-07-06 | Kingsbury | South Dakota | 46077 | 6 | 0 |
311630 | 311630 | 2020-07-07 | Kingsbury | South Dakota | 46077 | 6 | 0 |
314804 | 314804 | 2020-07-08 | Kingsbury | South Dakota | 46077 | 6 | 0 |
317977 | 317977 | 2020-07-09 | Kingsbury | South Dakota | 46077 | 6 | 0 |
321155 | 321155 | 2020-07-10 | Kingsbury | South Dakota | 46077 | 6 | 0 |
324335 | 324335 | 2020-07-11 | Kingsbury | South Dakota | 46077 | 6 | 0 |
327520 | 327520 | 2020-07-12 | Kingsbury | South Dakota | 46077 | 8 | 0 |
330706 | 330706 | 2020-07-13 | Kingsbury | South Dakota | 46077 | 8 | 0 |
333898 | 333898 | 2020-07-14 | Kingsbury | South Dakota | 46077 | 8 | 0 |
337092 | 337092 | 2020-07-15 | Kingsbury | South Dakota | 46077 | 8 | 0 |
340289 | 340289 | 2020-07-16 | Kingsbury | South Dakota | 46077 | 8 | 0 |
343487 | 343487 | 2020-07-17 | Kingsbury | South Dakota | 46077 | 8 | 0 |
346687 | 346687 | 2020-07-18 | Kingsbury | South Dakota | 46077 | 8 | 0 |
349887 | 349887 | 2020-07-19 | Kingsbury | South Dakota | 46077 | 8 | 0 |
353090 | 353090 | 2020-07-20 | Kingsbury | South Dakota | 46077 | 8 | 0 |
356293 | 356293 | 2020-07-21 | Kingsbury | South Dakota | 46077 | 8 | 0 |
359497 | 359497 | 2020-07-22 | Kingsbury | South Dakota | 46077 | 8 | 0 |
362703 | 362703 | 2020-07-23 | Kingsbury | South Dakota | 46077 | 9 | 0 |
365909 | 365909 | 2020-07-24 | Kingsbury | South Dakota | 46077 | 9 | 0 |
369118 | 369118 | 2020-07-25 | Kingsbury | South Dakota | 46077 | 10 | 0 |
372330 | 372330 | 2020-07-26 | Kingsbury | South Dakota | 46077 | 10 | 0 |
375543 | 375543 | 2020-07-27 | Kingsbury | South Dakota | 46077 | 11 | 0 |
378759 | 378759 | 2020-07-28 | Kingsbury | South Dakota | 46077 | 11 | 0 |
381976 | 381976 | 2020-07-29 | Kingsbury | South Dakota | 46077 | 11 | 0 |
385194 | 385194 | 2020-07-30 | Kingsbury | South Dakota | 46077 | 11 | 0 |
388411 | 388411 | 2020-07-31 | Kingsbury | South Dakota | 46077 | 12 | 0 |
391628 | 391628 | 2020-08-01 | Kingsbury | South Dakota | 46077 | 12 | 0 |
394844 | 394844 | 2020-08-02 | Kingsbury | South Dakota | 46077 | 12 | 0 |
398061 | 398061 | 2020-08-03 | Kingsbury | South Dakota | 46077 | 14 | 0 |
401276 | 401276 | 2020-08-04 | Kingsbury | South Dakota | 46077 | 14 | 0 |
404494 | 404494 | 2020-08-05 | Kingsbury | South Dakota | 46077 | 14 | 0 |
407714 | 407714 | 2020-08-06 | Kingsbury | South Dakota | 46077 | 14 | 0 |
410933 | 410933 | 2020-08-07 | Kingsbury | South Dakota | 46077 | 14 | 0 |
414153 | 414153 | 2020-08-08 | Kingsbury | South Dakota | 46077 | 14 | 0 |
417374 | 417374 | 2020-08-09 | Kingsbury | South Dakota | 46077 | 14 | 0 |
420595 | 420595 | 2020-08-10 | Kingsbury | South Dakota | 46077 | 14 | 0 |
423817 | 423817 | 2020-08-11 | Kingsbury | South Dakota | 46077 | 14 | 0 |
427040 | 427040 | 2020-08-12 | Kingsbury | South Dakota | 46077 | 14 | 0 |
430267 | 430267 | 2020-08-13 | Kingsbury | South Dakota | 46077 | 14 | 0 |
433492 | 433492 | 2020-08-14 | Kingsbury | South Dakota | 46077 | 14 | 0 |
436719 | 436719 | 2020-08-15 | Kingsbury | South Dakota | 46077 | 14 | 0 |
439944 | 439944 | 2020-08-16 | Kingsbury | South Dakota | 46077 | 15 | 0 |
443171 | 443171 | 2020-08-17 | Kingsbury | South Dakota | 46077 | 15 | 0 |
446397 | 446397 | 2020-08-18 | Kingsbury | South Dakota | 46077 | 15 | 0 |
449625 | 449625 | 2020-08-19 | Kingsbury | South Dakota | 46077 | 15 | 0 |
452853 | 452853 | 2020-08-20 | Kingsbury | South Dakota | 46077 | 16 | 0 |
456081 | 456081 | 2020-08-21 | Kingsbury | South Dakota | 46077 | 17 | 0 |
459309 | 459309 | 2020-08-22 | Kingsbury | South Dakota | 46077 | 17 | 0 |
462537 | 462537 | 2020-08-23 | Kingsbury | South Dakota | 46077 | 18 | 0 |
465766 | 465766 | 2020-08-24 | Kingsbury | South Dakota | 46077 | 18 | 0 |
468994 | 468994 | 2020-08-25 | Kingsbury | South Dakota | 46077 | 18 | 0 |
472226 | 472226 | 2020-08-26 | Kingsbury | South Dakota | 46077 | 18 | 0 |
475460 | 475460 | 2020-08-27 | Kingsbury | South Dakota | 46077 | 21 | 0 |
478693 | 478693 | 2020-08-28 | Kingsbury | South Dakota | 46077 | 21 | 0 |
481927 | 481927 | 2020-08-29 | Kingsbury | South Dakota | 46077 | 21 | 0 |
485162 | 485162 | 2020-08-30 | Kingsbury | South Dakota | 46077 | 23 | 0 |
488395 | 488395 | 2020-08-31 | Kingsbury | South Dakota | 46077 | 23 | 0 |
491628 | 491628 | 2020-09-01 | Kingsbury | South Dakota | 46077 | 23 | 0 |
494862 | 494862 | 2020-09-02 | Kingsbury | South Dakota | 46077 | 23 | 0 |
498095 | 498095 | 2020-09-03 | Kingsbury | South Dakota | 46077 | 24 | 0 |
501329 | 501329 | 2020-09-04 | Kingsbury | South Dakota | 46077 | 25 | 0 |
504563 | 504563 | 2020-09-05 | Kingsbury | South Dakota | 46077 | 24 | 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);