ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 13243 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
281288 | 281288 | 2020-06-28 | Randolph | Georgia | 13243 | 197 | 25 |
284434 | 284434 | 2020-06-29 | Randolph | Georgia | 13243 | 198 | 25 |
287580 | 287580 | 2020-06-30 | Randolph | Georgia | 13243 | 197 | 25 |
290731 | 290731 | 2020-07-01 | Randolph | Georgia | 13243 | 200 | 25 |
293885 | 293885 | 2020-07-02 | Randolph | Georgia | 13243 | 200 | 25 |
297041 | 297041 | 2020-07-03 | Randolph | Georgia | 13243 | 201 | 25 |
300203 | 300203 | 2020-07-04 | Randolph | Georgia | 13243 | 201 | 25 |
303367 | 303367 | 2020-07-05 | Randolph | Georgia | 13243 | 201 | 25 |
306531 | 306531 | 2020-07-06 | Randolph | Georgia | 13243 | 204 | 25 |
309699 | 309699 | 2020-07-07 | Randolph | Georgia | 13243 | 205 | 25 |
312869 | 312869 | 2020-07-08 | Randolph | Georgia | 13243 | 204 | 25 |
316044 | 316044 | 2020-07-09 | Randolph | Georgia | 13243 | 205 | 25 |
319217 | 319217 | 2020-07-10 | Randolph | Georgia | 13243 | 211 | 25 |
322396 | 322396 | 2020-07-11 | Randolph | Georgia | 13243 | 212 | 25 |
325577 | 325577 | 2020-07-12 | Randolph | Georgia | 13243 | 212 | 25 |
328763 | 328763 | 2020-07-13 | Randolph | Georgia | 13243 | 212 | 25 |
331950 | 331950 | 2020-07-14 | Randolph | Georgia | 13243 | 212 | 25 |
335143 | 335143 | 2020-07-15 | Randolph | Georgia | 13243 | 214 | 25 |
338338 | 338338 | 2020-07-16 | Randolph | Georgia | 13243 | 220 | 25 |
341535 | 341535 | 2020-07-17 | Randolph | Georgia | 13243 | 222 | 25 |
344734 | 344734 | 2020-07-18 | Randolph | Georgia | 13243 | 223 | 25 |
347934 | 347934 | 2020-07-19 | Randolph | Georgia | 13243 | 223 | 25 |
351135 | 351135 | 2020-07-20 | Randolph | Georgia | 13243 | 223 | 25 |
354337 | 354337 | 2020-07-21 | Randolph | Georgia | 13243 | 228 | 26 |
357540 | 357540 | 2020-07-22 | Randolph | Georgia | 13243 | 229 | 26 |
360745 | 360745 | 2020-07-23 | Randolph | Georgia | 13243 | 230 | 26 |
363952 | 363952 | 2020-07-24 | Randolph | Georgia | 13243 | 231 | 26 |
367159 | 367159 | 2020-07-25 | Randolph | Georgia | 13243 | 235 | 26 |
370369 | 370369 | 2020-07-26 | Randolph | Georgia | 13243 | 237 | 26 |
373581 | 373581 | 2020-07-27 | Randolph | Georgia | 13243 | 235 | 26 |
376795 | 376795 | 2020-07-28 | Randolph | Georgia | 13243 | 237 | 26 |
380012 | 380012 | 2020-07-29 | Randolph | Georgia | 13243 | 241 | 26 |
383229 | 383229 | 2020-07-30 | Randolph | Georgia | 13243 | 246 | 26 |
386447 | 386447 | 2020-07-31 | Randolph | Georgia | 13243 | 257 | 26 |
389664 | 389664 | 2020-08-01 | Randolph | Georgia | 13243 | 259 | 26 |
392881 | 392881 | 2020-08-02 | Randolph | Georgia | 13243 | 259 | 26 |
396097 | 396097 | 2020-08-03 | Randolph | Georgia | 13243 | 261 | 26 |
399313 | 399313 | 2020-08-04 | Randolph | Georgia | 13243 | 261 | 26 |
402529 | 402529 | 2020-08-05 | Randolph | Georgia | 13243 | 266 | 26 |
405747 | 405747 | 2020-08-06 | Randolph | Georgia | 13243 | 266 | 26 |
408967 | 408967 | 2020-08-07 | Randolph | Georgia | 13243 | 268 | 26 |
412186 | 412186 | 2020-08-08 | Randolph | Georgia | 13243 | 270 | 26 |
415406 | 415406 | 2020-08-09 | Randolph | Georgia | 13243 | 271 | 26 |
418627 | 418627 | 2020-08-10 | Randolph | Georgia | 13243 | 272 | 26 |
421848 | 421848 | 2020-08-11 | Randolph | Georgia | 13243 | 273 | 26 |
425069 | 425069 | 2020-08-12 | Randolph | Georgia | 13243 | 274 | 26 |
428293 | 428293 | 2020-08-13 | Randolph | Georgia | 13243 | 276 | 26 |
431521 | 431521 | 2020-08-14 | Randolph | Georgia | 13243 | 278 | 26 |
434746 | 434746 | 2020-08-15 | Randolph | Georgia | 13243 | 280 | 26 |
437972 | 437972 | 2020-08-16 | Randolph | Georgia | 13243 | 287 | 26 |
441198 | 441198 | 2020-08-17 | Randolph | Georgia | 13243 | 287 | 26 |
444424 | 444424 | 2020-08-18 | Randolph | Georgia | 13243 | 290 | 26 |
447651 | 447651 | 2020-08-19 | Randolph | Georgia | 13243 | 292 | 26 |
450879 | 450879 | 2020-08-20 | Randolph | Georgia | 13243 | 296 | 26 |
454107 | 454107 | 2020-08-21 | Randolph | Georgia | 13243 | 299 | 27 |
457335 | 457335 | 2020-08-22 | Randolph | Georgia | 13243 | 302 | 27 |
460562 | 460562 | 2020-08-23 | Randolph | Georgia | 13243 | 303 | 27 |
463791 | 463791 | 2020-08-24 | Randolph | Georgia | 13243 | 305 | 27 |
467020 | 467020 | 2020-08-25 | Randolph | Georgia | 13243 | 307 | 27 |
470249 | 470249 | 2020-08-26 | Randolph | Georgia | 13243 | 308 | 27 |
473481 | 473481 | 2020-08-27 | Randolph | Georgia | 13243 | 308 | 27 |
476714 | 476714 | 2020-08-28 | Randolph | Georgia | 13243 | 310 | 27 |
479947 | 479947 | 2020-08-29 | Randolph | Georgia | 13243 | 310 | 27 |
483181 | 483181 | 2020-08-30 | Randolph | Georgia | 13243 | 310 | 27 |
486416 | 486416 | 2020-08-31 | Randolph | Georgia | 13243 | 312 | 27 |
489649 | 489649 | 2020-09-01 | Randolph | Georgia | 13243 | 314 | 27 |
492882 | 492882 | 2020-09-02 | Randolph | Georgia | 13243 | 317 | 27 |
496116 | 496116 | 2020-09-03 | Randolph | Georgia | 13243 | 318 | 27 |
499349 | 499349 | 2020-09-04 | Randolph | Georgia | 13243 | 318 | 27 |
502583 | 502583 | 2020-09-05 | Randolph | Georgia | 13243 | 320 | 27 |
505817 | 505817 | 2020-09-06 | Randolph | Georgia | 13243 | 320 | 27 |
509049 | 509049 | 2020-09-07 | Randolph | Georgia | 13243 | 320 | 27 |
512282 | 512282 | 2020-09-08 | Randolph | Georgia | 13243 | 322 | 27 |
515515 | 515515 | 2020-09-09 | Randolph | Georgia | 13243 | 322 | 27 |
518750 | 518750 | 2020-09-10 | Randolph | Georgia | 13243 | 325 | 27 |
521987 | 521987 | 2020-09-11 | Randolph | Georgia | 13243 | 325 | 27 |
525223 | 525223 | 2020-09-12 | Randolph | Georgia | 13243 | 327 | 27 |
528459 | 528459 | 2020-09-13 | Randolph | Georgia | 13243 | 327 | 27 |
531696 | 531696 | 2020-09-14 | Randolph | Georgia | 13243 | 327 | 27 |
534931 | 534931 | 2020-09-15 | Randolph | Georgia | 13243 | 327 | 28 |
538167 | 538167 | 2020-09-16 | Randolph | Georgia | 13243 | 329 | 28 |
541404 | 541404 | 2020-09-17 | Randolph | Georgia | 13243 | 331 | 28 |
544640 | 544640 | 2020-09-18 | Randolph | Georgia | 13243 | 331 | 28 |
547878 | 547878 | 2020-09-19 | Randolph | Georgia | 13243 | 331 | 28 |
551117 | 551117 | 2020-09-20 | Randolph | Georgia | 13243 | 331 | 28 |
554356 | 554356 | 2020-09-21 | Randolph | Georgia | 13243 | 331 | 28 |
557593 | 557593 | 2020-09-22 | Randolph | Georgia | 13243 | 331 | 28 |
560829 | 560829 | 2020-09-23 | Randolph | Georgia | 13243 | 331 | 28 |
564069 | 564069 | 2020-09-24 | Randolph | Georgia | 13243 | 331 | 28 |
567309 | 567309 | 2020-09-25 | Randolph | Georgia | 13243 | 331 | 29 |
570551 | 570551 | 2020-09-26 | Randolph | Georgia | 13243 | 331 | 29 |
573793 | 573793 | 2020-09-27 | Randolph | Georgia | 13243 | 331 | 29 |
577036 | 577036 | 2020-09-28 | Randolph | Georgia | 13243 | 331 | 29 |
580277 | 580277 | 2020-09-29 | Randolph | Georgia | 13243 | 331 | 29 |
583516 | 583516 | 2020-09-30 | Randolph | Georgia | 13243 | 331 | 29 |
586756 | 586756 | 2020-10-01 | Randolph | Georgia | 13243 | 331 | 29 |
589997 | 589997 | 2020-10-02 | Randolph | Georgia | 13243 | 331 | 29 |
593237 | 593237 | 2020-10-03 | Randolph | Georgia | 13243 | 331 | 29 |
596479 | 596479 | 2020-10-04 | Randolph | Georgia | 13243 | 331 | 29 |
599722 | 599722 | 2020-10-05 | Randolph | Georgia | 13243 | 346 | 29 |
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);