ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "DeKalb" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
632071 | 632071 | 2020-10-15 | DeKalb | Georgia | 13089 | 20810 | 384 |
628827 | 628827 | 2020-10-14 | DeKalb | Georgia | 13089 | 20698 | 383 |
625584 | 625584 | 2020-10-13 | DeKalb | Georgia | 13089 | 20638 | 382 |
622341 | 622341 | 2020-10-12 | DeKalb | Georgia | 13089 | 20584 | 380 |
619098 | 619098 | 2020-10-11 | DeKalb | Georgia | 13089 | 20498 | 380 |
615856 | 615856 | 2020-10-10 | DeKalb | Georgia | 13089 | 20409 | 378 |
612615 | 612615 | 2020-10-09 | DeKalb | Georgia | 13089 | 20367 | 378 |
609373 | 609373 | 2020-10-08 | DeKalb | Georgia | 13089 | 20269 | 375 |
606130 | 606130 | 2020-10-07 | DeKalb | Georgia | 13089 | 20185 | 374 |
602888 | 602888 | 2020-10-06 | DeKalb | Georgia | 13089 | 20059 | 373 |
599645 | 599645 | 2020-10-05 | DeKalb | Georgia | 13089 | 19962 | 372 |
596402 | 596402 | 2020-10-04 | DeKalb | Georgia | 13089 | 19128 | 371 |
593160 | 593160 | 2020-10-03 | DeKalb | Georgia | 13089 | 19084 | 371 |
589920 | 589920 | 2020-10-02 | DeKalb | Georgia | 13089 | 19030 | 371 |
586679 | 586679 | 2020-10-01 | DeKalb | Georgia | 13089 | 18938 | 369 |
583439 | 583439 | 2020-09-30 | DeKalb | Georgia | 13089 | 18859 | 367 |
580200 | 580200 | 2020-09-29 | DeKalb | Georgia | 13089 | 18773 | 365 |
576959 | 576959 | 2020-09-28 | DeKalb | Georgia | 13089 | 18699 | 364 |
573716 | 573716 | 2020-09-27 | DeKalb | Georgia | 13089 | 18647 | 362 |
570474 | 570474 | 2020-09-26 | DeKalb | Georgia | 13089 | 18600 | 360 |
567232 | 567232 | 2020-09-25 | DeKalb | Georgia | 13089 | 18521 | 358 |
563992 | 563992 | 2020-09-24 | DeKalb | Georgia | 13089 | 18418 | 357 |
560752 | 560752 | 2020-09-23 | DeKalb | Georgia | 13089 | 18302 | 353 |
557516 | 557516 | 2020-09-22 | DeKalb | Georgia | 13089 | 18192 | 351 |
554279 | 554279 | 2020-09-21 | DeKalb | Georgia | 13089 | 18110 | 349 |
551040 | 551040 | 2020-09-20 | DeKalb | Georgia | 13089 | 18072 | 349 |
547801 | 547801 | 2020-09-19 | DeKalb | Georgia | 13089 | 18006 | 349 |
544563 | 544563 | 2020-09-18 | DeKalb | Georgia | 13089 | 17907 | 346 |
541327 | 541327 | 2020-09-17 | DeKalb | Georgia | 13089 | 17849 | 345 |
538090 | 538090 | 2020-09-16 | DeKalb | Georgia | 13089 | 17777 | 340 |
534854 | 534854 | 2020-09-15 | DeKalb | Georgia | 13089 | 17698 | 340 |
531619 | 531619 | 2020-09-14 | DeKalb | Georgia | 13089 | 17610 | 339 |
528382 | 528382 | 2020-09-13 | DeKalb | Georgia | 13089 | 17536 | 339 |
525146 | 525146 | 2020-09-12 | DeKalb | Georgia | 13089 | 17477 | 335 |
521910 | 521910 | 2020-09-11 | DeKalb | Georgia | 13089 | 17380 | 334 |
518673 | 518673 | 2020-09-10 | DeKalb | Georgia | 13089 | 17314 | 333 |
515438 | 515438 | 2020-09-09 | DeKalb | Georgia | 13089 | 17237 | 324 |
512205 | 512205 | 2020-09-08 | DeKalb | Georgia | 13089 | 17169 | 318 |
508972 | 508972 | 2020-09-07 | DeKalb | Georgia | 13089 | 17100 | 315 |
505740 | 505740 | 2020-09-06 | DeKalb | Georgia | 13089 | 17089 | 315 |
502506 | 502506 | 2020-09-05 | DeKalb | Georgia | 13089 | 17004 | 313 |
499272 | 499272 | 2020-09-04 | DeKalb | Georgia | 13089 | 16900 | 311 |
496039 | 496039 | 2020-09-03 | DeKalb | Georgia | 13089 | 16837 | 311 |
492805 | 492805 | 2020-09-02 | DeKalb | Georgia | 13089 | 16716 | 309 |
489572 | 489572 | 2020-09-01 | DeKalb | Georgia | 13089 | 16650 | 304 |
486339 | 486339 | 2020-08-31 | DeKalb | Georgia | 13089 | 16555 | 300 |
483104 | 483104 | 2020-08-30 | DeKalb | Georgia | 13089 | 16498 | 298 |
479870 | 479870 | 2020-08-29 | DeKalb | Georgia | 13089 | 16443 | 297 |
476637 | 476637 | 2020-08-28 | DeKalb | Georgia | 13089 | 16368 | 296 |
473404 | 473404 | 2020-08-27 | DeKalb | Georgia | 13089 | 16278 | 293 |
470172 | 470172 | 2020-08-26 | DeKalb | Georgia | 13089 | 16193 | 287 |
466943 | 466943 | 2020-08-25 | DeKalb | Georgia | 13089 | 16086 | 287 |
463714 | 463714 | 2020-08-24 | DeKalb | Georgia | 13089 | 16004 | 280 |
460485 | 460485 | 2020-08-23 | DeKalb | Georgia | 13089 | 15959 | 278 |
457258 | 457258 | 2020-08-22 | DeKalb | Georgia | 13089 | 15860 | 278 |
454030 | 454030 | 2020-08-21 | DeKalb | Georgia | 13089 | 15731 | 272 |
450802 | 450802 | 2020-08-20 | DeKalb | Georgia | 13089 | 15605 | 268 |
447574 | 447574 | 2020-08-19 | DeKalb | Georgia | 13089 | 15422 | 267 |
444347 | 444347 | 2020-08-18 | DeKalb | Georgia | 13089 | 15312 | 266 |
441121 | 441121 | 2020-08-17 | DeKalb | Georgia | 13089 | 15101 | 264 |
437895 | 437895 | 2020-08-16 | DeKalb | Georgia | 13089 | 15030 | 264 |
434669 | 434669 | 2020-08-15 | DeKalb | Georgia | 13089 | 14926 | 262 |
431444 | 431444 | 2020-08-14 | DeKalb | Georgia | 13089 | 14746 | 254 |
428216 | 428216 | 2020-08-13 | DeKalb | Georgia | 13089 | 14563 | 251 |
424992 | 424992 | 2020-08-12 | DeKalb | Georgia | 13089 | 14485 | 247 |
421771 | 421771 | 2020-08-11 | DeKalb | Georgia | 13089 | 14292 | 242 |
418550 | 418550 | 2020-08-10 | DeKalb | Georgia | 13089 | 14047 | 238 |
415329 | 415329 | 2020-08-09 | DeKalb | Georgia | 13089 | 13923 | 237 |
412109 | 412109 | 2020-08-08 | DeKalb | Georgia | 13089 | 13752 | 237 |
408890 | 408890 | 2020-08-07 | DeKalb | Georgia | 13089 | 13509 | 237 |
405670 | 405670 | 2020-08-06 | DeKalb | Georgia | 13089 | 13237 | 234 |
402452 | 402452 | 2020-08-05 | DeKalb | Georgia | 13089 | 12998 | 231 |
399236 | 399236 | 2020-08-04 | DeKalb | Georgia | 13089 | 12760 | 229 |
396020 | 396020 | 2020-08-03 | DeKalb | Georgia | 13089 | 12604 | 225 |
392804 | 392804 | 2020-08-02 | DeKalb | Georgia | 13089 | 12476 | 225 |
389587 | 389587 | 2020-08-01 | DeKalb | Georgia | 13089 | 12348 | 225 |
386370 | 386370 | 2020-07-31 | DeKalb | Georgia | 13089 | 12127 | 222 |
383152 | 383152 | 2020-07-30 | DeKalb | Georgia | 13089 | 11916 | 213 |
379935 | 379935 | 2020-07-29 | DeKalb | Georgia | 13089 | 11679 | 213 |
376718 | 376718 | 2020-07-28 | DeKalb | Georgia | 13089 | 11494 | 208 |
373504 | 373504 | 2020-07-27 | DeKalb | Georgia | 13089 | 11281 | 207 |
370292 | 370292 | 2020-07-26 | DeKalb | Georgia | 13089 | 11159 | 207 |
367082 | 367082 | 2020-07-25 | DeKalb | Georgia | 13089 | 11025 | 206 |
363875 | 363875 | 2020-07-24 | DeKalb | Georgia | 13089 | 10767 | 204 |
360668 | 360668 | 2020-07-23 | DeKalb | Georgia | 13089 | 10480 | 199 |
357463 | 357463 | 2020-07-22 | DeKalb | Georgia | 13089 | 10203 | 196 |
354260 | 354260 | 2020-07-21 | DeKalb | Georgia | 13089 | 9950 | 190 |
351058 | 351058 | 2020-07-20 | DeKalb | Georgia | 13089 | 9800 | 188 |
347857 | 347857 | 2020-07-19 | DeKalb | Georgia | 13089 | 9732 | 188 |
344657 | 344657 | 2020-07-18 | DeKalb | Georgia | 13089 | 9597 | 188 |
341458 | 341458 | 2020-07-17 | DeKalb | Georgia | 13089 | 9308 | 187 |
338261 | 338261 | 2020-07-16 | DeKalb | Georgia | 13089 | 9165 | 186 |
335066 | 335066 | 2020-07-15 | DeKalb | Georgia | 13089 | 8980 | 186 |
331873 | 331873 | 2020-07-14 | DeKalb | Georgia | 13089 | 8784 | 183 |
328686 | 328686 | 2020-07-13 | DeKalb | Georgia | 13089 | 8618 | 182 |
325500 | 325500 | 2020-07-12 | DeKalb | Georgia | 13089 | 8253 | 180 |
322319 | 322319 | 2020-07-11 | DeKalb | Georgia | 13089 | 8144 | 181 |
319140 | 319140 | 2020-07-10 | DeKalb | Georgia | 13089 | 7973 | 177 |
315967 | 315967 | 2020-07-09 | DeKalb | Georgia | 13089 | 7472 | 175 |
312792 | 312792 | 2020-07-08 | DeKalb | Georgia | 13089 | 7362 | 175 |
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);