ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

9,352 rows where county = "Douglas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 12

fips 12

county 1

  • Douglas · 9,352 ✖
Link rowid date ▲ county state fips cases deaths
2499838 2499838 2022-05-13 Douglas Colorado 8035 81400 460
2500013 2500013 2022-05-13 Douglas Georgia 13097 35159 400
2500197 2500197 2022-05-13 Douglas Illinois 17041 6609 61
2500495 2500495 2022-05-13 Douglas Kansas 20045 27394 139
2500925 2500925 2022-05-13 Douglas Minnesota 27041 11106 117
2501109 2501109 2022-05-13 Douglas Missouri 29067 2560 80
2501276 2501276 2022-05-13 Douglas Nebraska 31055 151440 1119
2501346 2501346 2022-05-13 Douglas Nevada 32005 7410 92
2501820 2501820 2022-05-13 Douglas Oregon 41019 20020 396
2502065 2502065 2022-05-13 Douglas South Dakota 46043 684 16
2502651 2502651 2022-05-13 Douglas Washington 53017 11269 70
2502753 2502753 2022-05-13 Douglas Wisconsin 55031 11993 79
2496580 2496580 2022-05-12 Douglas Colorado 8035 81277 460
2496755 2496755 2022-05-12 Douglas Georgia 13097 35159 400
2496939 2496939 2022-05-12 Douglas Illinois 17041 6605 61
2497237 2497237 2022-05-12 Douglas Kansas 20045 27394 139
2497667 2497667 2022-05-12 Douglas Minnesota 27041 11092 116
2497851 2497851 2022-05-12 Douglas Missouri 29067 2551 80
2498018 2498018 2022-05-12 Douglas Nebraska 31055 151312 1119
2498088 2498088 2022-05-12 Douglas Nevada 32005 7410 92
2498562 2498562 2022-05-12 Douglas Oregon 41019 19991 396
2498807 2498807 2022-05-12 Douglas South Dakota 46043 684 16
2499393 2499393 2022-05-12 Douglas Washington 53017 11246 70
2499495 2499495 2022-05-12 Douglas Wisconsin 55031 11964 79
2493322 2493322 2022-05-11 Douglas Colorado 8035 81128 459
2493497 2493497 2022-05-11 Douglas Georgia 13097 35159 400
2493681 2493681 2022-05-11 Douglas Illinois 17041 6594 61
2493979 2493979 2022-05-11 Douglas Kansas 20045 27259 139
2494409 2494409 2022-05-11 Douglas Minnesota 27041 11076 116
2494593 2494593 2022-05-11 Douglas Missouri 29067 2551 80
2494760 2494760 2022-05-11 Douglas Nebraska 31055 151199 1114
2494830 2494830 2022-05-11 Douglas Nevada 32005 7410 92
2495304 2495304 2022-05-11 Douglas Oregon 41019 19977 393
2495549 2495549 2022-05-11 Douglas South Dakota 46043 684 16
2496135 2496135 2022-05-11 Douglas Washington 53017 11246 70
2496237 2496237 2022-05-11 Douglas Wisconsin 55031 11930 79
2490064 2490064 2022-05-10 Douglas Colorado 8035 81050 458
2490239 2490239 2022-05-10 Douglas Georgia 13097 35060 400
2490423 2490423 2022-05-10 Douglas Illinois 17041 6587 61
2490721 2490721 2022-05-10 Douglas Kansas 20045 27259 139
2491151 2491151 2022-05-10 Douglas Minnesota 27041 11067 116
2491335 2491335 2022-05-10 Douglas Missouri 29067 2551 80
2491502 2491502 2022-05-10 Douglas Nebraska 31055 151824 1113
2491572 2491572 2022-05-10 Douglas Nevada 32005 7369 92
2492046 2492046 2022-05-10 Douglas Oregon 41019 19950 392
2492291 2492291 2022-05-10 Douglas South Dakota 46043 684 16
2492877 2492877 2022-05-10 Douglas Washington 53017 11211 70
2492979 2492979 2022-05-10 Douglas Wisconsin 55031 11891 79
2486807 2486807 2022-05-09 Douglas Colorado 8035 80797 457
2486982 2486982 2022-05-09 Douglas Georgia 13097 35060 400
2487166 2487166 2022-05-09 Douglas Illinois 17041 6581 61
2487464 2487464 2022-05-09 Douglas Kansas 20045 27058 138
2487894 2487894 2022-05-09 Douglas Minnesota 27041 11040 116
2488077 2488077 2022-05-09 Douglas Missouri 29067 2551 80
2488244 2488244 2022-05-09 Douglas Nebraska 31055 151824 1113
2488314 2488314 2022-05-09 Douglas Nevada 32005 7369 92
2488788 2488788 2022-05-09 Douglas Oregon 41019 19927 392
2489033 2489033 2022-05-09 Douglas South Dakota 46043 684 16
2489619 2489619 2022-05-09 Douglas Washington 53017 11209 70
2489721 2489721 2022-05-09 Douglas Wisconsin 55031 11880 79
2483549 2483549 2022-05-08 Douglas Colorado 8035 80797 457
2483724 2483724 2022-05-08 Douglas Georgia 13097 35060 400
2483908 2483908 2022-05-08 Douglas Illinois 17041 6573 61
2484206 2484206 2022-05-08 Douglas Kansas 20045 27058 138
2484636 2484636 2022-05-08 Douglas Minnesota 27041 11026 116
2484820 2484820 2022-05-08 Douglas Missouri 29067 2551 80
2484987 2484987 2022-05-08 Douglas Nebraska 31055 151683 1112
2485057 2485057 2022-05-08 Douglas Nevada 32005 7369 92
2485531 2485531 2022-05-08 Douglas Oregon 41019 19912 392
2485776 2485776 2022-05-08 Douglas South Dakota 46043 684 16
2486362 2486362 2022-05-08 Douglas Washington 53017 11185 70
2486464 2486464 2022-05-08 Douglas Wisconsin 55031 11846 79
2480291 2480291 2022-05-07 Douglas Colorado 8035 80797 457
2480466 2480466 2022-05-07 Douglas Georgia 13097 35060 400
2480650 2480650 2022-05-07 Douglas Illinois 17041 6573 61
2480948 2480948 2022-05-07 Douglas Kansas 20045 27058 138
2481378 2481378 2022-05-07 Douglas Minnesota 27041 11026 116
2481562 2481562 2022-05-07 Douglas Missouri 29067 2551 80
2481729 2481729 2022-05-07 Douglas Nebraska 31055 151683 1112
2481799 2481799 2022-05-07 Douglas Nevada 32005 7369 92
2482273 2482273 2022-05-07 Douglas Oregon 41019 19912 392
2482518 2482518 2022-05-07 Douglas South Dakota 46043 684 16
2483104 2483104 2022-05-07 Douglas Washington 53017 11185 70
2483206 2483206 2022-05-07 Douglas Wisconsin 55031 11846 79
2477033 2477033 2022-05-06 Douglas Colorado 8035 80790 457
2477208 2477208 2022-05-06 Douglas Georgia 13097 35060 400
2477392 2477392 2022-05-06 Douglas Illinois 17041 6573 61
2477690 2477690 2022-05-06 Douglas Kansas 20045 27058 138
2478120 2478120 2022-05-06 Douglas Minnesota 27041 11026 116
2478304 2478304 2022-05-06 Douglas Missouri 29067 2551 80
2478471 2478471 2022-05-06 Douglas Nebraska 31055 151683 1112
2478541 2478541 2022-05-06 Douglas Nevada 32005 7369 92
2479015 2479015 2022-05-06 Douglas Oregon 41019 19912 392
2479260 2479260 2022-05-06 Douglas South Dakota 46043 684 16
2479846 2479846 2022-05-06 Douglas Washington 53017 11185 70
2479948 2479948 2022-05-06 Douglas Wisconsin 55031 11846 79
2473775 2473775 2022-05-05 Douglas Colorado 8035 80718 457
2473950 2473950 2022-05-05 Douglas Georgia 13097 35060 400
2474134 2474134 2022-05-05 Douglas Illinois 17041 6572 61
2474432 2474432 2022-05-05 Douglas Kansas 20045 27058 138

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);