ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19,457 rows where county = "Franklin" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 25
- Kansas 779
- Kentucky 779
- Maine 779
- Massachusetts 779
- Mississippi 779
- Missouri 779
- New York 779
- North Carolina 779
- Ohio 779
- Pennsylvania 779
- Tennessee 779
- Vermont 779
- Virginia 779
- Washington 779
- Alabama 778
- Georgia 778
- Illinois 778
- Indiana 778
- Louisiana 777
- Texas 776
- Florida 771
- Arkansas 768
- Iowa 768
- Nebraska 764
- Idaho 715
fips 25
county 1
- Franklin · 19,357 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12889 | 12889 | 2020-03-26 | Franklin | Kansas | 20059 | 1 | 0 |
12917 | 12917 | 2020-03-26 | Franklin | Kentucky | 21073 | 3 | 0 |
13005 | 13005 | 2020-03-26 | Franklin | Maine | 23007 | 1 | 0 |
13042 | 13042 | 2020-03-26 | Franklin | Massachusetts | 25011 | 16 | 1 |
13155 | 13155 | 2020-03-26 | Franklin | Mississippi | 28037 | 3 | 0 |
13223 | 13223 | 2020-03-26 | Franklin | Missouri | 29071 | 4 | 0 |
13350 | 13350 | 2020-03-26 | Franklin | New York | 36033 | 1 | 0 |
13409 | 13409 | 2020-03-26 | Franklin | North Carolina | 37069 | 5 | 0 |
13478 | 13478 | 2020-03-26 | Franklin | Ohio | 39049 | 109 | 2 |
13593 | 13593 | 2020-03-26 | Franklin | Pennsylvania | 42055 | 5 | 0 |
13698 | 13698 | 2020-03-26 | Franklin | Tennessee | 47051 | 3 | 0 |
13848 | 13848 | 2020-03-26 | Franklin | Vermont | 50011 | 4 | 0 |
13875 | 13875 | 2020-03-26 | Franklin | Virginia | 51067 | 1 | 0 |
13934 | 13934 | 2020-03-26 | Franklin | Washington | 53021 | 7 | 0 |
14048 | 14048 | 2020-03-27 | Franklin | Alabama | 1059 | 3 | 0 |
14332 | 14332 | 2020-03-27 | Franklin | Georgia | 13119 | 1 | 0 |
14433 | 14433 | 2020-03-27 | Franklin | Illinois | 17055 | 1 | 0 |
14480 | 14480 | 2020-03-27 | Franklin | Indiana | 18047 | 22 | 1 |
14587 | 14587 | 2020-03-27 | Franklin | Kansas | 20059 | 2 | 0 |
14622 | 14622 | 2020-03-27 | Franklin | Kentucky | 21073 | 3 | 0 |
14713 | 14713 | 2020-03-27 | Franklin | Maine | 23007 | 1 | 0 |
14750 | 14750 | 2020-03-27 | Franklin | Massachusetts | 25011 | 24 | 2 |
14871 | 14871 | 2020-03-27 | Franklin | Mississippi | 28037 | 3 | 0 |
14948 | 14948 | 2020-03-27 | Franklin | Missouri | 29071 | 4 | 0 |
15084 | 15084 | 2020-03-27 | Franklin | New York | 36033 | 2 | 0 |
15143 | 15143 | 2020-03-27 | Franklin | North Carolina | 37069 | 5 | 0 |
15215 | 15215 | 2020-03-27 | Franklin | Ohio | 39049 | 152 | 2 |
15339 | 15339 | 2020-03-27 | Franklin | Pennsylvania | 42055 | 5 | 0 |
15450 | 15450 | 2020-03-27 | Franklin | Tennessee | 47051 | 3 | 0 |
15614 | 15614 | 2020-03-27 | Franklin | Vermont | 50011 | 6 | 0 |
15642 | 15642 | 2020-03-27 | Franklin | Virginia | 51067 | 1 | 0 |
15702 | 15702 | 2020-03-27 | Franklin | Washington | 53021 | 12 | 0 |
15826 | 15826 | 2020-03-28 | Franklin | Alabama | 1059 | 3 | 0 |
16118 | 16118 | 2020-03-28 | Franklin | Georgia | 13119 | 2 | 0 |
16228 | 16228 | 2020-03-28 | Franklin | Illinois | 17055 | 1 | 0 |
16278 | 16278 | 2020-03-28 | Franklin | Indiana | 18047 | 23 | 2 |
16394 | 16394 | 2020-03-28 | Franklin | Kansas | 20059 | 6 | 0 |
16436 | 16436 | 2020-03-28 | Franklin | Kentucky | 21073 | 2 | 0 |
16491 | 16491 | 2020-03-28 | Franklin | Louisiana | 22041 | 4 | 0 |
16533 | 16533 | 2020-03-28 | Franklin | Maine | 23007 | 2 | 0 |
16570 | 16570 | 2020-03-28 | Franklin | Massachusetts | 25011 | 39 | 2 |
16695 | 16695 | 2020-03-28 | Franklin | Mississippi | 28037 | 3 | 0 |
16772 | 16772 | 2020-03-28 | Franklin | Missouri | 29071 | 6 | 0 |
16914 | 16914 | 2020-03-28 | Franklin | New York | 36033 | 4 | 0 |
16975 | 16975 | 2020-03-28 | Franklin | North Carolina | 37069 | 5 | 0 |
17057 | 17057 | 2020-03-28 | Franklin | Ohio | 39049 | 222 | 2 |
17188 | 17188 | 2020-03-28 | Franklin | Pennsylvania | 42055 | 7 | 0 |
17311 | 17311 | 2020-03-28 | Franklin | Tennessee | 47051 | 3 | 0 |
17488 | 17488 | 2020-03-28 | Franklin | Vermont | 50011 | 7 | 0 |
17516 | 17516 | 2020-03-28 | Franklin | Virginia | 51067 | 1 | 0 |
17582 | 17582 | 2020-03-28 | Franklin | Washington | 53021 | 16 | 0 |
17709 | 17709 | 2020-03-29 | Franklin | Alabama | 1059 | 3 | 0 |
18015 | 18015 | 2020-03-29 | Franklin | Georgia | 13119 | 2 | 0 |
18127 | 18127 | 2020-03-29 | Franklin | Illinois | 17055 | 2 | 0 |
18180 | 18180 | 2020-03-29 | Franklin | Indiana | 18047 | 26 | 3 |
18300 | 18300 | 2020-03-29 | Franklin | Kansas | 20059 | 6 | 0 |
18346 | 18346 | 2020-03-29 | Franklin | Kentucky | 21073 | 3 | 0 |
18403 | 18403 | 2020-03-29 | Franklin | Louisiana | 22041 | 4 | 0 |
18447 | 18447 | 2020-03-29 | Franklin | Maine | 23007 | 2 | 0 |
18485 | 18485 | 2020-03-29 | Franklin | Massachusetts | 25011 | 41 | 2 |
18617 | 18617 | 2020-03-29 | Franklin | Mississippi | 28037 | 3 | 0 |
18694 | 18694 | 2020-03-29 | Franklin | Missouri | 29071 | 7 | 0 |
18838 | 18838 | 2020-03-29 | Franklin | New York | 36033 | 6 | 0 |
18905 | 18905 | 2020-03-29 | Franklin | North Carolina | 37069 | 5 | 0 |
18991 | 18991 | 2020-03-29 | Franklin | Ohio | 39049 | 247 | 2 |
19126 | 19126 | 2020-03-29 | Franklin | Pennsylvania | 42055 | 11 | 0 |
19257 | 19257 | 2020-03-29 | Franklin | Tennessee | 47051 | 6 | 0 |
19346 | 19346 | 2020-03-29 | Franklin | Texas | 48159 | 1 | 0 |
19447 | 19447 | 2020-03-29 | Franklin | Vermont | 50011 | 9 | 0 |
19476 | 19476 | 2020-03-29 | Franklin | Virginia | 51067 | 5 | 0 |
19547 | 19547 | 2020-03-29 | Franklin | Washington | 53021 | 32 | 0 |
19680 | 19680 | 2020-03-30 | Franklin | Alabama | 1059 | 3 | 0 |
20004 | 20004 | 2020-03-30 | Franklin | Georgia | 13119 | 4 | 0 |
20129 | 20129 | 2020-03-30 | Franklin | Illinois | 17055 | 1 | 0 |
20186 | 20186 | 2020-03-30 | Franklin | Indiana | 18047 | 28 | 4 |
20313 | 20313 | 2020-03-30 | Franklin | Kansas | 20059 | 6 | 0 |
20360 | 20360 | 2020-03-30 | Franklin | Kentucky | 21073 | 3 | 0 |
20419 | 20419 | 2020-03-30 | Franklin | Louisiana | 22041 | 5 | 0 |
20463 | 20463 | 2020-03-30 | Franklin | Maine | 23007 | 2 | 0 |
20501 | 20501 | 2020-03-30 | Franklin | Massachusetts | 25011 | 49 | 2 |
20641 | 20641 | 2020-03-30 | Franklin | Mississippi | 28037 | 3 | 0 |
20720 | 20720 | 2020-03-30 | Franklin | Missouri | 29071 | 7 | 0 |
20877 | 20877 | 2020-03-30 | Franklin | New York | 36033 | 6 | 0 |
20945 | 20945 | 2020-03-30 | Franklin | North Carolina | 37069 | 6 | 0 |
21035 | 21035 | 2020-03-30 | Franklin | Ohio | 39049 | 281 | 2 |
21176 | 21176 | 2020-03-30 | Franklin | Pennsylvania | 42055 | 12 | 0 |
21311 | 21311 | 2020-03-30 | Franklin | Tennessee | 47051 | 5 | 0 |
21405 | 21405 | 2020-03-30 | Franklin | Texas | 48159 | 1 | 0 |
21510 | 21510 | 2020-03-30 | Franklin | Vermont | 50011 | 11 | 0 |
21539 | 21539 | 2020-03-30 | Franklin | Virginia | 51067 | 5 | 0 |
21614 | 21614 | 2020-03-30 | Franklin | Washington | 53021 | 32 | 0 |
21752 | 21752 | 2020-03-31 | Franklin | Alabama | 1059 | 3 | 0 |
22084 | 22084 | 2020-03-31 | Franklin | Georgia | 13119 | 4 | 0 |
22221 | 22221 | 2020-03-31 | Franklin | Illinois | 17055 | 1 | 0 |
22280 | 22280 | 2020-03-31 | Franklin | Indiana | 18047 | 35 | 4 |
22411 | 22411 | 2020-03-31 | Franklin | Kansas | 20059 | 7 | 0 |
22461 | 22461 | 2020-03-31 | Franklin | Kentucky | 21073 | 6 | 0 |
22527 | 22527 | 2020-03-31 | Franklin | Louisiana | 22041 | 5 | 0 |
22572 | 22572 | 2020-03-31 | Franklin | Maine | 23007 | 2 | 0 |
22610 | 22610 | 2020-03-31 | Franklin | Massachusetts | 25011 | 61 | 4 |
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);