ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,557 rows where county = "Effingham" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4567 | 4567 | 2020-03-19 | Effingham | Georgia | 13103 | 1 | 0 |
5351 | 5351 | 2020-03-20 | Effingham | Georgia | 13103 | 1 | 0 |
6284 | 6284 | 2020-03-21 | Effingham | Georgia | 13103 | 1 | 0 |
7330 | 7330 | 2020-03-22 | Effingham | Georgia | 13103 | 2 | 0 |
8478 | 8478 | 2020-03-23 | Effingham | Georgia | 13103 | 2 | 0 |
9729 | 9729 | 2020-03-24 | Effingham | Georgia | 13103 | 3 | 0 |
11106 | 11106 | 2020-03-25 | Effingham | Georgia | 13103 | 3 | 0 |
12655 | 12655 | 2020-03-26 | Effingham | Georgia | 13103 | 3 | 0 |
14327 | 14327 | 2020-03-27 | Effingham | Georgia | 13103 | 4 | 0 |
16113 | 16113 | 2020-03-28 | Effingham | Georgia | 13103 | 4 | 0 |
18010 | 18010 | 2020-03-29 | Effingham | Georgia | 13103 | 4 | 0 |
19999 | 19999 | 2020-03-30 | Effingham | Georgia | 13103 | 4 | 0 |
22078 | 22078 | 2020-03-31 | Effingham | Georgia | 13103 | 5 | 0 |
24241 | 24241 | 2020-04-01 | Effingham | Georgia | 13103 | 5 | 0 |
26472 | 26472 | 2020-04-02 | Effingham | Georgia | 13103 | 6 | 0 |
28775 | 28775 | 2020-04-03 | Effingham | Georgia | 13103 | 6 | 0 |
28928 | 28928 | 2020-04-03 | Effingham | Illinois | 17049 | 1 | 0 |
31135 | 31135 | 2020-04-04 | Effingham | Georgia | 13103 | 9 | 0 |
31290 | 31290 | 2020-04-04 | Effingham | Illinois | 17049 | 1 | 0 |
33542 | 33542 | 2020-04-05 | Effingham | Georgia | 13103 | 12 | 1 |
33699 | 33699 | 2020-04-05 | Effingham | Illinois | 17049 | 1 | 0 |
35991 | 35991 | 2020-04-06 | Effingham | Georgia | 13103 | 14 | 1 |
36150 | 36150 | 2020-04-06 | Effingham | Illinois | 17049 | 1 | 0 |
38483 | 38483 | 2020-04-07 | Effingham | Georgia | 13103 | 18 | 1 |
38645 | 38645 | 2020-04-07 | Effingham | Illinois | 17049 | 1 | 0 |
41027 | 41027 | 2020-04-08 | Effingham | Georgia | 13103 | 19 | 1 |
41189 | 41189 | 2020-04-08 | Effingham | Illinois | 17049 | 2 | 0 |
43601 | 43601 | 2020-04-09 | Effingham | Georgia | 13103 | 19 | 1 |
43763 | 43763 | 2020-04-09 | Effingham | Illinois | 17049 | 3 | 1 |
46203 | 46203 | 2020-04-10 | Effingham | Georgia | 13103 | 20 | 1 |
46365 | 46365 | 2020-04-10 | Effingham | Illinois | 17049 | 3 | 1 |
48833 | 48833 | 2020-04-11 | Effingham | Georgia | 13103 | 20 | 1 |
48996 | 48996 | 2020-04-11 | Effingham | Illinois | 17049 | 3 | 1 |
51494 | 51494 | 2020-04-12 | Effingham | Georgia | 13103 | 22 | 1 |
51658 | 51658 | 2020-04-12 | Effingham | Illinois | 17049 | 3 | 1 |
54174 | 54174 | 2020-04-13 | Effingham | Georgia | 13103 | 23 | 1 |
54338 | 54338 | 2020-04-13 | Effingham | Illinois | 17049 | 3 | 1 |
56866 | 56866 | 2020-04-14 | Effingham | Georgia | 13103 | 25 | 1 |
57031 | 57031 | 2020-04-14 | Effingham | Illinois | 17049 | 3 | 1 |
59573 | 59573 | 2020-04-15 | Effingham | Georgia | 13103 | 24 | 1 |
59738 | 59738 | 2020-04-15 | Effingham | Illinois | 17049 | 3 | 1 |
62293 | 62293 | 2020-04-16 | Effingham | Georgia | 13103 | 24 | 1 |
62459 | 62459 | 2020-04-16 | Effingham | Illinois | 17049 | 4 | 1 |
65026 | 65026 | 2020-04-17 | Effingham | Georgia | 13103 | 25 | 1 |
65191 | 65191 | 2020-04-17 | Effingham | Illinois | 17049 | 3 | 1 |
67774 | 67774 | 2020-04-18 | Effingham | Georgia | 13103 | 25 | 1 |
67939 | 67939 | 2020-04-18 | Effingham | Illinois | 17049 | 4 | 1 |
70536 | 70536 | 2020-04-19 | Effingham | Georgia | 13103 | 26 | 1 |
70701 | 70701 | 2020-04-19 | Effingham | Illinois | 17049 | 4 | 1 |
73305 | 73305 | 2020-04-20 | Effingham | Georgia | 13103 | 27 | 1 |
73471 | 73471 | 2020-04-20 | Effingham | Illinois | 17049 | 4 | 1 |
76081 | 76081 | 2020-04-21 | Effingham | Georgia | 13103 | 29 | 1 |
76247 | 76247 | 2020-04-21 | Effingham | Illinois | 17049 | 5 | 1 |
78865 | 78865 | 2020-04-22 | Effingham | Georgia | 13103 | 30 | 1 |
79031 | 79031 | 2020-04-22 | Effingham | Illinois | 17049 | 5 | 1 |
81658 | 81658 | 2020-04-23 | Effingham | Georgia | 13103 | 33 | 1 |
81824 | 81824 | 2020-04-23 | Effingham | Illinois | 17049 | 5 | 1 |
84458 | 84458 | 2020-04-24 | Effingham | Georgia | 13103 | 34 | 1 |
84624 | 84624 | 2020-04-24 | Effingham | Illinois | 17049 | 5 | 1 |
87267 | 87267 | 2020-04-25 | Effingham | Georgia | 13103 | 34 | 1 |
87434 | 87434 | 2020-04-25 | Effingham | Illinois | 17049 | 5 | 1 |
90083 | 90083 | 2020-04-26 | Effingham | Georgia | 13103 | 34 | 1 |
90250 | 90250 | 2020-04-26 | Effingham | Illinois | 17049 | 5 | 1 |
92902 | 92902 | 2020-04-27 | Effingham | Georgia | 13103 | 34 | 1 |
93069 | 93069 | 2020-04-27 | Effingham | Illinois | 17049 | 5 | 1 |
95734 | 95734 | 2020-04-28 | Effingham | Georgia | 13103 | 34 | 1 |
95901 | 95901 | 2020-04-28 | Effingham | Illinois | 17049 | 5 | 1 |
98579 | 98579 | 2020-04-29 | Effingham | Georgia | 13103 | 34 | 1 |
98745 | 98745 | 2020-04-29 | Effingham | Illinois | 17049 | 6 | 1 |
101429 | 101429 | 2020-04-30 | Effingham | Georgia | 13103 | 35 | 1 |
101596 | 101596 | 2020-04-30 | Effingham | Illinois | 17049 | 5 | 1 |
104284 | 104284 | 2020-05-01 | Effingham | Georgia | 13103 | 36 | 1 |
104452 | 104452 | 2020-05-01 | Effingham | Illinois | 17049 | 5 | 1 |
107149 | 107149 | 2020-05-02 | Effingham | Georgia | 13103 | 36 | 1 |
107317 | 107317 | 2020-05-02 | Effingham | Illinois | 17049 | 6 | 1 |
110018 | 110018 | 2020-05-03 | Effingham | Georgia | 13103 | 36 | 1 |
110187 | 110187 | 2020-05-03 | Effingham | Illinois | 17049 | 6 | 1 |
112893 | 112893 | 2020-05-04 | Effingham | Georgia | 13103 | 36 | 1 |
113062 | 113062 | 2020-05-04 | Effingham | Illinois | 17049 | 5 | 1 |
115776 | 115776 | 2020-05-05 | Effingham | Georgia | 13103 | 38 | 1 |
115945 | 115945 | 2020-05-05 | Effingham | Illinois | 17049 | 5 | 1 |
118736 | 118736 | 2020-05-06 | Effingham | Georgia | 13103 | 38 | 1 |
118905 | 118905 | 2020-05-06 | Effingham | Illinois | 17049 | 5 | 1 |
121705 | 121705 | 2020-05-07 | Effingham | Georgia | 13103 | 37 | 1 |
121875 | 121875 | 2020-05-07 | Effingham | Illinois | 17049 | 5 | 1 |
124684 | 124684 | 2020-05-08 | Effingham | Georgia | 13103 | 37 | 1 |
124854 | 124854 | 2020-05-08 | Effingham | Illinois | 17049 | 5 | 1 |
127671 | 127671 | 2020-05-09 | Effingham | Georgia | 13103 | 37 | 1 |
127841 | 127841 | 2020-05-09 | Effingham | Illinois | 17049 | 6 | 1 |
130662 | 130662 | 2020-05-10 | Effingham | Georgia | 13103 | 38 | 1 |
130832 | 130832 | 2020-05-10 | Effingham | Illinois | 17049 | 6 | 1 |
133653 | 133653 | 2020-05-11 | Effingham | Georgia | 13103 | 38 | 1 |
133823 | 133823 | 2020-05-11 | Effingham | Illinois | 17049 | 6 | 1 |
136642 | 136642 | 2020-05-12 | Effingham | Georgia | 13103 | 38 | 1 |
136812 | 136812 | 2020-05-12 | Effingham | Illinois | 17049 | 6 | 1 |
139633 | 139633 | 2020-05-13 | Effingham | Georgia | 13103 | 38 | 1 |
139804 | 139804 | 2020-05-13 | Effingham | Illinois | 17049 | 6 | 1 |
142629 | 142629 | 2020-05-14 | Effingham | Georgia | 13103 | 38 | 1 |
142800 | 142800 | 2020-05-14 | Effingham | Illinois | 17049 | 6 | 1 |
145629 | 145629 | 2020-05-15 | Effingham | Georgia | 13103 | 38 | 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);