ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
701 rows where county = "Custer" and fips = 30017 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
232388 | 232388 | 2020-06-12 | Custer | Montana | 30017 | 1 | 0 |
235494 | 235494 | 2020-06-13 | Custer | Montana | 30017 | 3 | 0 |
238601 | 238601 | 2020-06-14 | Custer | Montana | 30017 | 8 | 0 |
241711 | 241711 | 2020-06-15 | Custer | Montana | 30017 | 11 | 0 |
244822 | 244822 | 2020-06-16 | Custer | Montana | 30017 | 13 | 0 |
247935 | 247935 | 2020-06-17 | Custer | Montana | 30017 | 19 | 0 |
251048 | 251048 | 2020-06-18 | Custer | Montana | 30017 | 19 | 0 |
254163 | 254163 | 2020-06-19 | Custer | Montana | 30017 | 20 | 0 |
257285 | 257285 | 2020-06-20 | Custer | Montana | 30017 | 21 | 0 |
260411 | 260411 | 2020-06-21 | Custer | Montana | 30017 | 22 | 0 |
263540 | 263540 | 2020-06-22 | Custer | Montana | 30017 | 22 | 0 |
266666 | 266666 | 2020-06-23 | Custer | Montana | 30017 | 22 | 0 |
269799 | 269799 | 2020-06-24 | Custer | Montana | 30017 | 23 | 0 |
272937 | 272937 | 2020-06-25 | Custer | Montana | 30017 | 24 | 0 |
276080 | 276080 | 2020-06-26 | Custer | Montana | 30017 | 25 | 0 |
279228 | 279228 | 2020-06-27 | Custer | Montana | 30017 | 25 | 0 |
282376 | 282376 | 2020-06-28 | Custer | Montana | 30017 | 25 | 0 |
285521 | 285521 | 2020-06-29 | Custer | Montana | 30017 | 27 | 0 |
288671 | 288671 | 2020-06-30 | Custer | Montana | 30017 | 27 | 0 |
291822 | 291822 | 2020-07-01 | Custer | Montana | 30017 | 29 | 0 |
294976 | 294976 | 2020-07-02 | Custer | Montana | 30017 | 30 | 0 |
298134 | 298134 | 2020-07-03 | Custer | Montana | 30017 | 30 | 0 |
301297 | 301297 | 2020-07-04 | Custer | Montana | 30017 | 30 | 0 |
304461 | 304461 | 2020-07-05 | Custer | Montana | 30017 | 30 | 0 |
307628 | 307628 | 2020-07-06 | Custer | Montana | 30017 | 30 | 0 |
310796 | 310796 | 2020-07-07 | Custer | Montana | 30017 | 30 | 0 |
313967 | 313967 | 2020-07-08 | Custer | Montana | 30017 | 30 | 0 |
317141 | 317141 | 2020-07-09 | Custer | Montana | 30017 | 34 | 0 |
320316 | 320316 | 2020-07-10 | Custer | Montana | 30017 | 34 | 0 |
323495 | 323495 | 2020-07-11 | Custer | Montana | 30017 | 38 | 0 |
326678 | 326678 | 2020-07-12 | Custer | Montana | 30017 | 38 | 0 |
329864 | 329864 | 2020-07-13 | Custer | Montana | 30017 | 38 | 0 |
333051 | 333051 | 2020-07-14 | Custer | Montana | 30017 | 38 | 0 |
336244 | 336244 | 2020-07-15 | Custer | Montana | 30017 | 38 | 0 |
339441 | 339441 | 2020-07-16 | Custer | Montana | 30017 | 40 | 0 |
342637 | 342637 | 2020-07-17 | Custer | Montana | 30017 | 40 | 0 |
345837 | 345837 | 2020-07-18 | Custer | Montana | 30017 | 41 | 0 |
349038 | 349038 | 2020-07-19 | Custer | Montana | 30017 | 41 | 0 |
352238 | 352238 | 2020-07-20 | Custer | Montana | 30017 | 41 | 0 |
355441 | 355441 | 2020-07-21 | Custer | Montana | 30017 | 41 | 0 |
358644 | 358644 | 2020-07-22 | Custer | Montana | 30017 | 43 | 0 |
361849 | 361849 | 2020-07-23 | Custer | Montana | 30017 | 43 | 0 |
365056 | 365056 | 2020-07-24 | Custer | Montana | 30017 | 43 | 0 |
368264 | 368264 | 2020-07-25 | Custer | Montana | 30017 | 47 | 0 |
371475 | 371475 | 2020-07-26 | Custer | Montana | 30017 | 47 | 0 |
374687 | 374687 | 2020-07-27 | Custer | Montana | 30017 | 47 | 0 |
377902 | 377902 | 2020-07-28 | Custer | Montana | 30017 | 47 | 2 |
381119 | 381119 | 2020-07-29 | Custer | Montana | 30017 | 52 | 2 |
384335 | 384335 | 2020-07-30 | Custer | Montana | 30017 | 52 | 2 |
387553 | 387553 | 2020-07-31 | Custer | Montana | 30017 | 52 | 2 |
390770 | 390770 | 2020-08-01 | Custer | Montana | 30017 | 52 | 2 |
393987 | 393987 | 2020-08-02 | Custer | Montana | 30017 | 52 | 2 |
397203 | 397203 | 2020-08-03 | Custer | Montana | 30017 | 52 | 2 |
400417 | 400417 | 2020-08-04 | Custer | Montana | 30017 | 53 | 2 |
403634 | 403634 | 2020-08-05 | Custer | Montana | 30017 | 58 | 2 |
406852 | 406852 | 2020-08-06 | Custer | Montana | 30017 | 58 | 2 |
410072 | 410072 | 2020-08-07 | Custer | Montana | 30017 | 61 | 2 |
413292 | 413292 | 2020-08-08 | Custer | Montana | 30017 | 61 | 2 |
416512 | 416512 | 2020-08-09 | Custer | Montana | 30017 | 61 | 2 |
419733 | 419733 | 2020-08-10 | Custer | Montana | 30017 | 61 | 2 |
422955 | 422955 | 2020-08-11 | Custer | Montana | 30017 | 61 | 2 |
426177 | 426177 | 2020-08-12 | Custer | Montana | 30017 | 61 | 2 |
429401 | 429401 | 2020-08-13 | Custer | Montana | 30017 | 61 | 2 |
432628 | 432628 | 2020-08-14 | Custer | Montana | 30017 | 61 | 2 |
435854 | 435854 | 2020-08-15 | Custer | Montana | 30017 | 61 | 2 |
439079 | 439079 | 2020-08-16 | Custer | Montana | 30017 | 61 | 2 |
442306 | 442306 | 2020-08-17 | Custer | Montana | 30017 | 61 | 2 |
445532 | 445532 | 2020-08-18 | Custer | Montana | 30017 | 61 | 2 |
448758 | 448758 | 2020-08-19 | Custer | Montana | 30017 | 62 | 2 |
451986 | 451986 | 2020-08-20 | Custer | Montana | 30017 | 62 | 2 |
455214 | 455214 | 2020-08-21 | Custer | Montana | 30017 | 63 | 2 |
458442 | 458442 | 2020-08-22 | Custer | Montana | 30017 | 63 | 2 |
461669 | 461669 | 2020-08-23 | Custer | Montana | 30017 | 64 | 2 |
464900 | 464900 | 2020-08-24 | Custer | Montana | 30017 | 64 | 2 |
468129 | 468129 | 2020-08-25 | Custer | Montana | 30017 | 64 | 2 |
471359 | 471359 | 2020-08-26 | Custer | Montana | 30017 | 65 | 2 |
474591 | 474591 | 2020-08-27 | Custer | Montana | 30017 | 66 | 2 |
481056 | 481056 | 2020-08-29 | Custer | Montana | 30017 | 66 | 2 |
484291 | 484291 | 2020-08-30 | Custer | Montana | 30017 | 66 | 2 |
487525 | 487525 | 2020-08-31 | Custer | Montana | 30017 | 66 | 2 |
490758 | 490758 | 2020-09-01 | Custer | Montana | 30017 | 66 | 2 |
493992 | 493992 | 2020-09-02 | Custer | Montana | 30017 | 66 | 2 |
497225 | 497225 | 2020-09-03 | Custer | Montana | 30017 | 66 | 2 |
477824 | 477824 | 2020-08-28 | Custer | Montana | 30017 | 67 | 2 |
500459 | 500459 | 2020-09-04 | Custer | Montana | 30017 | 67 | 2 |
503693 | 503693 | 2020-09-05 | Custer | Montana | 30017 | 69 | 2 |
506926 | 506926 | 2020-09-06 | Custer | Montana | 30017 | 69 | 2 |
510159 | 510159 | 2020-09-07 | Custer | Montana | 30017 | 69 | 2 |
513391 | 513391 | 2020-09-08 | Custer | Montana | 30017 | 70 | 2 |
516625 | 516625 | 2020-09-09 | Custer | Montana | 30017 | 71 | 2 |
519860 | 519860 | 2020-09-10 | Custer | Montana | 30017 | 74 | 2 |
523097 | 523097 | 2020-09-11 | Custer | Montana | 30017 | 75 | 2 |
526333 | 526333 | 2020-09-12 | Custer | Montana | 30017 | 77 | 2 |
529569 | 529569 | 2020-09-13 | Custer | Montana | 30017 | 79 | 2 |
532805 | 532805 | 2020-09-14 | Custer | Montana | 30017 | 79 | 2 |
536040 | 536040 | 2020-09-15 | Custer | Montana | 30017 | 81 | 2 |
539277 | 539277 | 2020-09-16 | Custer | Montana | 30017 | 85 | 2 |
542513 | 542513 | 2020-09-17 | Custer | Montana | 30017 | 91 | 2 |
545750 | 545750 | 2020-09-18 | Custer | Montana | 30017 | 92 | 2 |
548988 | 548988 | 2020-09-19 | Custer | Montana | 30017 | 101 | 2 |
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);