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 cases
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 |
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 |
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 |
1465 | 1465 | 2020-03-12 | Jefferson | Louisiana | 22051 | 1 | 0 |
1603 | 1603 | 2020-03-12 | Jefferson | Washington | 53031 | 1 | 0 |
1629 | 1629 | 2020-03-13 | Jefferson | Arkansas | 5069 | 1 | 0 |
1873 | 1873 | 2020-03-13 | Jefferson | Tennessee | 47089 | 1 | 0 |
1914 | 1914 | 2020-03-13 | Jefferson | Washington | 53031 | 1 | 0 |
2238 | 2238 | 2020-03-14 | Jefferson | Tennessee | 47089 | 1 | 0 |
2287 | 2287 | 2020-03-14 | Jefferson | Washington | 53031 | 1 | 0 |
2663 | 2663 | 2020-03-15 | Jefferson | Tennessee | 47089 | 1 | 0 |
3129 | 3129 | 2020-03-16 | Jefferson | Tennessee | 47089 | 1 | 0 |
3662 | 3662 | 2020-03-17 | Jefferson | Tennessee | 47089 | 1 | 0 |
3745 | 3745 | 2020-03-17 | Jefferson | West Virginia | 54037 | 1 | 0 |
4146 | 4146 | 2020-03-18 | Jefferson | New York | 36045 | 1 | 0 |
4283 | 4283 | 2020-03-18 | Jefferson | Tennessee | 47089 | 1 | 0 |
4380 | 4380 | 2020-03-18 | Jefferson | West Virginia | 54037 | 1 | 0 |
4875 | 4875 | 2020-03-19 | Jefferson | New York | 36045 | 1 | 0 |
5030 | 5030 | 2020-03-19 | Jefferson | Tennessee | 47089 | 1 | 0 |
5137 | 5137 | 2020-03-19 | Jefferson | West Virginia | 54037 | 1 | 0 |
5724 | 5724 | 2020-03-20 | Jefferson | New York | 36045 | 1 | 0 |
5917 | 5917 | 2020-03-20 | Jefferson | Tennessee | 47089 | 1 | 0 |
6058 | 6058 | 2020-03-20 | Jefferson | Wisconsin | 55055 | 1 | 0 |
6718 | 6718 | 2020-03-21 | Jefferson | New York | 36045 | 1 | 0 |
6930 | 6930 | 2020-03-21 | Jefferson | Tennessee | 47089 | 1 | 0 |
7091 | 7091 | 2020-03-21 | Jefferson | Wisconsin | 55055 | 1 | 0 |
7812 | 7812 | 2020-03-22 | Jefferson | New York | 36045 | 1 | 0 |
10227 | 10227 | 2020-03-24 | Jefferson | Montana | 30043 | 1 | 0 |
11657 | 11657 | 2020-03-25 | Jefferson | Montana | 30043 | 1 | 0 |
12891 | 12891 | 2020-03-26 | Jefferson | Kansas | 20087 | 1 | 0 |
13255 | 13255 | 2020-03-26 | Jefferson | Montana | 30043 | 1 | 0 |
13486 | 13486 | 2020-03-26 | Jefferson | Ohio | 39081 | 1 | 0 |
14591 | 14591 | 2020-03-27 | Jefferson | Kansas | 20087 | 1 | 0 |
14881 | 14881 | 2020-03-27 | Jefferson | Mississippi | 28063 | 1 | 0 |
15224 | 15224 | 2020-03-27 | Jefferson | Ohio | 39081 | 1 | 0 |
16398 | 16398 | 2020-03-28 | Jefferson | Kansas | 20087 | 1 | 0 |
16705 | 16705 | 2020-03-28 | Jefferson | Mississippi | 28063 | 1 | 0 |
18304 | 18304 | 2020-03-29 | Jefferson | Kansas | 20087 | 1 | 0 |
18627 | 18627 | 2020-03-29 | Jefferson | Mississippi | 28063 | 1 | 0 |
20022 | 20022 | 2020-03-30 | Jefferson | Georgia | 13163 | 1 | 0 |
20317 | 20317 | 2020-03-30 | Jefferson | Kansas | 20087 | 1 | 0 |
20651 | 20651 | 2020-03-30 | Jefferson | Mississippi | 28063 | 1 | 0 |
22294 | 22294 | 2020-03-31 | Jefferson | Indiana | 18077 | 1 | 0 |
22415 | 22415 | 2020-03-31 | Jefferson | Kansas | 20087 | 1 | 0 |
22768 | 22768 | 2020-03-31 | Jefferson | Mississippi | 28063 | 1 | 0 |
24465 | 24465 | 2020-04-01 | Jefferson | Indiana | 18077 | 1 | 0 |
24590 | 24590 | 2020-04-01 | Jefferson | Kansas | 20087 | 1 | 0 |
24952 | 24952 | 2020-04-01 | Jefferson | Mississippi | 28063 | 1 | 0 |
26783 | 26783 | 2020-04-02 | Jefferson | Iowa | 19101 | 1 | 0 |
26834 | 26834 | 2020-04-02 | Jefferson | Kansas | 20087 | 1 | 0 |
27206 | 27206 | 2020-04-02 | Jefferson | Mississippi | 28063 | 1 | 0 |
29525 | 29525 | 2020-04-03 | Jefferson | Mississippi | 28063 | 1 | 0 |
31055 | 31055 | 2020-04-04 | Jefferson | Florida | 12065 | 1 | 0 |
33461 | 33461 | 2020-04-05 | Jefferson | Florida | 12065 | 1 | 0 |
36160 | 36160 | 2020-04-06 | Jefferson | Illinois | 17081 | 1 | 0 |
37327 | 37327 | 2020-04-06 | Jefferson | Oklahoma | 40067 | 1 | 0 |
39847 | 39847 | 2020-04-07 | Jefferson | Oklahoma | 40067 | 1 | 0 |
39944 | 39944 | 2020-04-07 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
42407 | 42407 | 2020-04-08 | Jefferson | Oklahoma | 40067 | 1 | 0 |
42504 | 42504 | 2020-04-08 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
44993 | 44993 | 2020-04-09 | Jefferson | Oklahoma | 40067 | 1 | 0 |
45090 | 45090 | 2020-04-09 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
47608 | 47608 | 2020-04-10 | Jefferson | Oklahoma | 40067 | 1 | 0 |
47707 | 47707 | 2020-04-10 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
50264 | 50264 | 2020-04-11 | Jefferson | Oklahoma | 40067 | 1 | 0 |
50364 | 50364 | 2020-04-11 | Jefferson | Pennsylvania | 42065 | 1 | 0 |
52937 | 52937 | 2020-04-12 | Jefferson | Oklahoma | 40067 | 1 | 0 |
55622 | 55622 | 2020-04-13 | Jefferson | Oklahoma | 40067 | 1 | 0 |
58323 | 58323 | 2020-04-14 | Jefferson | Oklahoma | 40067 | 1 | 0 |
58374 | 58374 | 2020-04-14 | Jefferson | Oregon | 41031 | 1 | 0 |
61038 | 61038 | 2020-04-15 | Jefferson | Oklahoma | 40067 | 1 | 0 |
61089 | 61089 | 2020-04-15 | Jefferson | Oregon | 41031 | 1 | 0 |
63764 | 63764 | 2020-04-16 | Jefferson | Oklahoma | 40067 | 1 | 0 |
63815 | 63815 | 2020-04-16 | Jefferson | Oregon | 41031 | 1 | 0 |
66508 | 66508 | 2020-04-17 | Jefferson | Oklahoma | 40067 | 1 | 0 |
66561 | 66561 | 2020-04-17 | Jefferson | Oregon | 41031 | 1 | 0 |
69266 | 69266 | 2020-04-18 | Jefferson | Oklahoma | 40067 | 1 | 0 |
69319 | 69319 | 2020-04-18 | Jefferson | Oregon | 41031 | 1 | 0 |
72033 | 72033 | 2020-04-19 | Jefferson | Oklahoma | 40067 | 1 | 0 |
72086 | 72086 | 2020-04-19 | Jefferson | Oregon | 41031 | 1 | 0 |
74808 | 74808 | 2020-04-20 | Jefferson | Oklahoma | 40067 | 1 | 0 |
74861 | 74861 | 2020-04-20 | Jefferson | Oregon | 41031 | 1 | 0 |
77643 | 77643 | 2020-04-21 | Jefferson | Oregon | 41031 | 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);