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)
date (date) >30 ✖
- 2020-05-29 25
- 2020-05-30 25
- 2020-05-31 25
- 2020-06-01 25
- 2020-06-02 25
- 2020-06-03 25
- 2020-06-04 25
- 2020-06-05 25
- 2020-06-06 25
- 2020-06-07 25
- 2020-06-08 25
- 2020-06-09 25
- 2020-06-10 25
- 2020-06-11 25
- 2020-06-12 25
- 2020-06-13 25
- 2020-06-14 25
- 2020-06-15 25
- 2020-06-16 25
- 2020-06-17 25
- 2020-06-18 25
- 2020-06-19 25
- 2020-06-20 25
- 2020-06-21 25
- 2020-06-22 25
- 2020-06-23 25
- 2020-06-24 25
- 2020-06-25 25
- 2020-06-26 25
- 2020-06-27 25
- …
state 25
- Kansas 791
- Ohio 791
- Indiana 788
- Washington 788
- Kentucky 787
- Massachusetts 787
- Mississippi 785
- North Carolina 785
- Pennsylvania 785
- Vermont 784
- Virginia 784
- Tennessee 783
- Alabama 782
- Missouri 781
- New York 780
- Georgia 779
- Illinois 779
- Maine 779
- Louisiana 777
- Texas 776
- Florida 771
- Arkansas 768
- Iowa 768
- Nebraska 764
- Idaho 715
fips 25
county 1
- Franklin · 19,457 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2065 | 2065 | 2020-03-14 | Franklin | Kansas | 20059 | 1 | 0 |
2189 | 2189 | 2020-03-14 | Franklin | Ohio | 39049 | 1 | 0 |
2461 | 2461 | 2020-03-15 | Franklin | Kansas | 20059 | 1 | 0 |
2603 | 2603 | 2020-03-15 | Franklin | Ohio | 39049 | 3 | 0 |
2906 | 2906 | 2020-03-16 | Franklin | Kansas | 20059 | 1 | 0 |
3065 | 3065 | 2020-03-16 | Franklin | Ohio | 39049 | 3 | 0 |
3378 | 3378 | 2020-03-17 | Franklin | Indiana | 18047 | 2 | 0 |
3401 | 3401 | 2020-03-17 | Franklin | Kansas | 20059 | 1 | 0 |
3590 | 3590 | 2020-03-17 | Franklin | Ohio | 39049 | 4 | 0 |
3725 | 3725 | 2020-03-17 | Franklin | Washington | 53021 | 1 | 0 |
3950 | 3950 | 2020-03-18 | Franklin | Indiana | 18047 | 2 | 0 |
3977 | 3977 | 2020-03-18 | Franklin | Kansas | 20059 | 1 | 0 |
3984 | 3984 | 2020-03-18 | Franklin | Kentucky | 21073 | 1 | 0 |
4029 | 4029 | 2020-03-18 | Franklin | Massachusetts | 25011 | 1 | 0 |
4203 | 4203 | 2020-03-18 | Franklin | Ohio | 39049 | 7 | 0 |
4360 | 4360 | 2020-03-18 | Franklin | Washington | 53021 | 1 | 0 |
4626 | 4626 | 2020-03-19 | Franklin | Indiana | 18047 | 2 | 0 |
4659 | 4659 | 2020-03-19 | Franklin | Kansas | 20059 | 1 | 0 |
4671 | 4671 | 2020-03-19 | Franklin | Kentucky | 21073 | 1 | 0 |
4733 | 4733 | 2020-03-19 | Franklin | Massachusetts | 25011 | 1 | 0 |
4934 | 4934 | 2020-03-19 | Franklin | Ohio | 39049 | 10 | 0 |
5117 | 5117 | 2020-03-19 | Franklin | Washington | 53021 | 1 | 0 |
5433 | 5433 | 2020-03-20 | Franklin | Indiana | 18047 | 2 | 0 |
5470 | 5470 | 2020-03-20 | Franklin | Kansas | 20059 | 1 | 0 |
5485 | 5485 | 2020-03-20 | Franklin | Kentucky | 21073 | 1 | 0 |
5552 | 5552 | 2020-03-20 | Franklin | Massachusetts | 25011 | 1 | 0 |
5608 | 5608 | 2020-03-20 | Franklin | Mississippi | 28037 | 1 | 0 |
5759 | 5759 | 2020-03-20 | Franklin | North Carolina | 37069 | 4 | 0 |
5797 | 5797 | 2020-03-20 | Franklin | Ohio | 39049 | 14 | 0 |
5856 | 5856 | 2020-03-20 | Franklin | Pennsylvania | 42055 | 1 | 0 |
6019 | 6019 | 2020-03-20 | Franklin | Washington | 53021 | 1 | 0 |
6370 | 6370 | 2020-03-21 | Franklin | Indiana | 18047 | 2 | 0 |
6415 | 6415 | 2020-03-21 | Franklin | Kansas | 20059 | 1 | 0 |
6431 | 6431 | 2020-03-21 | Franklin | Kentucky | 21073 | 1 | 0 |
6511 | 6511 | 2020-03-21 | Franklin | Massachusetts | 25011 | 2 | 0 |
6584 | 6584 | 2020-03-21 | Franklin | Mississippi | 28037 | 2 | 0 |
6756 | 6756 | 2020-03-21 | Franklin | North Carolina | 37069 | 4 | 0 |
6797 | 6797 | 2020-03-21 | Franklin | Ohio | 39049 | 21 | 0 |
6859 | 6859 | 2020-03-21 | Franklin | Pennsylvania | 42055 | 1 | 0 |
7006 | 7006 | 2020-03-21 | Franklin | Vermont | 50011 | 2 | 0 |
7022 | 7022 | 2020-03-21 | Franklin | Virginia | 51067 | 1 | 0 |
7050 | 7050 | 2020-03-21 | Franklin | Washington | 53021 | 1 | 0 |
7424 | 7424 | 2020-03-22 | Franklin | Indiana | 18047 | 4 | 0 |
7482 | 7482 | 2020-03-22 | Franklin | Kansas | 20059 | 1 | 0 |
7502 | 7502 | 2020-03-22 | Franklin | Kentucky | 21073 | 1 | 0 |
7588 | 7588 | 2020-03-22 | Franklin | Massachusetts | 25011 | 2 | 0 |
7667 | 7667 | 2020-03-22 | Franklin | Mississippi | 28037 | 3 | 0 |
7855 | 7855 | 2020-03-22 | Franklin | North Carolina | 37069 | 4 | 0 |
7905 | 7905 | 2020-03-22 | Franklin | Ohio | 39049 | 34 | 0 |
7977 | 7977 | 2020-03-22 | Franklin | Pennsylvania | 42055 | 1 | 0 |
8050 | 8050 | 2020-03-22 | Franklin | Tennessee | 47051 | 1 | 0 |
8136 | 8136 | 2020-03-22 | Franklin | Vermont | 50011 | 2 | 0 |
8156 | 8156 | 2020-03-22 | Franklin | Virginia | 51067 | 1 | 0 |
8187 | 8187 | 2020-03-22 | Franklin | Washington | 53021 | 2 | 0 |
8260 | 8260 | 2020-03-23 | Franklin | Alabama | 1059 | 1 | 0 |
8582 | 8582 | 2020-03-23 | Franklin | Indiana | 18047 | 4 | 0 |
8643 | 8643 | 2020-03-23 | Franklin | Kansas | 20059 | 1 | 0 |
8664 | 8664 | 2020-03-23 | Franklin | Kentucky | 21073 | 2 | 0 |
8760 | 8760 | 2020-03-23 | Franklin | Massachusetts | 25011 | 2 | 0 |
8847 | 8847 | 2020-03-23 | Franklin | Mississippi | 28037 | 3 | 0 |
9056 | 9056 | 2020-03-23 | Franklin | North Carolina | 37069 | 4 | 0 |
9108 | 9108 | 2020-03-23 | Franklin | Ohio | 39049 | 46 | 2 |
9188 | 9188 | 2020-03-23 | Franklin | Pennsylvania | 42055 | 1 | 0 |
9268 | 9268 | 2020-03-23 | Franklin | Tennessee | 47051 | 1 | 0 |
9356 | 9356 | 2020-03-23 | Franklin | Vermont | 50011 | 2 | 0 |
9378 | 9378 | 2020-03-23 | Franklin | Virginia | 51067 | 1 | 0 |
9412 | 9412 | 2020-03-23 | Franklin | Washington | 53021 | 2 | 0 |
9487 | 9487 | 2020-03-24 | Franklin | Alabama | 1059 | 1 | 0 |
9849 | 9849 | 2020-03-24 | Franklin | Indiana | 18047 | 7 | 0 |
9924 | 9924 | 2020-03-24 | Franklin | Kansas | 20059 | 1 | 0 |
9947 | 9947 | 2020-03-24 | Franklin | Kentucky | 21073 | 2 | 0 |
10049 | 10049 | 2020-03-24 | Franklin | Massachusetts | 25011 | 5 | 0 |
10143 | 10143 | 2020-03-24 | Franklin | Mississippi | 28037 | 3 | 0 |
10203 | 10203 | 2020-03-24 | Franklin | Missouri | 29071 | 1 | 0 |
10364 | 10364 | 2020-03-24 | Franklin | North Carolina | 37069 | 5 | 0 |
10423 | 10423 | 2020-03-24 | Franklin | Ohio | 39049 | 75 | 2 |
10511 | 10511 | 2020-03-24 | Franklin | Pennsylvania | 42055 | 3 | 0 |
10597 | 10597 | 2020-03-24 | Franklin | Tennessee | 47051 | 1 | 0 |
10701 | 10701 | 2020-03-24 | Franklin | Vermont | 50011 | 2 | 0 |
10725 | 10725 | 2020-03-24 | Franklin | Virginia | 51067 | 1 | 0 |
10761 | 10761 | 2020-03-24 | Franklin | Washington | 53021 | 7 | 0 |
10851 | 10851 | 2020-03-25 | Franklin | Alabama | 1059 | 2 | 0 |
11243 | 11243 | 2020-03-25 | Franklin | Indiana | 18047 | 7 | 0 |
11322 | 11322 | 2020-03-25 | Franklin | Kansas | 20059 | 1 | 0 |
11347 | 11347 | 2020-03-25 | Franklin | Kentucky | 21073 | 3 | 0 |
11461 | 11461 | 2020-03-25 | Franklin | Massachusetts | 25011 | 14 | 0 |
11563 | 11563 | 2020-03-25 | Franklin | Mississippi | 28037 | 3 | 0 |
11625 | 11625 | 2020-03-25 | Franklin | Missouri | 29071 | 3 | 0 |
11747 | 11747 | 2020-03-25 | Franklin | New York | 36033 | 1 | 0 |
11805 | 11805 | 2020-03-25 | Franklin | North Carolina | 37069 | 5 | 0 |
11871 | 11871 | 2020-03-25 | Franklin | Ohio | 39049 | 88 | 2 |
11973 | 11973 | 2020-03-25 | Franklin | Pennsylvania | 42055 | 5 | 0 |
12074 | 12074 | 2020-03-25 | Franklin | Tennessee | 47051 | 1 | 0 |
12212 | 12212 | 2020-03-25 | Franklin | Vermont | 50011 | 3 | 0 |
12237 | 12237 | 2020-03-25 | Franklin | Virginia | 51067 | 1 | 0 |
12284 | 12284 | 2020-03-25 | Franklin | Washington | 53021 | 7 | 0 |
12388 | 12388 | 2020-03-26 | Franklin | Alabama | 1059 | 3 | 0 |
12660 | 12660 | 2020-03-26 | Franklin | Georgia | 13119 | 1 | 0 |
12757 | 12757 | 2020-03-26 | Franklin | Illinois | 17055 | 1 | 0 |
12800 | 12800 | 2020-03-26 | Franklin | Indiana | 18047 | 13 | 1 |
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);