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

24,215 rows where county = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state >30

fips >30

county 1

  • Washington · 24,215 ✖
Link rowid date ▲ county state fips cases deaths
2499639 2499639 2022-05-13 Washington Alabama 1129 3736 59
2499758 2499758 2022-05-13 Washington Arkansas 5143 68841 620
2499881 2499881 2022-05-13 Washington Colorado 8121 1066 28
2499965 2499965 2022-05-13 Washington Florida 12133 6642 110
2500116 2500116 2022-05-13 Washington Georgia 13303 4411 137
2500176 2500176 2022-05-13 Washington Idaho 16087 2394 57
2500272 2500272 2022-05-13 Washington Illinois 17189 3455 41
2500368 2500368 2022-05-13 Washington Indiana 18175 6010 85
2500465 2500465 2022-05-13 Washington Iowa 19183 5681 79
2500574 2500574 2022-05-13 Washington Kansas 20201 1400 22
2500693 2500693 2022-05-13 Washington Kentucky 21229 3967 61
2500758 2500758 2022-05-13 Washington Louisiana 22117 12994 249
2500779 2500779 2022-05-13 Washington Maine 23029 4585 57
2500803 2500803 2022-05-13 Washington Maryland 24043 35434 586
2500987 2500987 2022-05-13 Washington Minnesota 27163 69180 481
2501069 2501069 2022-05-13 Washington Mississippi 28151 10470 199
2501188 2501188 2022-05-13 Washington Missouri 29221 6032 141
2501338 2501338 2022-05-13 Washington Nebraska 31177 4582 45
2501481 2501481 2022-05-13 Washington New York 36115 12875 115
2501579 2501579 2022-05-13 Washington North Carolina 37187 3056 50
2501728 2501728 2022-05-13 Washington Ohio 39167 12409 207
2501807 2501807 2022-05-13 Washington Oklahoma 40147 12718 262
2501844 2501844 2022-05-13 Washington Oregon 41067 91092 594
2501909 2501909 2022-05-13 Washington Pennsylvania 42125 51747 654
2501998 2501998 2022-05-13 Washington Rhode Island 44009 34243 224
2502201 2502201 2022-05-13 Washington Tennessee 47179 38862 496
2502446 2502446 2022-05-13 Washington Texas 48477 9232 148
2502489 2502489 2022-05-13 Washington Utah 49053 45053 463
2502504 2502504 2022-05-13 Washington Vermont 50023 12430 51
2502635 2502635 2022-05-13 Washington Virginia 51191 13910 215
2502804 2502804 2022-05-13 Washington Wisconsin 55131 38986 343
2496381 2496381 2022-05-12 Washington Alabama 1129 3735 59
2496500 2496500 2022-05-12 Washington Arkansas 5143 68783 620
2496623 2496623 2022-05-12 Washington Colorado 8121 1065 28
2496707 2496707 2022-05-12 Washington Florida 12133 6642 110
2496858 2496858 2022-05-12 Washington Georgia 13303 4411 137
2496918 2496918 2022-05-12 Washington Idaho 16087 2393 57
2497014 2497014 2022-05-12 Washington Illinois 17189 3454 41
2497110 2497110 2022-05-12 Washington Indiana 18175 6007 85
2497207 2497207 2022-05-12 Washington Iowa 19183 5681 79
2497316 2497316 2022-05-12 Washington Kansas 20201 1399 22
2497435 2497435 2022-05-12 Washington Kentucky 21229 3967 61
2497500 2497500 2022-05-12 Washington Louisiana 22117 12991 249
2497521 2497521 2022-05-12 Washington Maine 23029 4579 56
2497545 2497545 2022-05-12 Washington Maryland 24043 35423 586
2497729 2497729 2022-05-12 Washington Minnesota 27163 69030 480
2497811 2497811 2022-05-12 Washington Mississippi 28151 10470 199
2497930 2497930 2022-05-12 Washington Missouri 29221 6023 141
2498080 2498080 2022-05-12 Washington Nebraska 31177 4575 43
2498223 2498223 2022-05-12 Washington New York 36115 12875 115
2498321 2498321 2022-05-12 Washington North Carolina 37187 3056 50
2498470 2498470 2022-05-12 Washington Ohio 39167 12409 207
2498549 2498549 2022-05-12 Washington Oklahoma 40147 12718 262
2498586 2498586 2022-05-12 Washington Oregon 41067 90808 594
2498651 2498651 2022-05-12 Washington Pennsylvania 42125 51747 654
2498740 2498740 2022-05-12 Washington Rhode Island 44009 34243 224
2498943 2498943 2022-05-12 Washington Tennessee 47179 38862 496
2499188 2499188 2022-05-12 Washington Texas 48477 9230 148
2499231 2499231 2022-05-12 Washington Utah 49053 45053 463
2499246 2499246 2022-05-12 Washington Vermont 50023 12401 51
2499377 2499377 2022-05-12 Washington Virginia 51191 13905 215
2499546 2499546 2022-05-12 Washington Wisconsin 55131 38921 344
2493123 2493123 2022-05-11 Washington Alabama 1129 3735 59
2493242 2493242 2022-05-11 Washington Arkansas 5143 68746 620
2493365 2493365 2022-05-11 Washington Colorado 8121 1063 28
2493449 2493449 2022-05-11 Washington Florida 12133 6642 110
2493600 2493600 2022-05-11 Washington Georgia 13303 4411 137
2493660 2493660 2022-05-11 Washington Idaho 16087 2393 57
2493756 2493756 2022-05-11 Washington Illinois 17189 3454 41
2493852 2493852 2022-05-11 Washington Indiana 18175 6007 85
2493949 2493949 2022-05-11 Washington Iowa 19183 5681 79
2494058 2494058 2022-05-11 Washington Kansas 20201 1399 22
2494177 2494177 2022-05-11 Washington Kentucky 21229 3967 61
2494242 2494242 2022-05-11 Washington Louisiana 22117 12989 249
2494263 2494263 2022-05-11 Washington Maine 23029 4569 56
2494287 2494287 2022-05-11 Washington Maryland 24043 35393 586
2494471 2494471 2022-05-11 Washington Minnesota 27163 68919 480
2494553 2494553 2022-05-11 Washington Mississippi 28151 10470 199
2494672 2494672 2022-05-11 Washington Missouri 29221 6023 141
2494822 2494822 2022-05-11 Washington Nebraska 31177 4575 43
2494965 2494965 2022-05-11 Washington New York 36115 12823 115
2495063 2495063 2022-05-11 Washington North Carolina 37187 3056 50
2495212 2495212 2022-05-11 Washington Ohio 39167 12384 207
2495291 2495291 2022-05-11 Washington Oklahoma 40147 12698 261
2495328 2495328 2022-05-11 Washington Oregon 41067 90426 594
2495393 2495393 2022-05-11 Washington Pennsylvania 42125 51747 654
2495482 2495482 2022-05-11 Washington Rhode Island 44009 34243 224
2495685 2495685 2022-05-11 Washington Tennessee 47179 38862 496
2495930 2495930 2022-05-11 Washington Texas 48477 9230 148
2495973 2495973 2022-05-11 Washington Utah 49053 45032 463
2495988 2495988 2022-05-11 Washington Vermont 50023 12309 51
2496119 2496119 2022-05-11 Washington Virginia 51191 13899 215
2496288 2496288 2022-05-11 Washington Wisconsin 55131 38864 342
2489865 2489865 2022-05-10 Washington Alabama 1129 3734 59
2489984 2489984 2022-05-10 Washington Arkansas 5143 68729 620
2490107 2490107 2022-05-10 Washington Colorado 8121 1063 28
2490191 2490191 2022-05-10 Washington Florida 12133 6642 110
2490342 2490342 2022-05-10 Washington Georgia 13303 4401 137
2490402 2490402 2022-05-10 Washington Idaho 16087 2392 57
2490498 2490498 2022-05-10 Washington Illinois 17189 3451 41

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