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 cases
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 |
646 | 646 | 2020-03-06 | Washington | Utah | 49053 | 1 | 0 |
738 | 738 | 2020-03-07 | Washington | Utah | 49053 | 1 | 0 |
850 | 850 | 2020-03-08 | Washington | Utah | 49053 | 1 | 0 |
980 | 980 | 2020-03-09 | Washington | Utah | 49053 | 1 | 0 |
1141 | 1141 | 2020-03-10 | Washington | Utah | 49053 | 1 | 0 |
1338 | 1338 | 2020-03-11 | Washington | Utah | 49053 | 1 | 0 |
1585 | 1585 | 2020-03-12 | Washington | Utah | 49053 | 1 | 0 |
1857 | 1857 | 2020-03-13 | Washington | Pennsylvania | 42125 | 1 | 0 |
1894 | 1894 | 2020-03-13 | Washington | Utah | 49053 | 1 | 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 |
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 |
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 |
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 |
4166 | 4166 | 2020-03-18 | Washington | New York | 36115 | 1 | 0 |
4328 | 4328 | 2020-03-18 | Washington | Utah | 49053 | 1 | 0 |
4333 | 4333 | 2020-03-18 | Washington | Vermont | 50023 | 1 | 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 |
4896 | 4896 | 2020-03-19 | Washington | New York | 36115 | 1 | 0 |
4962 | 4962 | 2020-03-19 | Washington | Oklahoma | 40147 | 1 | 0 |
5084 | 5084 | 2020-03-19 | Washington | Utah | 49053 | 1 | 0 |
5089 | 5089 | 2020-03-19 | Washington | Vermont | 50023 | 1 | 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 |
5747 | 5747 | 2020-03-20 | Washington | New York | 36115 | 1 | 0 |
5829 | 5829 | 2020-03-20 | Washington | Oklahoma | 40147 | 1 | 0 |
5978 | 5978 | 2020-03-20 | Washington | Utah | 49053 | 1 | 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 |
6504 | 6504 | 2020-03-21 | Washington | Maryland | 24043 | 1 | 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 |
7137 | 7137 | 2020-03-22 | Washington | Alabama | 1129 | 1 | 0 |
7409 | 7409 | 2020-03-22 | Washington | Illinois | 17189 | 1 | 0 |
7581 | 7581 | 2020-03-22 | Washington | Maryland | 24043 | 1 | 0 |
7838 | 7838 | 2020-03-22 | Washington | New York | 36115 | 1 | 0 |
8278 | 8278 | 2020-03-23 | Washington | Alabama | 1129 | 1 | 0 |
8522 | 8522 | 2020-03-23 | Washington | Georgia | 13303 | 1 | 0 |
8566 | 8566 | 2020-03-23 | Washington | Illinois | 17189 | 1 | 0 |
9136 | 9136 | 2020-03-23 | Washington | Ohio | 39167 | 1 | 0 |
9506 | 9506 | 2020-03-24 | Washington | Alabama | 1129 | 1 | 0 |
9783 | 9783 | 2020-03-24 | Washington | Georgia | 13303 | 1 | 0 |
9830 | 9830 | 2020-03-24 | Washington | Illinois | 17189 | 1 | 0 |
10452 | 10452 | 2020-03-24 | Washington | Ohio | 39167 | 1 | 0 |
10875 | 10875 | 2020-03-25 | Washington | Alabama | 1129 | 1 | 0 |
11223 | 11223 | 2020-03-25 | Washington | Illinois | 17189 | 1 | 0 |
11904 | 11904 | 2020-03-25 | Washington | Ohio | 39167 | 1 | 0 |
12560 | 12560 | 2020-03-26 | Washington | Colorado | 8121 | 1 | 0 |
12621 | 12621 | 2020-03-26 | Washington | Florida | 12133 | 1 | 0 |
12779 | 12779 | 2020-03-26 | Washington | Illinois | 17189 | 1 | 0 |
13513 | 13513 | 2020-03-26 | Washington | Ohio | 39167 | 1 | 0 |
13922 | 13922 | 2020-03-26 | Washington | Virginia | 51191 | 1 | 0 |
14229 | 14229 | 2020-03-27 | Washington | Colorado | 8121 | 1 | 0 |
14292 | 14292 | 2020-03-27 | Washington | Florida | 12133 | 1 | 0 |
14457 | 14457 | 2020-03-27 | Washington | Illinois | 17189 | 1 | 0 |
15690 | 15690 | 2020-03-27 | Washington | Virginia | 51191 | 1 | 0 |
16013 | 16013 | 2020-03-28 | Washington | Colorado | 8121 | 1 | 0 |
16077 | 16077 | 2020-03-28 | Washington | Florida | 12133 | 1 | 0 |
16254 | 16254 | 2020-03-28 | Washington | Illinois | 17189 | 1 | 0 |
17570 | 17570 | 2020-03-28 | Washington | Virginia | 51191 | 1 | 0 |
17905 | 17905 | 2020-03-29 | Washington | Colorado | 8121 | 1 | 0 |
17971 | 17971 | 2020-03-29 | Washington | Florida | 12133 | 1 | 0 |
18155 | 18155 | 2020-03-29 | Washington | Illinois | 17189 | 1 | 0 |
18946 | 18946 | 2020-03-29 | Washington | North Carolina | 37187 | 1 | 0 |
19884 | 19884 | 2020-03-30 | Washington | Colorado | 8121 | 1 | 0 |
19952 | 19952 | 2020-03-30 | Washington | Florida | 12133 | 1 | 0 |
20161 | 20161 | 2020-03-30 | Washington | Illinois | 17189 | 1 | 0 |
20987 | 20987 | 2020-03-30 | Washington | North Carolina | 37187 | 1 | 0 |
21961 | 21961 | 2020-03-31 | Washington | Colorado | 8121 | 1 | 0 |
22031 | 22031 | 2020-03-31 | Washington | Florida | 12133 | 1 | 0 |
22254 | 22254 | 2020-03-31 | Washington | Illinois | 17189 | 1 | 0 |
24120 | 24120 | 2020-04-01 | Washington | Colorado | 8121 | 1 | 0 |
24194 | 24194 | 2020-04-01 | Washington | Florida | 12133 | 1 | 0 |
24424 | 24424 | 2020-04-01 | Washington | Illinois | 17189 | 1 | 0 |
26350 | 26350 | 2020-04-02 | Washington | Colorado | 8121 | 1 | 0 |
26425 | 26425 | 2020-04-02 | Washington | Florida | 12133 | 1 | 0 |
26605 | 26605 | 2020-04-02 | Washington | Idaho | 16087 | 1 | 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);