ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Lee" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386415 | 386415 | 2020-07-31 | Lee | Georgia | 13177 | 501 | 22 |
383197 | 383197 | 2020-07-30 | Lee | Georgia | 13177 | 496 | 22 |
379980 | 379980 | 2020-07-29 | Lee | Georgia | 13177 | 490 | 22 |
376763 | 376763 | 2020-07-28 | Lee | Georgia | 13177 | 488 | 22 |
373549 | 373549 | 2020-07-27 | Lee | Georgia | 13177 | 483 | 22 |
370337 | 370337 | 2020-07-26 | Lee | Georgia | 13177 | 480 | 22 |
367127 | 367127 | 2020-07-25 | Lee | Georgia | 13177 | 480 | 22 |
363920 | 363920 | 2020-07-24 | Lee | Georgia | 13177 | 472 | 22 |
360713 | 360713 | 2020-07-23 | Lee | Georgia | 13177 | 464 | 22 |
357508 | 357508 | 2020-07-22 | Lee | Georgia | 13177 | 457 | 22 |
354305 | 354305 | 2020-07-21 | Lee | Georgia | 13177 | 454 | 22 |
351103 | 351103 | 2020-07-20 | Lee | Georgia | 13177 | 449 | 22 |
347902 | 347902 | 2020-07-19 | Lee | Georgia | 13177 | 448 | 22 |
344702 | 344702 | 2020-07-18 | Lee | Georgia | 13177 | 446 | 22 |
341503 | 341503 | 2020-07-17 | Lee | Georgia | 13177 | 441 | 22 |
338306 | 338306 | 2020-07-16 | Lee | Georgia | 13177 | 439 | 22 |
335111 | 335111 | 2020-07-15 | Lee | Georgia | 13177 | 436 | 22 |
331918 | 331918 | 2020-07-14 | Lee | Georgia | 13177 | 432 | 22 |
328731 | 328731 | 2020-07-13 | Lee | Georgia | 13177 | 426 | 22 |
325545 | 325545 | 2020-07-12 | Lee | Georgia | 13177 | 423 | 22 |
322364 | 322364 | 2020-07-11 | Lee | Georgia | 13177 | 418 | 22 |
319185 | 319185 | 2020-07-10 | Lee | Georgia | 13177 | 418 | 22 |
316012 | 316012 | 2020-07-09 | Lee | Georgia | 13177 | 414 | 22 |
312837 | 312837 | 2020-07-08 | Lee | Georgia | 13177 | 413 | 22 |
309667 | 309667 | 2020-07-07 | Lee | Georgia | 13177 | 410 | 22 |
306499 | 306499 | 2020-07-06 | Lee | Georgia | 13177 | 405 | 22 |
303335 | 303335 | 2020-07-05 | Lee | Georgia | 13177 | 402 | 22 |
300171 | 300171 | 2020-07-04 | Lee | Georgia | 13177 | 398 | 22 |
297009 | 297009 | 2020-07-03 | Lee | Georgia | 13177 | 397 | 22 |
293853 | 293853 | 2020-07-02 | Lee | Georgia | 13177 | 393 | 22 |
290699 | 290699 | 2020-07-01 | Lee | Georgia | 13177 | 390 | 22 |
287548 | 287548 | 2020-06-30 | Lee | Georgia | 13177 | 388 | 22 |
284402 | 284402 | 2020-06-29 | Lee | Georgia | 13177 | 385 | 22 |
281256 | 281256 | 2020-06-28 | Lee | Georgia | 13177 | 385 | 22 |
278109 | 278109 | 2020-06-27 | Lee | Georgia | 13177 | 385 | 22 |
274961 | 274961 | 2020-06-26 | Lee | Georgia | 13177 | 386 | 22 |
271821 | 271821 | 2020-06-25 | Lee | Georgia | 13177 | 386 | 22 |
268685 | 268685 | 2020-06-24 | Lee | Georgia | 13177 | 386 | 22 |
265555 | 265555 | 2020-06-23 | Lee | Georgia | 13177 | 385 | 22 |
262427 | 262427 | 2020-06-22 | Lee | Georgia | 13177 | 381 | 22 |
259300 | 259300 | 2020-06-21 | Lee | Georgia | 13177 | 378 | 22 |
256173 | 256173 | 2020-06-20 | Lee | Georgia | 13177 | 377 | 22 |
253054 | 253054 | 2020-06-19 | Lee | Georgia | 13177 | 377 | 22 |
249939 | 249939 | 2020-06-18 | Lee | Georgia | 13177 | 374 | 22 |
246827 | 246827 | 2020-06-17 | Lee | Georgia | 13177 | 372 | 22 |
243714 | 243714 | 2020-06-16 | Lee | Georgia | 13177 | 374 | 22 |
240603 | 240603 | 2020-06-15 | Lee | Georgia | 13177 | 374 | 22 |
237495 | 237495 | 2020-06-14 | Lee | Georgia | 13177 | 372 | 22 |
234388 | 234388 | 2020-06-13 | Lee | Georgia | 13177 | 372 | 22 |
231282 | 231282 | 2020-06-12 | Lee | Georgia | 13177 | 371 | 22 |
228179 | 228179 | 2020-06-11 | Lee | Georgia | 13177 | 370 | 22 |
225077 | 225077 | 2020-06-10 | Lee | Georgia | 13177 | 369 | 22 |
221982 | 221982 | 2020-06-09 | Lee | Georgia | 13177 | 368 | 22 |
218887 | 218887 | 2020-06-08 | Lee | Georgia | 13177 | 367 | 22 |
215796 | 215796 | 2020-06-07 | Lee | Georgia | 13177 | 366 | 22 |
212709 | 212709 | 2020-06-06 | Lee | Georgia | 13177 | 365 | 22 |
209624 | 209624 | 2020-06-05 | Lee | Georgia | 13177 | 361 | 22 |
206543 | 206543 | 2020-06-04 | Lee | Georgia | 13177 | 361 | 22 |
203463 | 203463 | 2020-06-03 | Lee | Georgia | 13177 | 361 | 22 |
200387 | 200387 | 2020-06-02 | Lee | Georgia | 13177 | 361 | 22 |
197314 | 197314 | 2020-06-01 | Lee | Georgia | 13177 | 361 | 22 |
194244 | 194244 | 2020-05-31 | Lee | Georgia | 13177 | 361 | 22 |
191177 | 191177 | 2020-05-30 | Lee | Georgia | 13177 | 361 | 22 |
188112 | 188112 | 2020-05-29 | Lee | Georgia | 13177 | 361 | 22 |
185056 | 185056 | 2020-05-28 | Lee | Georgia | 13177 | 361 | 22 |
182002 | 182002 | 2020-05-27 | Lee | Georgia | 13177 | 363 | 23 |
178958 | 178958 | 2020-05-26 | Lee | Georgia | 13177 | 362 | 22 |
175914 | 175914 | 2020-05-25 | Lee | Georgia | 13177 | 354 | 22 |
172871 | 172871 | 2020-05-24 | Lee | Georgia | 13177 | 343 | 22 |
169830 | 169830 | 2020-05-23 | Lee | Georgia | 13177 | 342 | 22 |
166793 | 166793 | 2020-05-22 | Lee | Georgia | 13177 | 342 | 22 |
163760 | 163760 | 2020-05-21 | Lee | Georgia | 13177 | 340 | 22 |
160732 | 160732 | 2020-05-20 | Lee | Georgia | 13177 | 345 | 23 |
157706 | 157706 | 2020-05-19 | Lee | Georgia | 13177 | 343 | 23 |
154690 | 154690 | 2020-05-18 | Lee | Georgia | 13177 | 341 | 23 |
151678 | 151678 | 2020-05-17 | Lee | Georgia | 13177 | 342 | 23 |
148669 | 148669 | 2020-05-16 | Lee | Georgia | 13177 | 344 | 23 |
145666 | 145666 | 2020-05-15 | Lee | Georgia | 13177 | 344 | 23 |
142666 | 142666 | 2020-05-14 | Lee | Georgia | 13177 | 343 | 22 |
139670 | 139670 | 2020-05-13 | Lee | Georgia | 13177 | 343 | 22 |
136679 | 136679 | 2020-05-12 | Lee | Georgia | 13177 | 343 | 22 |
133690 | 133690 | 2020-05-11 | Lee | Georgia | 13177 | 340 | 22 |
130699 | 130699 | 2020-05-10 | Lee | Georgia | 13177 | 340 | 22 |
127708 | 127708 | 2020-05-09 | Lee | Georgia | 13177 | 339 | 22 |
124721 | 124721 | 2020-05-08 | Lee | Georgia | 13177 | 339 | 22 |
121742 | 121742 | 2020-05-07 | Lee | Georgia | 13177 | 339 | 22 |
118772 | 118772 | 2020-05-06 | Lee | Georgia | 13177 | 338 | 22 |
115812 | 115812 | 2020-05-05 | Lee | Georgia | 13177 | 333 | 22 |
112929 | 112929 | 2020-05-04 | Lee | Georgia | 13177 | 329 | 20 |
110054 | 110054 | 2020-05-03 | Lee | Georgia | 13177 | 328 | 20 |
107185 | 107185 | 2020-05-02 | Lee | Georgia | 13177 | 327 | 20 |
104320 | 104320 | 2020-05-01 | Lee | Georgia | 13177 | 322 | 20 |
101465 | 101465 | 2020-04-30 | Lee | Georgia | 13177 | 319 | 20 |
98615 | 98615 | 2020-04-29 | Lee | Georgia | 13177 | 314 | 20 |
95770 | 95770 | 2020-04-28 | Lee | Georgia | 13177 | 312 | 19 |
92938 | 92938 | 2020-04-27 | Lee | Georgia | 13177 | 307 | 19 |
90119 | 90119 | 2020-04-26 | Lee | Georgia | 13177 | 302 | 18 |
87303 | 87303 | 2020-04-25 | Lee | Georgia | 13177 | 299 | 18 |
84494 | 84494 | 2020-04-24 | Lee | Georgia | 13177 | 297 | 18 |
81694 | 81694 | 2020-04-23 | Lee | Georgia | 13177 | 298 | 19 |
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);