ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24,215 rows where county = "Washington" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Oregon 806
- Utah 799
- Pennsylvania 792
- Vermont 791
- Minnesota 790
- Louisiana 788
- Arkansas 787
- Illinois 787
- Iowa 787
- New York 787
- Wisconsin 787
- Oklahoma 786
- Tennessee 786
- Alabama 785
- Indiana 784
- Maryland 784
- Mississippi 784
- Georgia 782
- Nebraska 782
- Ohio 782
- Rhode Island 780
- Colorado 779
- Florida 779
- Virginia 779
- Kentucky 777
- Texas 777
- North Carolina 776
- Idaho 772
- Maine 771
- Missouri 766
- …
fips >30
date (date) >30 ✖
- 2020-06-10 31
- 2020-06-11 31
- 2020-06-12 31
- 2020-06-13 31
- 2020-06-14 31
- 2020-06-15 31
- 2020-06-16 31
- 2020-06-17 31
- 2020-06-18 31
- 2020-06-19 31
- 2020-06-20 31
- 2020-06-21 31
- 2020-06-22 31
- 2020-06-23 31
- 2020-06-24 31
- 2020-06-25 31
- 2020-06-26 31
- 2020-06-27 31
- 2020-06-28 31
- 2020-06-29 31
- 2020-06-30 31
- 2020-07-01 31
- 2020-07-02 31
- 2020-07-03 31
- 2020-07-04 31
- 2020-07-05 31
- 2020-07-06 31
- 2020-07-07 31
- 2020-07-08 31
- 2020-07-09 31
- …
county 1
- Washington · 24,215 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
370 | 370 | 2020-02-28 | Washington | Oregon | 41067 | 1 | 0 |
392 | 392 | 2020-02-29 | Washington | Oregon | 41067 | 1 | 0 |
418 | 418 | 2020-03-01 | Washington | Oregon | 41067 | 2 | 0 |
450 | 450 | 2020-03-02 | Washington | Oregon | 41067 | 2 | 0 |
485 | 485 | 2020-03-03 | Washington | Oregon | 41067 | 2 | 0 |
522 | 522 | 2020-03-04 | Washington | Oregon | 41067 | 2 | 0 |
569 | 569 | 2020-03-05 | Washington | Oregon | 41067 | 2 | 0 |
634 | 634 | 2020-03-06 | Washington | Oregon | 41067 | 2 | 0 |
646 | 646 | 2020-03-06 | Washington | Utah | 49053 | 1 | 0 |
725 | 725 | 2020-03-07 | Washington | Oregon | 41067 | 3 | 0 |
738 | 738 | 2020-03-07 | Washington | Utah | 49053 | 1 | 0 |
834 | 834 | 2020-03-08 | Washington | Oregon | 41067 | 8 | 0 |
850 | 850 | 2020-03-08 | Washington | Utah | 49053 | 1 | 0 |
962 | 962 | 2020-03-09 | Washington | Oregon | 41067 | 8 | 0 |
980 | 980 | 2020-03-09 | Washington | Utah | 49053 | 1 | 0 |
1114 | 1114 | 2020-03-10 | Washington | Oregon | 41067 | 8 | 0 |
1141 | 1141 | 2020-03-10 | Washington | Utah | 49053 | 1 | 0 |
1307 | 1307 | 2020-03-11 | Washington | Oregon | 41067 | 8 | 0 |
1338 | 1338 | 2020-03-11 | Washington | Utah | 49053 | 1 | 0 |
1551 | 1551 | 2020-03-12 | Washington | Oregon | 41067 | 10 | 0 |
1585 | 1585 | 2020-03-12 | Washington | Utah | 49053 | 1 | 0 |
1847 | 1847 | 2020-03-13 | Washington | Oregon | 41067 | 10 | 0 |
1857 | 1857 | 2020-03-13 | Washington | Pennsylvania | 42125 | 1 | 0 |
1894 | 1894 | 2020-03-13 | Washington | Utah | 49053 | 1 | 0 |
2208 | 2208 | 2020-03-14 | Washington | Oregon | 41067 | 13 | 0 |
2219 | 2219 | 2020-03-14 | Washington | Pennsylvania | 42125 | 1 | 0 |
2262 | 2262 | 2020-03-14 | Washington | Utah | 49053 | 1 | 0 |
2266 | 2266 | 2020-03-14 | Washington | Vermont | 50023 | 1 | 0 |
2525 | 2525 | 2020-03-15 | Washington | Minnesota | 27163 | 1 | 0 |
2627 | 2627 | 2020-03-15 | Washington | Oregon | 41067 | 13 | 0 |
2641 | 2641 | 2020-03-15 | Washington | Pennsylvania | 42125 | 1 | 0 |
2689 | 2689 | 2020-03-15 | Washington | Utah | 49053 | 1 | 0 |
2693 | 2693 | 2020-03-15 | Washington | Vermont | 50023 | 1 | 0 |
2977 | 2977 | 2020-03-16 | Washington | Minnesota | 27163 | 1 | 0 |
3092 | 3092 | 2020-03-16 | Washington | Oregon | 41067 | 14 | 0 |
3106 | 3106 | 2020-03-16 | Washington | Pennsylvania | 42125 | 1 | 0 |
3160 | 3160 | 2020-03-16 | Washington | Utah | 49053 | 1 | 0 |
3165 | 3165 | 2020-03-16 | Washington | Vermont | 50023 | 1 | 0 |
3424 | 3424 | 2020-03-17 | Washington | Louisiana | 22117 | 1 | 0 |
3482 | 3482 | 2020-03-17 | Washington | Minnesota | 27163 | 1 | 0 |
3621 | 3621 | 2020-03-17 | Washington | Oregon | 41067 | 21 | 0 |
3636 | 3636 | 2020-03-17 | Washington | Pennsylvania | 42125 | 2 | 0 |
3696 | 3696 | 2020-03-17 | Washington | Utah | 49053 | 1 | 0 |
3701 | 3701 | 2020-03-17 | Washington | Vermont | 50023 | 1 | 0 |
3793 | 3793 | 2020-03-18 | Washington | Arkansas | 5143 | 1 | 0 |
3938 | 3938 | 2020-03-18 | Washington | Illinois | 17189 | 1 | 0 |
3972 | 3972 | 2020-03-18 | Washington | Iowa | 19183 | 1 | 0 |
4005 | 4005 | 2020-03-18 | Washington | Louisiana | 22117 | 1 | 0 |
4066 | 4066 | 2020-03-18 | Washington | Minnesota | 27163 | 3 | 0 |
4166 | 4166 | 2020-03-18 | Washington | New York | 36115 | 1 | 0 |
4254 | 4254 | 2020-03-18 | Washington | Pennsylvania | 42125 | 2 | 0 |
4328 | 4328 | 2020-03-18 | Washington | Utah | 49053 | 1 | 0 |
4333 | 4333 | 2020-03-18 | Washington | Vermont | 50023 | 1 | 0 |
4392 | 4392 | 2020-03-18 | Washington | Wisconsin | 55131 | 2 | 0 |
4453 | 4453 | 2020-03-19 | Washington | Arkansas | 5143 | 1 | 0 |
4614 | 4614 | 2020-03-19 | Washington | Illinois | 17189 | 1 | 0 |
4653 | 4653 | 2020-03-19 | Washington | Iowa | 19183 | 1 | 0 |
4705 | 4705 | 2020-03-19 | Washington | Louisiana | 22117 | 2 | 0 |
4778 | 4778 | 2020-03-19 | Washington | Minnesota | 27163 | 3 | 0 |
4896 | 4896 | 2020-03-19 | Washington | New York | 36115 | 1 | 0 |
4962 | 4962 | 2020-03-19 | Washington | Oklahoma | 40147 | 1 | 0 |
4995 | 4995 | 2020-03-19 | Washington | Pennsylvania | 42125 | 3 | 0 |
5040 | 5040 | 2020-03-19 | Washington | Tennessee | 47179 | 2 | 0 |
5084 | 5084 | 2020-03-19 | Washington | Utah | 49053 | 1 | 0 |
5089 | 5089 | 2020-03-19 | Washington | Vermont | 50023 | 1 | 0 |
5158 | 5158 | 2020-03-19 | Washington | Wisconsin | 55131 | 2 | 0 |
5186 | 5186 | 2020-03-20 | Washington | Alabama | 1129 | 1 | 0 |
5226 | 5226 | 2020-03-20 | Washington | Arkansas | 5143 | 1 | 0 |
5420 | 5420 | 2020-03-20 | Washington | Illinois | 17189 | 1 | 0 |
5464 | 5464 | 2020-03-20 | Washington | Iowa | 19183 | 1 | 0 |
5523 | 5523 | 2020-03-20 | Washington | Louisiana | 22117 | 2 | 0 |
5600 | 5600 | 2020-03-20 | Washington | Minnesota | 27163 | 3 | 0 |
5747 | 5747 | 2020-03-20 | Washington | New York | 36115 | 1 | 0 |
5829 | 5829 | 2020-03-20 | Washington | Oklahoma | 40147 | 1 | 0 |
5868 | 5868 | 2020-03-20 | Washington | Pennsylvania | 42125 | 3 | 0 |
5929 | 5929 | 2020-03-20 | Washington | Tennessee | 47179 | 2 | 0 |
5978 | 5978 | 2020-03-20 | Washington | Utah | 49053 | 1 | 0 |
5985 | 5985 | 2020-03-20 | Washington | Vermont | 50023 | 2 | 0 |
6072 | 6072 | 2020-03-20 | Washington | Wisconsin | 55131 | 3 | 0 |
6103 | 6103 | 2020-03-21 | Washington | Alabama | 1129 | 1 | 0 |
6145 | 6145 | 2020-03-21 | Washington | Arkansas | 5143 | 1 | 0 |
6355 | 6355 | 2020-03-21 | Washington | Illinois | 17189 | 1 | 0 |
6391 | 6391 | 2020-03-21 | Washington | Indiana | 18175 | 1 | 0 |
6409 | 6409 | 2020-03-21 | Washington | Iowa | 19183 | 2 | 0 |
6478 | 6478 | 2020-03-21 | Washington | Louisiana | 22117 | 2 | 0 |
6504 | 6504 | 2020-03-21 | Washington | Maryland | 24043 | 1 | 0 |
6574 | 6574 | 2020-03-21 | Washington | Minnesota | 27163 | 4 | 0 |
6617 | 6617 | 2020-03-21 | Washington | Mississippi | 28151 | 1 | 0 |
6742 | 6742 | 2020-03-21 | Washington | New York | 36115 | 1 | 0 |
6830 | 6830 | 2020-03-21 | Washington | Oklahoma | 40147 | 1 | 0 |
6872 | 6872 | 2020-03-21 | Washington | Pennsylvania | 42125 | 5 | 0 |
6946 | 6946 | 2020-03-21 | Washington | Tennessee | 47179 | 2 | 0 |
7001 | 7001 | 2020-03-21 | Washington | Utah | 49053 | 2 | 0 |
7009 | 7009 | 2020-03-21 | Washington | Vermont | 50023 | 2 | 0 |
7105 | 7105 | 2020-03-21 | Washington | Wisconsin | 55131 | 3 | 0 |
7137 | 7137 | 2020-03-22 | Washington | Alabama | 1129 | 1 | 0 |
7179 | 7179 | 2020-03-22 | Washington | Arkansas | 5143 | 5 | 0 |
7409 | 7409 | 2020-03-22 | Washington | Illinois | 17189 | 1 | 0 |
7451 | 7451 | 2020-03-22 | Washington | Indiana | 18175 | 2 | 0 |
7475 | 7475 | 2020-03-22 | Washington | Iowa | 19183 | 3 | 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);