ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "White" and state = "Georgia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11167 | 11167 | 2020-03-25 | White | Georgia | 13311 | 1 | 0 |
12720 | 12720 | 2020-03-26 | White | Georgia | 13311 | 1 | 0 |
14395 | 14395 | 2020-03-27 | White | Georgia | 13311 | 1 | 0 |
16186 | 16186 | 2020-03-28 | White | Georgia | 13311 | 1 | 0 |
18083 | 18083 | 2020-03-29 | White | Georgia | 13311 | 1 | 0 |
20079 | 20079 | 2020-03-30 | White | Georgia | 13311 | 1 | 0 |
22166 | 22166 | 2020-03-31 | White | Georgia | 13311 | 3 | 0 |
24332 | 24332 | 2020-04-01 | White | Georgia | 13311 | 3 | 0 |
26564 | 26564 | 2020-04-02 | White | Georgia | 13311 | 3 | 0 |
28871 | 28871 | 2020-04-03 | White | Georgia | 13311 | 3 | 0 |
31232 | 31232 | 2020-04-04 | White | Georgia | 13311 | 4 | 0 |
33639 | 33639 | 2020-04-05 | White | Georgia | 13311 | 4 | 0 |
36090 | 36090 | 2020-04-06 | White | Georgia | 13311 | 4 | 0 |
38583 | 38583 | 2020-04-07 | White | Georgia | 13311 | 10 | 0 |
41127 | 41127 | 2020-04-08 | White | Georgia | 13311 | 11 | 0 |
43701 | 43701 | 2020-04-09 | White | Georgia | 13311 | 11 | 0 |
46303 | 46303 | 2020-04-10 | White | Georgia | 13311 | 11 | 0 |
48934 | 48934 | 2020-04-11 | White | Georgia | 13311 | 11 | 0 |
51596 | 51596 | 2020-04-12 | White | Georgia | 13311 | 11 | 0 |
54276 | 54276 | 2020-04-13 | White | Georgia | 13311 | 11 | 0 |
56968 | 56968 | 2020-04-14 | White | Georgia | 13311 | 14 | 0 |
59675 | 59675 | 2020-04-15 | White | Georgia | 13311 | 14 | 0 |
62395 | 62395 | 2020-04-16 | White | Georgia | 13311 | 20 | 0 |
65128 | 65128 | 2020-04-17 | White | Georgia | 13311 | 20 | 0 |
67876 | 67876 | 2020-04-18 | White | Georgia | 13311 | 20 | 0 |
70638 | 70638 | 2020-04-19 | White | Georgia | 13311 | 20 | 0 |
73407 | 73407 | 2020-04-20 | White | Georgia | 13311 | 30 | 0 |
76183 | 76183 | 2020-04-21 | White | Georgia | 13311 | 32 | 0 |
78967 | 78967 | 2020-04-22 | White | Georgia | 13311 | 33 | 0 |
81760 | 81760 | 2020-04-23 | White | Georgia | 13311 | 36 | 0 |
84560 | 84560 | 2020-04-24 | White | Georgia | 13311 | 38 | 0 |
87369 | 87369 | 2020-04-25 | White | Georgia | 13311 | 38 | 0 |
90185 | 90185 | 2020-04-26 | White | Georgia | 13311 | 38 | 0 |
93004 | 93004 | 2020-04-27 | White | Georgia | 13311 | 48 | 0 |
95836 | 95836 | 2020-04-28 | White | Georgia | 13311 | 56 | 0 |
98680 | 98680 | 2020-04-29 | White | Georgia | 13311 | 59 | 0 |
101531 | 101531 | 2020-04-30 | White | Georgia | 13311 | 61 | 0 |
104386 | 104386 | 2020-05-01 | White | Georgia | 13311 | 63 | 0 |
107251 | 107251 | 2020-05-02 | White | Georgia | 13311 | 78 | 0 |
110121 | 110121 | 2020-05-03 | White | Georgia | 13311 | 78 | 0 |
112996 | 112996 | 2020-05-04 | White | Georgia | 13311 | 79 | 0 |
115879 | 115879 | 2020-05-05 | White | Georgia | 13311 | 83 | 1 |
118839 | 118839 | 2020-05-06 | White | Georgia | 13311 | 83 | 1 |
121809 | 121809 | 2020-05-07 | White | Georgia | 13311 | 87 | 2 |
124788 | 124788 | 2020-05-08 | White | Georgia | 13311 | 86 | 1 |
127775 | 127775 | 2020-05-09 | White | Georgia | 13311 | 88 | 1 |
130766 | 130766 | 2020-05-10 | White | Georgia | 13311 | 88 | 1 |
133757 | 133757 | 2020-05-11 | White | Georgia | 13311 | 88 | 1 |
136746 | 136746 | 2020-05-12 | White | Georgia | 13311 | 88 | 1 |
139737 | 139737 | 2020-05-13 | White | Georgia | 13311 | 88 | 1 |
142733 | 142733 | 2020-05-14 | White | Georgia | 13311 | 88 | 2 |
145733 | 145733 | 2020-05-15 | White | Georgia | 13311 | 89 | 2 |
148736 | 148736 | 2020-05-16 | White | Georgia | 13311 | 89 | 2 |
151745 | 151745 | 2020-05-17 | White | Georgia | 13311 | 89 | 2 |
154757 | 154757 | 2020-05-18 | White | Georgia | 13311 | 87 | 3 |
157773 | 157773 | 2020-05-19 | White | Georgia | 13311 | 90 | 3 |
160799 | 160799 | 2020-05-20 | White | Georgia | 13311 | 91 | 3 |
163827 | 163827 | 2020-05-21 | White | Georgia | 13311 | 91 | 3 |
166860 | 166860 | 2020-05-22 | White | Georgia | 13311 | 92 | 3 |
169897 | 169897 | 2020-05-23 | White | Georgia | 13311 | 93 | 3 |
172938 | 172938 | 2020-05-24 | White | Georgia | 13311 | 94 | 3 |
175981 | 175981 | 2020-05-25 | White | Georgia | 13311 | 94 | 3 |
179025 | 179025 | 2020-05-26 | White | Georgia | 13311 | 95 | 3 |
182069 | 182069 | 2020-05-27 | White | Georgia | 13311 | 98 | 3 |
185123 | 185123 | 2020-05-28 | White | Georgia | 13311 | 99 | 3 |
188179 | 188179 | 2020-05-29 | White | Georgia | 13311 | 101 | 3 |
191244 | 191244 | 2020-05-30 | White | Georgia | 13311 | 101 | 3 |
194311 | 194311 | 2020-05-31 | White | Georgia | 13311 | 101 | 3 |
197381 | 197381 | 2020-06-01 | White | Georgia | 13311 | 103 | 3 |
200454 | 200454 | 2020-06-02 | White | Georgia | 13311 | 103 | 3 |
203530 | 203530 | 2020-06-03 | White | Georgia | 13311 | 105 | 3 |
206610 | 206610 | 2020-06-04 | White | Georgia | 13311 | 110 | 3 |
209691 | 209691 | 2020-06-05 | White | Georgia | 13311 | 111 | 3 |
212776 | 212776 | 2020-06-06 | White | Georgia | 13311 | 113 | 3 |
215863 | 215863 | 2020-06-07 | White | Georgia | 13311 | 113 | 3 |
218954 | 218954 | 2020-06-08 | White | Georgia | 13311 | 114 | 3 |
222049 | 222049 | 2020-06-09 | White | Georgia | 13311 | 117 | 3 |
225144 | 225144 | 2020-06-10 | White | Georgia | 13311 | 117 | 3 |
228246 | 228246 | 2020-06-11 | White | Georgia | 13311 | 122 | 3 |
231349 | 231349 | 2020-06-12 | White | Georgia | 13311 | 124 | 3 |
234455 | 234455 | 2020-06-13 | White | Georgia | 13311 | 124 | 3 |
237562 | 237562 | 2020-06-14 | White | Georgia | 13311 | 124 | 3 |
240670 | 240670 | 2020-06-15 | White | Georgia | 13311 | 124 | 4 |
243781 | 243781 | 2020-06-16 | White | Georgia | 13311 | 124 | 4 |
246894 | 246894 | 2020-06-17 | White | Georgia | 13311 | 124 | 4 |
250006 | 250006 | 2020-06-18 | White | Georgia | 13311 | 125 | 4 |
253121 | 253121 | 2020-06-19 | White | Georgia | 13311 | 128 | 4 |
256240 | 256240 | 2020-06-20 | White | Georgia | 13311 | 129 | 4 |
259367 | 259367 | 2020-06-21 | White | Georgia | 13311 | 129 | 4 |
262494 | 262494 | 2020-06-22 | White | Georgia | 13311 | 129 | 4 |
265622 | 265622 | 2020-06-23 | White | Georgia | 13311 | 132 | 4 |
268752 | 268752 | 2020-06-24 | White | Georgia | 13311 | 134 | 4 |
271888 | 271888 | 2020-06-25 | White | Georgia | 13311 | 134 | 4 |
275028 | 275028 | 2020-06-26 | White | Georgia | 13311 | 136 | 4 |
278176 | 278176 | 2020-06-27 | White | Georgia | 13311 | 139 | 4 |
281323 | 281323 | 2020-06-28 | White | Georgia | 13311 | 139 | 4 |
284469 | 284469 | 2020-06-29 | White | Georgia | 13311 | 140 | 4 |
287615 | 287615 | 2020-06-30 | White | Georgia | 13311 | 142 | 4 |
290766 | 290766 | 2020-07-01 | White | Georgia | 13311 | 143 | 4 |
293920 | 293920 | 2020-07-02 | White | Georgia | 13311 | 145 | 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);