ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20,291 rows where county = "Jefferson" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 26
- Colorado 800
- Washington 799
- Kentucky 797
- Louisiana 796
- Arkansas 794
- Alabama 792
- Tennessee 792
- West Virginia 788
- New York 787
- Wisconsin 785
- Missouri 781
- Montana 781
- Texas 781
- Idaho 780
- Kansas 779
- Ohio 779
- Mississippi 778
- Georgia 775
- Indiana 774
- Iowa 772
- Florida 770
- Illinois 768
- Oklahoma 768
- Pennsylvania 767
- Oregon 760
- Nebraska 748
fips 26
county 1
- Jefferson · 20,291 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
550 | 550 | 2020-03-05 | Jefferson | Colorado | 8059 | 1 | 0 |
604 | 604 | 2020-03-06 | Jefferson | Colorado | 8059 | 1 | 0 |
649 | 649 | 2020-03-06 | Jefferson | Washington | 53031 | 1 | 0 |
682 | 682 | 2020-03-07 | Jefferson | Colorado | 8059 | 1 | 0 |
743 | 743 | 2020-03-07 | Jefferson | Washington | 53031 | 1 | 0 |
777 | 777 | 2020-03-08 | Jefferson | Colorado | 8059 | 1 | 0 |
801 | 801 | 2020-03-08 | Jefferson | Kentucky | 21111 | 1 | 0 |
855 | 855 | 2020-03-08 | Jefferson | Washington | 53031 | 1 | 0 |
893 | 893 | 2020-03-09 | Jefferson | Colorado | 8059 | 1 | 0 |
923 | 923 | 2020-03-09 | Jefferson | Kentucky | 21111 | 1 | 0 |
924 | 924 | 2020-03-09 | Jefferson | Louisiana | 22051 | 1 | 0 |
986 | 986 | 2020-03-09 | Jefferson | Washington | 53031 | 1 | 0 |
1028 | 1028 | 2020-03-10 | Jefferson | Colorado | 8059 | 2 | 0 |
1068 | 1068 | 2020-03-10 | Jefferson | Kentucky | 21111 | 1 | 0 |
1069 | 1069 | 2020-03-10 | Jefferson | Louisiana | 22051 | 1 | 0 |
1149 | 1149 | 2020-03-10 | Jefferson | Washington | 53031 | 1 | 0 |
1164 | 1164 | 2020-03-11 | Jefferson | Arkansas | 5069 | 1 | 0 |
1195 | 1195 | 2020-03-11 | Jefferson | Colorado | 8059 | 4 | 0 |
1246 | 1246 | 2020-03-11 | Jefferson | Kentucky | 21111 | 1 | 0 |
1248 | 1248 | 2020-03-11 | Jefferson | Louisiana | 22051 | 1 | 0 |
1349 | 1349 | 2020-03-11 | Jefferson | Washington | 53031 | 1 | 0 |
1369 | 1369 | 2020-03-12 | Jefferson | Arkansas | 5069 | 1 | 0 |
1403 | 1403 | 2020-03-12 | Jefferson | Colorado | 8059 | 5 | 0 |
1462 | 1462 | 2020-03-12 | Jefferson | Kentucky | 21111 | 2 | 0 |
1465 | 1465 | 2020-03-12 | Jefferson | Louisiana | 22051 | 1 | 0 |
1603 | 1603 | 2020-03-12 | Jefferson | Washington | 53031 | 1 | 0 |
1621 | 1621 | 2020-03-13 | Jefferson | Alabama | 1073 | 2 | 0 |
1629 | 1629 | 2020-03-13 | Jefferson | Arkansas | 5069 | 1 | 0 |
1665 | 1665 | 2020-03-13 | Jefferson | Colorado | 8059 | 7 | 0 |
1735 | 1735 | 2020-03-13 | Jefferson | Kentucky | 21111 | 2 | 0 |
1738 | 1738 | 2020-03-13 | Jefferson | Louisiana | 22051 | 3 | 0 |
1873 | 1873 | 2020-03-13 | Jefferson | Tennessee | 47089 | 1 | 0 |
1914 | 1914 | 2020-03-13 | Jefferson | Washington | 53031 | 1 | 0 |
1937 | 1937 | 2020-03-14 | Jefferson | Alabama | 1073 | 6 | 0 |
1946 | 1946 | 2020-03-14 | Jefferson | Arkansas | 5069 | 2 | 0 |
1984 | 1984 | 2020-03-14 | Jefferson | Colorado | 8059 | 9 | 0 |
2071 | 2071 | 2020-03-14 | Jefferson | Kentucky | 21111 | 4 | 0 |
2076 | 2076 | 2020-03-14 | Jefferson | Louisiana | 22051 | 11 | 0 |
2238 | 2238 | 2020-03-14 | Jefferson | Tennessee | 47089 | 1 | 0 |
2287 | 2287 | 2020-03-14 | Jefferson | Washington | 53031 | 1 | 0 |
2312 | 2312 | 2020-03-15 | Jefferson | Alabama | 1073 | 13 | 0 |
2324 | 2324 | 2020-03-15 | Jefferson | Arkansas | 5069 | 5 | 0 |
2366 | 2366 | 2020-03-15 | Jefferson | Colorado | 8059 | 12 | 0 |
2468 | 2468 | 2020-03-15 | Jefferson | Kentucky | 21111 | 6 | 0 |
2473 | 2473 | 2020-03-15 | Jefferson | Louisiana | 22051 | 14 | 0 |
2663 | 2663 | 2020-03-15 | Jefferson | Tennessee | 47089 | 1 | 0 |
2714 | 2714 | 2020-03-15 | Jefferson | Washington | 53031 | 3 | 0 |
2741 | 2741 | 2020-03-16 | Jefferson | Alabama | 1073 | 17 | 0 |
2757 | 2757 | 2020-03-16 | Jefferson | Arkansas | 5069 | 5 | 0 |
2801 | 2801 | 2020-03-16 | Jefferson | Colorado | 8059 | 17 | 0 |
2913 | 2913 | 2020-03-16 | Jefferson | Kentucky | 21111 | 7 | 0 |
2919 | 2919 | 2020-03-16 | Jefferson | Louisiana | 22051 | 21 | 0 |
3129 | 3129 | 2020-03-16 | Jefferson | Tennessee | 47089 | 1 | 0 |
3188 | 3188 | 2020-03-16 | Jefferson | Washington | 53031 | 3 | 0 |
3217 | 3217 | 2020-03-17 | Jefferson | Alabama | 1073 | 21 | 0 |
3237 | 3237 | 2020-03-17 | Jefferson | Arkansas | 5069 | 5 | 0 |
3283 | 3283 | 2020-03-17 | Jefferson | Colorado | 8059 | 17 | 0 |
3408 | 3408 | 2020-03-17 | Jefferson | Kentucky | 21111 | 9 | 0 |
3416 | 3416 | 2020-03-17 | Jefferson | Louisiana | 22051 | 35 | 0 |
3662 | 3662 | 2020-03-17 | Jefferson | Tennessee | 47089 | 1 | 0 |
3729 | 3729 | 2020-03-17 | Jefferson | Washington | 53031 | 4 | 0 |
3745 | 3745 | 2020-03-17 | Jefferson | West Virginia | 54037 | 1 | 0 |
3764 | 3764 | 2020-03-18 | Jefferson | Alabama | 1073 | 25 | 0 |
3789 | 3789 | 2020-03-18 | Jefferson | Arkansas | 5069 | 10 | 0 |
3837 | 3837 | 2020-03-18 | Jefferson | Colorado | 8059 | 25 | 0 |
3986 | 3986 | 2020-03-18 | Jefferson | Kentucky | 21111 | 11 | 0 |
3996 | 3996 | 2020-03-18 | Jefferson | Louisiana | 22051 | 45 | 1 |
4146 | 4146 | 2020-03-18 | Jefferson | New York | 36045 | 1 | 0 |
4283 | 4283 | 2020-03-18 | Jefferson | Tennessee | 47089 | 1 | 0 |
4364 | 4364 | 2020-03-18 | Jefferson | Washington | 53031 | 4 | 0 |
4380 | 4380 | 2020-03-18 | Jefferson | West Virginia | 54037 | 1 | 0 |
4405 | 4405 | 2020-03-19 | Jefferson | Alabama | 1073 | 34 | 0 |
4442 | 4442 | 2020-03-19 | Jefferson | Arkansas | 5069 | 18 | 0 |
4499 | 4499 | 2020-03-19 | Jefferson | Colorado | 8059 | 36 | 0 |
4674 | 4674 | 2020-03-19 | Jefferson | Kentucky | 21111 | 14 | 1 |
4691 | 4691 | 2020-03-19 | Jefferson | Louisiana | 22051 | 69 | 1 |
4875 | 4875 | 2020-03-19 | Jefferson | New York | 36045 | 1 | 0 |
5030 | 5030 | 2020-03-19 | Jefferson | Tennessee | 47089 | 1 | 0 |
5121 | 5121 | 2020-03-19 | Jefferson | Washington | 53031 | 4 | 0 |
5137 | 5137 | 2020-03-19 | Jefferson | West Virginia | 54037 | 1 | 0 |
5173 | 5173 | 2020-03-20 | Jefferson | Alabama | 1073 | 50 | 0 |
5214 | 5214 | 2020-03-20 | Jefferson | Arkansas | 5069 | 19 | 0 |
5275 | 5275 | 2020-03-20 | Jefferson | Colorado | 8059 | 37 | 0 |
5488 | 5488 | 2020-03-20 | Jefferson | Kentucky | 21111 | 23 | 1 |
5507 | 5507 | 2020-03-20 | Jefferson | Louisiana | 22051 | 104 | 1 |
5724 | 5724 | 2020-03-20 | Jefferson | New York | 36045 | 1 | 0 |
5917 | 5917 | 2020-03-20 | Jefferson | Tennessee | 47089 | 1 | 0 |
6023 | 6023 | 2020-03-20 | Jefferson | Washington | 53031 | 4 | 0 |
6042 | 6042 | 2020-03-20 | Jefferson | West Virginia | 54037 | 2 | 0 |
6058 | 6058 | 2020-03-20 | Jefferson | Wisconsin | 55055 | 1 | 0 |
6089 | 6089 | 2020-03-21 | Jefferson | Alabama | 1073 | 61 | 0 |
6133 | 6133 | 2020-03-21 | Jefferson | Arkansas | 5069 | 19 | 0 |
6201 | 6201 | 2020-03-21 | Jefferson | Colorado | 8059 | 43 | 0 |
6434 | 6434 | 2020-03-21 | Jefferson | Kentucky | 21111 | 25 | 1 |
6460 | 6460 | 2020-03-21 | Jefferson | Louisiana | 22051 | 166 | 2 |
6718 | 6718 | 2020-03-21 | Jefferson | New York | 36045 | 1 | 0 |
6930 | 6930 | 2020-03-21 | Jefferson | Tennessee | 47089 | 1 | 0 |
7054 | 7054 | 2020-03-21 | Jefferson | Washington | 53031 | 4 | 0 |
7073 | 7073 | 2020-03-21 | Jefferson | West Virginia | 54037 | 2 | 0 |
7091 | 7091 | 2020-03-21 | Jefferson | Wisconsin | 55055 | 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);