ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,352 rows where county = "Douglas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-05-31 12
- 2020-06-01 12
- 2020-06-02 12
- 2020-06-03 12
- 2020-06-04 12
- 2020-06-05 12
- 2020-06-06 12
- 2020-06-07 12
- 2020-06-08 12
- 2020-06-09 12
- 2020-06-10 12
- 2020-06-11 12
- 2020-06-12 12
- 2020-06-13 12
- 2020-06-14 12
- 2020-06-15 12
- 2020-06-16 12
- 2020-06-17 12
- 2020-06-18 12
- 2020-06-19 12
- 2020-06-20 12
- 2020-06-21 12
- 2020-06-22 12
- 2020-06-23 12
- 2020-06-24 12
- 2020-06-25 12
- 2020-06-26 12
- 2020-06-27 12
- 2020-06-28 12
- 2020-06-29 12
- …
state 12
fips 12
county 1
- Douglas · 9,252 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474862 | 2474862 | 2022-05-05 | Douglas | Minnesota | 27041 | 11015 | 116 |
2475046 | 2475046 | 2022-05-05 | Douglas | Missouri | 29067 | 2550 | 80 |
2475213 | 2475213 | 2022-05-05 | Douglas | Nebraska | 31055 | 151683 | 1112 |
2475283 | 2475283 | 2022-05-05 | Douglas | Nevada | 32005 | 7369 | 92 |
2475757 | 2475757 | 2022-05-05 | Douglas | Oregon | 41019 | 19902 | 392 |
2476002 | 2476002 | 2022-05-05 | Douglas | South Dakota | 46043 | 684 | 16 |
2476588 | 2476588 | 2022-05-05 | Douglas | Washington | 53017 | 11170 | 70 |
2476690 | 2476690 | 2022-05-05 | Douglas | Wisconsin | 55031 | 11828 | 79 |
2470518 | 2470518 | 2022-05-04 | Douglas | Colorado | 8035 | 80633 | 457 |
2470693 | 2470693 | 2022-05-04 | Douglas | Georgia | 13097 | 35060 | 400 |
2470877 | 2470877 | 2022-05-04 | Douglas | Illinois | 17041 | 6562 | 61 |
2471175 | 2471175 | 2022-05-04 | Douglas | Kansas | 20045 | 26942 | 138 |
2471605 | 2471605 | 2022-05-04 | Douglas | Minnesota | 27041 | 11004 | 116 |
2471789 | 2471789 | 2022-05-04 | Douglas | Missouri | 29067 | 2550 | 79 |
2471956 | 2471956 | 2022-05-04 | Douglas | Nebraska | 31055 | 151683 | 1112 |
2472026 | 2472026 | 2022-05-04 | Douglas | Nevada | 32005 | 7369 | 92 |
2472500 | 2472500 | 2022-05-04 | Douglas | Oregon | 41019 | 19892 | 392 |
2472745 | 2472745 | 2022-05-04 | Douglas | South Dakota | 46043 | 684 | 16 |
2473330 | 2473330 | 2022-05-04 | Douglas | Washington | 53017 | 11170 | 70 |
2473432 | 2473432 | 2022-05-04 | Douglas | Wisconsin | 55031 | 11808 | 79 |
2467262 | 2467262 | 2022-05-03 | Douglas | Colorado | 8035 | 80567 | 438 |
2467437 | 2467437 | 2022-05-03 | Douglas | Georgia | 13097 | 34982 | 398 |
2467621 | 2467621 | 2022-05-03 | Douglas | Illinois | 17041 | 6554 | 61 |
2467919 | 2467919 | 2022-05-03 | Douglas | Kansas | 20045 | 26942 | 138 |
2468349 | 2468349 | 2022-05-03 | Douglas | Minnesota | 27041 | 10995 | 116 |
2468533 | 2468533 | 2022-05-03 | Douglas | Missouri | 29067 | 2550 | 79 |
2468700 | 2468700 | 2022-05-03 | Douglas | Nebraska | 31055 | 151622 | 1112 |
2468770 | 2468770 | 2022-05-03 | Douglas | Nevada | 32005 | 7353 | 92 |
2469244 | 2469244 | 2022-05-03 | Douglas | Oregon | 41019 | 19878 | 392 |
2469489 | 2469489 | 2022-05-03 | Douglas | South Dakota | 46043 | 684 | 16 |
2470074 | 2470074 | 2022-05-03 | Douglas | Washington | 53017 | 11209 | 70 |
2470175 | 2470175 | 2022-05-03 | Douglas | Wisconsin | 55031 | 11783 | 79 |
2464007 | 2464007 | 2022-05-02 | Douglas | Colorado | 8035 | 80384 | 437 |
2464182 | 2464182 | 2022-05-02 | Douglas | Georgia | 13097 | 34982 | 398 |
2464366 | 2464366 | 2022-05-02 | Douglas | Illinois | 17041 | 6535 | 61 |
2464664 | 2464664 | 2022-05-02 | Douglas | Kansas | 20045 | 26689 | 137 |
2465094 | 2465094 | 2022-05-02 | Douglas | Minnesota | 27041 | 10986 | 116 |
2465277 | 2465277 | 2022-05-02 | Douglas | Missouri | 29067 | 2550 | 79 |
2465444 | 2465444 | 2022-05-02 | Douglas | Nebraska | 31055 | 151493 | 1112 |
2465514 | 2465514 | 2022-05-02 | Douglas | Nevada | 32005 | 7353 | 92 |
2465988 | 2465988 | 2022-05-02 | Douglas | Oregon | 41019 | 19862 | 392 |
2466233 | 2466233 | 2022-05-02 | Douglas | South Dakota | 46043 | 684 | 16 |
2466818 | 2466818 | 2022-05-02 | Douglas | Washington | 53017 | 11209 | 70 |
2466919 | 2466919 | 2022-05-02 | Douglas | Wisconsin | 55031 | 11764 | 79 |
2460751 | 2460751 | 2022-05-01 | Douglas | Colorado | 8035 | 80384 | 437 |
2460926 | 2460926 | 2022-05-01 | Douglas | Georgia | 13097 | 34982 | 398 |
2461110 | 2461110 | 2022-05-01 | Douglas | Illinois | 17041 | 6520 | 61 |
2461408 | 2461408 | 2022-05-01 | Douglas | Kansas | 20045 | 26689 | 137 |
2461838 | 2461838 | 2022-05-01 | Douglas | Minnesota | 27041 | 10981 | 116 |
2462022 | 2462022 | 2022-05-01 | Douglas | Missouri | 29067 | 2550 | 79 |
2462189 | 2462189 | 2022-05-01 | Douglas | Nebraska | 31055 | 151370 | 1112 |
2462259 | 2462259 | 2022-05-01 | Douglas | Nevada | 32005 | 7353 | 92 |
2462733 | 2462733 | 2022-05-01 | Douglas | Oregon | 41019 | 19837 | 392 |
2462978 | 2462978 | 2022-05-01 | Douglas | South Dakota | 46043 | 684 | 16 |
2463563 | 2463563 | 2022-05-01 | Douglas | Washington | 53017 | 11131 | 70 |
2463664 | 2463664 | 2022-05-01 | Douglas | Wisconsin | 55031 | 11738 | 79 |
2457495 | 2457495 | 2022-04-30 | Douglas | Colorado | 8035 | 80316 | 437 |
2457670 | 2457670 | 2022-04-30 | Douglas | Georgia | 13097 | 34982 | 398 |
2457854 | 2457854 | 2022-04-30 | Douglas | Illinois | 17041 | 6520 | 61 |
2458152 | 2458152 | 2022-04-30 | Douglas | Kansas | 20045 | 26689 | 137 |
2458582 | 2458582 | 2022-04-30 | Douglas | Minnesota | 27041 | 10981 | 116 |
2458766 | 2458766 | 2022-04-30 | Douglas | Missouri | 29067 | 2550 | 79 |
2458933 | 2458933 | 2022-04-30 | Douglas | Nebraska | 31055 | 151370 | 1112 |
2459003 | 2459003 | 2022-04-30 | Douglas | Nevada | 32005 | 7353 | 92 |
2459477 | 2459477 | 2022-04-30 | Douglas | Oregon | 41019 | 19837 | 392 |
2459722 | 2459722 | 2022-04-30 | Douglas | South Dakota | 46043 | 684 | 16 |
2460307 | 2460307 | 2022-04-30 | Douglas | Washington | 53017 | 11131 | 70 |
2460408 | 2460408 | 2022-04-30 | Douglas | Wisconsin | 55031 | 11738 | 79 |
2454239 | 2454239 | 2022-04-29 | Douglas | Colorado | 8035 | 80316 | 437 |
2454414 | 2454414 | 2022-04-29 | Douglas | Georgia | 13097 | 34982 | 398 |
2454598 | 2454598 | 2022-04-29 | Douglas | Illinois | 17041 | 6520 | 61 |
2454896 | 2454896 | 2022-04-29 | Douglas | Kansas | 20045 | 26689 | 137 |
2455326 | 2455326 | 2022-04-29 | Douglas | Minnesota | 27041 | 10981 | 116 |
2455510 | 2455510 | 2022-04-29 | Douglas | Missouri | 29067 | 2550 | 79 |
2455677 | 2455677 | 2022-04-29 | Douglas | Nebraska | 31055 | 151370 | 1112 |
2455747 | 2455747 | 2022-04-29 | Douglas | Nevada | 32005 | 7353 | 92 |
2456221 | 2456221 | 2022-04-29 | Douglas | Oregon | 41019 | 19837 | 392 |
2456466 | 2456466 | 2022-04-29 | Douglas | South Dakota | 46043 | 684 | 16 |
2457051 | 2457051 | 2022-04-29 | Douglas | Washington | 53017 | 11131 | 70 |
2457152 | 2457152 | 2022-04-29 | Douglas | Wisconsin | 55031 | 11738 | 79 |
2450983 | 2450983 | 2022-04-28 | Douglas | Colorado | 8035 | 79934 | 437 |
2451158 | 2451158 | 2022-04-28 | Douglas | Georgia | 13097 | 34982 | 398 |
2451342 | 2451342 | 2022-04-28 | Douglas | Illinois | 17041 | 6513 | 61 |
2451640 | 2451640 | 2022-04-28 | Douglas | Kansas | 20045 | 26689 | 137 |
2452070 | 2452070 | 2022-04-28 | Douglas | Minnesota | 27041 | 10968 | 116 |
2452254 | 2452254 | 2022-04-28 | Douglas | Missouri | 29067 | 2550 | 79 |
2452421 | 2452421 | 2022-04-28 | Douglas | Nebraska | 31055 | 151331 | 1110 |
2452491 | 2452491 | 2022-04-28 | Douglas | Nevada | 32005 | 7353 | 92 |
2452965 | 2452965 | 2022-04-28 | Douglas | Oregon | 41019 | 19822 | 392 |
2453210 | 2453210 | 2022-04-28 | Douglas | South Dakota | 46043 | 684 | 16 |
2453795 | 2453795 | 2022-04-28 | Douglas | Washington | 53017 | 11122 | 69 |
2453896 | 2453896 | 2022-04-28 | Douglas | Wisconsin | 55031 | 11727 | 79 |
2447727 | 2447727 | 2022-04-27 | Douglas | Colorado | 8035 | 79858 | 436 |
2447902 | 2447902 | 2022-04-27 | Douglas | Georgia | 13097 | 34982 | 398 |
2448086 | 2448086 | 2022-04-27 | Douglas | Illinois | 17041 | 6507 | 61 |
2448384 | 2448384 | 2022-04-27 | Douglas | Kansas | 20045 | 26281 | 138 |
2448814 | 2448814 | 2022-04-27 | Douglas | Minnesota | 27041 | 10960 | 116 |
2448998 | 2448998 | 2022-04-27 | Douglas | Missouri | 29067 | 2550 | 79 |
2449165 | 2449165 | 2022-04-27 | Douglas | Nebraska | 31055 | 151240 | 1110 |
2449235 | 2449235 | 2022-04-27 | Douglas | Nevada | 32005 | 7353 | 92 |
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);