ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Columbia", fips = 13073 and state = "Georgia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3892 | 3892 | 2020-03-18 | Columbia | Georgia | 13073 | 1 | 0 |
4562 | 4562 | 2020-03-19 | Columbia | Georgia | 13073 | 1 | 0 |
5344 | 5344 | 2020-03-20 | Columbia | Georgia | 13073 | 1 | 0 |
6277 | 6277 | 2020-03-21 | Columbia | Georgia | 13073 | 3 | 0 |
7323 | 7323 | 2020-03-22 | Columbia | Georgia | 13073 | 3 | 0 |
8471 | 8471 | 2020-03-23 | Columbia | Georgia | 13073 | 3 | 0 |
9721 | 9721 | 2020-03-24 | Columbia | Georgia | 13073 | 6 | 0 |
11096 | 11096 | 2020-03-25 | Columbia | Georgia | 13073 | 10 | 0 |
12645 | 12645 | 2020-03-26 | Columbia | Georgia | 13073 | 10 | 0 |
14317 | 14317 | 2020-03-27 | Columbia | Georgia | 13073 | 10 | 0 |
16103 | 16103 | 2020-03-28 | Columbia | Georgia | 13073 | 12 | 0 |
18000 | 18000 | 2020-03-29 | Columbia | Georgia | 13073 | 12 | 0 |
19986 | 19986 | 2020-03-30 | Columbia | Georgia | 13073 | 14 | 0 |
22065 | 22065 | 2020-03-31 | Columbia | Georgia | 13073 | 24 | 0 |
24228 | 24228 | 2020-04-01 | Columbia | Georgia | 13073 | 24 | 0 |
26459 | 26459 | 2020-04-02 | Columbia | Georgia | 13073 | 27 | 0 |
28762 | 28762 | 2020-04-03 | Columbia | Georgia | 13073 | 33 | 0 |
31122 | 31122 | 2020-04-04 | Columbia | Georgia | 13073 | 36 | 0 |
33528 | 33528 | 2020-04-05 | Columbia | Georgia | 13073 | 36 | 0 |
35976 | 35976 | 2020-04-06 | Columbia | Georgia | 13073 | 40 | 0 |
38468 | 38468 | 2020-04-07 | Columbia | Georgia | 13073 | 46 | 0 |
41012 | 41012 | 2020-04-08 | Columbia | Georgia | 13073 | 50 | 0 |
43586 | 43586 | 2020-04-09 | Columbia | Georgia | 13073 | 58 | 0 |
46188 | 46188 | 2020-04-10 | Columbia | Georgia | 13073 | 65 | 0 |
48818 | 48818 | 2020-04-11 | Columbia | Georgia | 13073 | 68 | 0 |
51479 | 51479 | 2020-04-12 | Columbia | Georgia | 13073 | 69 | 0 |
54159 | 54159 | 2020-04-13 | Columbia | Georgia | 13073 | 71 | 0 |
56851 | 56851 | 2020-04-14 | Columbia | Georgia | 13073 | 75 | 0 |
59558 | 59558 | 2020-04-15 | Columbia | Georgia | 13073 | 79 | 0 |
62278 | 62278 | 2020-04-16 | Columbia | Georgia | 13073 | 87 | 0 |
65011 | 65011 | 2020-04-17 | Columbia | Georgia | 13073 | 91 | 1 |
67759 | 67759 | 2020-04-18 | Columbia | Georgia | 13073 | 100 | 1 |
70521 | 70521 | 2020-04-19 | Columbia | Georgia | 13073 | 101 | 1 |
73290 | 73290 | 2020-04-20 | Columbia | Georgia | 13073 | 116 | 2 |
76066 | 76066 | 2020-04-21 | Columbia | Georgia | 13073 | 122 | 2 |
78850 | 78850 | 2020-04-22 | Columbia | Georgia | 13073 | 124 | 2 |
81643 | 81643 | 2020-04-23 | Columbia | Georgia | 13073 | 129 | 2 |
84443 | 84443 | 2020-04-24 | Columbia | Georgia | 13073 | 137 | 2 |
87252 | 87252 | 2020-04-25 | Columbia | Georgia | 13073 | 138 | 2 |
90068 | 90068 | 2020-04-26 | Columbia | Georgia | 13073 | 143 | 2 |
92887 | 92887 | 2020-04-27 | Columbia | Georgia | 13073 | 144 | 2 |
95719 | 95719 | 2020-04-28 | Columbia | Georgia | 13073 | 149 | 3 |
98564 | 98564 | 2020-04-29 | Columbia | Georgia | 13073 | 156 | 4 |
101414 | 101414 | 2020-04-30 | Columbia | Georgia | 13073 | 160 | 4 |
104269 | 104269 | 2020-05-01 | Columbia | Georgia | 13073 | 162 | 4 |
107134 | 107134 | 2020-05-02 | Columbia | Georgia | 13073 | 163 | 4 |
110003 | 110003 | 2020-05-03 | Columbia | Georgia | 13073 | 164 | 4 |
112878 | 112878 | 2020-05-04 | Columbia | Georgia | 13073 | 168 | 4 |
115761 | 115761 | 2020-05-05 | Columbia | Georgia | 13073 | 169 | 5 |
118721 | 118721 | 2020-05-06 | Columbia | Georgia | 13073 | 170 | 5 |
121690 | 121690 | 2020-05-07 | Columbia | Georgia | 13073 | 170 | 5 |
124669 | 124669 | 2020-05-08 | Columbia | Georgia | 13073 | 178 | 5 |
127656 | 127656 | 2020-05-09 | Columbia | Georgia | 13073 | 179 | 5 |
130647 | 130647 | 2020-05-10 | Columbia | Georgia | 13073 | 183 | 5 |
133638 | 133638 | 2020-05-11 | Columbia | Georgia | 13073 | 183 | 5 |
136627 | 136627 | 2020-05-12 | Columbia | Georgia | 13073 | 186 | 6 |
139618 | 139618 | 2020-05-13 | Columbia | Georgia | 13073 | 191 | 6 |
142614 | 142614 | 2020-05-14 | Columbia | Georgia | 13073 | 197 | 6 |
145614 | 145614 | 2020-05-15 | Columbia | Georgia | 13073 | 202 | 6 |
148617 | 148617 | 2020-05-16 | Columbia | Georgia | 13073 | 205 | 6 |
151626 | 151626 | 2020-05-17 | Columbia | Georgia | 13073 | 205 | 6 |
154638 | 154638 | 2020-05-18 | Columbia | Georgia | 13073 | 212 | 6 |
157654 | 157654 | 2020-05-19 | Columbia | Georgia | 13073 | 212 | 6 |
160680 | 160680 | 2020-05-20 | Columbia | Georgia | 13073 | 214 | 6 |
163708 | 163708 | 2020-05-21 | Columbia | Georgia | 13073 | 224 | 6 |
166741 | 166741 | 2020-05-22 | Columbia | Georgia | 13073 | 223 | 6 |
169778 | 169778 | 2020-05-23 | Columbia | Georgia | 13073 | 223 | 6 |
172819 | 172819 | 2020-05-24 | Columbia | Georgia | 13073 | 223 | 6 |
175862 | 175862 | 2020-05-25 | Columbia | Georgia | 13073 | 224 | 6 |
178906 | 178906 | 2020-05-26 | Columbia | Georgia | 13073 | 229 | 7 |
181950 | 181950 | 2020-05-27 | Columbia | Georgia | 13073 | 237 | 7 |
185004 | 185004 | 2020-05-28 | Columbia | Georgia | 13073 | 243 | 7 |
188060 | 188060 | 2020-05-29 | Columbia | Georgia | 13073 | 248 | 7 |
191125 | 191125 | 2020-05-30 | Columbia | Georgia | 13073 | 248 | 7 |
194192 | 194192 | 2020-05-31 | Columbia | Georgia | 13073 | 248 | 7 |
197262 | 197262 | 2020-06-01 | Columbia | Georgia | 13073 | 251 | 8 |
200335 | 200335 | 2020-06-02 | Columbia | Georgia | 13073 | 251 | 8 |
203411 | 203411 | 2020-06-03 | Columbia | Georgia | 13073 | 266 | 8 |
206491 | 206491 | 2020-06-04 | Columbia | Georgia | 13073 | 266 | 8 |
209572 | 209572 | 2020-06-05 | Columbia | Georgia | 13073 | 270 | 8 |
212657 | 212657 | 2020-06-06 | Columbia | Georgia | 13073 | 274 | 8 |
215744 | 215744 | 2020-06-07 | Columbia | Georgia | 13073 | 274 | 8 |
218835 | 218835 | 2020-06-08 | Columbia | Georgia | 13073 | 278 | 8 |
221930 | 221930 | 2020-06-09 | Columbia | Georgia | 13073 | 288 | 8 |
225025 | 225025 | 2020-06-10 | Columbia | Georgia | 13073 | 289 | 8 |
228127 | 228127 | 2020-06-11 | Columbia | Georgia | 13073 | 290 | 8 |
231230 | 231230 | 2020-06-12 | Columbia | Georgia | 13073 | 295 | 8 |
234336 | 234336 | 2020-06-13 | Columbia | Georgia | 13073 | 296 | 8 |
237443 | 237443 | 2020-06-14 | Columbia | Georgia | 13073 | 300 | 8 |
240551 | 240551 | 2020-06-15 | Columbia | Georgia | 13073 | 301 | 8 |
243662 | 243662 | 2020-06-16 | Columbia | Georgia | 13073 | 305 | 8 |
246775 | 246775 | 2020-06-17 | Columbia | Georgia | 13073 | 324 | 8 |
249887 | 249887 | 2020-06-18 | Columbia | Georgia | 13073 | 329 | 8 |
253002 | 253002 | 2020-06-19 | Columbia | Georgia | 13073 | 335 | 8 |
256121 | 256121 | 2020-06-20 | Columbia | Georgia | 13073 | 339 | 8 |
259248 | 259248 | 2020-06-21 | Columbia | Georgia | 13073 | 342 | 8 |
262375 | 262375 | 2020-06-22 | Columbia | Georgia | 13073 | 345 | 8 |
265503 | 265503 | 2020-06-23 | Columbia | Georgia | 13073 | 359 | 8 |
268633 | 268633 | 2020-06-24 | Columbia | Georgia | 13073 | 367 | 9 |
271769 | 271769 | 2020-06-25 | Columbia | Georgia | 13073 | 377 | 9 |
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);