ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where "date" is on date 2020-12-02 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 76
- 5001 1
- 5003 1
- 5005 1
- 5007 1
- 5009 1
- 5011 1
- 5013 1
- 5015 1
- 5017 1
- 5019 1
- 5021 1
- 5023 1
- 5025 1
- 5027 1
- 5029 1
- 5031 1
- 5033 1
- 5035 1
- 5037 1
- 5039 1
- 5041 1
- 5043 1
- 5045 1
- 5047 1
- 5049 1
- 5051 1
- 5053 1
- 5055 1
- 5057 1
- 5059 1
- 5061 1
- 5063 1
- 5065 1
- 5067 1
- 5069 1
- 5071 1
- 5073 1
- 5075 1
- 5077 1
- 5079 1
- 5081 1
- 5083 1
- 5085 1
- 5087 1
- 5089 1
- 5091 1
- 5093 1
- 5095 1
- 5097 1
- 5099 1
- 5101 1
- 5103 1
- 5105 1
- 5107 1
- 5109 1
- 5111 1
- 5113 1
- 5115 1
- 5117 1
- 5119 1
- 5121 1
- 5123 1
- 5125 1
- 5127 1
- 5129 1
- 5131 1
- 5133 1
- 5135 1
- 5137 1
- 5139 1
- 5141 1
- 5143 1
- 5145 1
- 5147 1
- 5149 1
- - 1
county 76
- Arkansas 1
- Ashley 1
- Baxter 1
- Benton 1
- Boone 1
- Bradley 1
- Calhoun 1
- Carroll 1
- Chicot 1
- Clark 1
- Clay 1
- Cleburne 1
- Cleveland 1
- Columbia 1
- Conway 1
- Craighead 1
- Crawford 1
- Crittenden 1
- Cross 1
- Dallas 1
- Desha 1
- Drew 1
- Faulkner 1
- Franklin 1
- Fulton 1
- Garland 1
- Grant 1
- Greene 1
- Hempstead 1
- Hot Spring 1
- Howard 1
- Independence 1
- Izard 1
- Jackson 1
- Jefferson 1
- Johnson 1
- Lafayette 1
- Lawrence 1
- Lee 1
- Lincoln 1
- Little River 1
- Logan 1
- Lonoke 1
- Madison 1
- Marion 1
- Miller 1
- Mississippi 1
- Monroe 1
- Montgomery 1
- Nevada 1
- Newton 1
- Ouachita 1
- Perry 1
- Phillips 1
- Pike 1
- Poinsett 1
- Polk 1
- Pope 1
- Prairie 1
- Pulaski 1
- Randolph 1
- Saline 1
- Scott 1
- Searcy 1
- Sebastian 1
- Sevier 1
- Sharp 1
- St. Francis 1
- Stone 1
- Union 1
- Unknown 1
- Van Buren 1
- Washington 1
- White 1
- Woodruff 1
- Yell 1
state 1
- Arkansas · 76 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
787489 | 787489 | 2020-12-02 | Arkansas | Arkansas | 5001 | 987 | 22 |
787490 | 787490 | 2020-12-02 | Ashley | Arkansas | 5003 | 886 | 15 |
787491 | 787491 | 2020-12-02 | Baxter | Arkansas | 5005 | 1446 | 29 |
787492 | 787492 | 2020-12-02 | Benton | Arkansas | 5007 | 12496 | 163 |
787493 | 787493 | 2020-12-02 | Boone | Arkansas | 5009 | 1862 | 44 |
787494 | 787494 | 2020-12-02 | Bradley | Arkansas | 5011 | 527 | 7 |
787495 | 787495 | 2020-12-02 | Calhoun | Arkansas | 5013 | 155 | 1 |
787496 | 787496 | 2020-12-02 | Carroll | Arkansas | 5015 | 1503 | 23 |
787497 | 787497 | 2020-12-02 | Chicot | Arkansas | 5017 | 1205 | 28 |
787498 | 787498 | 2020-12-02 | Clark | Arkansas | 5019 | 851 | 11 |
787499 | 787499 | 2020-12-02 | Clay | Arkansas | 5021 | 943 | 21 |
787500 | 787500 | 2020-12-02 | Cleburne | Arkansas | 5023 | 770 | 24 |
787501 | 787501 | 2020-12-02 | Cleveland | Arkansas | 5025 | 388 | 15 |
787502 | 787502 | 2020-12-02 | Columbia | Arkansas | 5027 | 1141 | 24 |
787503 | 787503 | 2020-12-02 | Conway | Arkansas | 5029 | 711 | 8 |
787504 | 787504 | 2020-12-02 | Craighead | Arkansas | 5031 | 7363 | 82 |
787505 | 787505 | 2020-12-02 | Crawford | Arkansas | 5033 | 3163 | 38 |
787506 | 787506 | 2020-12-02 | Crittenden | Arkansas | 5035 | 3352 | 57 |
787507 | 787507 | 2020-12-02 | Cross | Arkansas | 5037 | 887 | 26 |
787508 | 787508 | 2020-12-02 | Dallas | Arkansas | 5039 | 317 | 6 |
787509 | 787509 | 2020-12-02 | Desha | Arkansas | 5041 | 585 | 8 |
787510 | 787510 | 2020-12-02 | Drew | Arkansas | 5043 | 798 | 8 |
787511 | 787511 | 2020-12-02 | Faulkner | Arkansas | 5045 | 4998 | 56 |
787512 | 787512 | 2020-12-02 | Franklin | Arkansas | 5047 | 812 | 13 |
787513 | 787513 | 2020-12-02 | Fulton | Arkansas | 5049 | 563 | 12 |
787514 | 787514 | 2020-12-02 | Garland | Arkansas | 5051 | 3949 | 105 |
787515 | 787515 | 2020-12-02 | Grant | Arkansas | 5053 | 641 | 6 |
787516 | 787516 | 2020-12-02 | Greene | Arkansas | 5055 | 3096 | 28 |
787517 | 787517 | 2020-12-02 | Hempstead | Arkansas | 5057 | 890 | 8 |
787518 | 787518 | 2020-12-02 | Hot Spring | Arkansas | 5059 | 2971 | 42 |
787519 | 787519 | 2020-12-02 | Howard | Arkansas | 5061 | 841 | 15 |
787520 | 787520 | 2020-12-02 | Independence | Arkansas | 5063 | 2147 | 71 |
787521 | 787521 | 2020-12-02 | Izard | Arkansas | 5065 | 1013 | 6 |
787522 | 787522 | 2020-12-02 | Jackson | Arkansas | 5067 | 1868 | 9 |
787523 | 787523 | 2020-12-02 | Jefferson | Arkansas | 5069 | 5263 | 111 |
787524 | 787524 | 2020-12-02 | Johnson | Arkansas | 5071 | 1285 | 13 |
787525 | 787525 | 2020-12-02 | Lafayette | Arkansas | 5073 | 271 | 3 |
787526 | 787526 | 2020-12-02 | Lawrence | Arkansas | 5075 | 1207 | 30 |
787527 | 787527 | 2020-12-02 | Lee | Arkansas | 5077 | 1209 | 18 |
787528 | 787528 | 2020-12-02 | Lincoln | Arkansas | 5079 | 2519 | 18 |
787529 | 787529 | 2020-12-02 | Little River | Arkansas | 5081 | 656 | 37 |
787530 | 787530 | 2020-12-02 | Logan | Arkansas | 5083 | 983 | 6 |
787531 | 787531 | 2020-12-02 | Lonoke | Arkansas | 5085 | 2800 | 56 |
787532 | 787532 | 2020-12-02 | Madison | Arkansas | 5087 | 665 | 8 |
787533 | 787533 | 2020-12-02 | Marion | Arkansas | 5089 | 464 | 6 |
787534 | 787534 | 2020-12-02 | Miller | Arkansas | 5091 | 2190 | 22 |
787535 | 787535 | 2020-12-02 | Mississippi | Arkansas | 5093 | 3316 | 82 |
787536 | 787536 | 2020-12-02 | Monroe | Arkansas | 5095 | 315 | 4 |
787537 | 787537 | 2020-12-02 | Montgomery | Arkansas | 5097 | 321 | 10 |
787538 | 787538 | 2020-12-02 | Nevada | Arkansas | 5099 | 471 | 14 |
787539 | 787539 | 2020-12-02 | Newton | Arkansas | 5101 | 454 | 22 |
787540 | 787540 | 2020-12-02 | Ouachita | Arkansas | 5103 | 815 | 14 |
787541 | 787541 | 2020-12-02 | Perry | Arkansas | 5105 | 265 | 4 |
787542 | 787542 | 2020-12-02 | Phillips | Arkansas | 5107 | 968 | 17 |
787543 | 787543 | 2020-12-02 | Pike | Arkansas | 5109 | 397 | 3 |
787544 | 787544 | 2020-12-02 | Poinsett | Arkansas | 5111 | 1706 | 43 |
787545 | 787545 | 2020-12-02 | Polk | Arkansas | 5113 | 849 | 11 |
787546 | 787546 | 2020-12-02 | Pope | Arkansas | 5115 | 3779 | 43 |
787547 | 787547 | 2020-12-02 | Prairie | Arkansas | 5117 | 366 | 8 |
787548 | 787548 | 2020-12-02 | Pulaski | Arkansas | 5119 | 17354 | 277 |
787549 | 787549 | 2020-12-02 | Randolph | Arkansas | 5121 | 1032 | 31 |
787550 | 787550 | 2020-12-02 | Saline | Arkansas | 5125 | 5117 | 57 |
787551 | 787551 | 2020-12-02 | Scott | Arkansas | 5127 | 396 | 3 |
787552 | 787552 | 2020-12-02 | Searcy | Arkansas | 5129 | 309 | 1 |
787553 | 787553 | 2020-12-02 | Sebastian | Arkansas | 5131 | 7189 | 119 |
787554 | 787554 | 2020-12-02 | Sevier | Arkansas | 5133 | 1751 | 18 |
787555 | 787555 | 2020-12-02 | Sharp | Arkansas | 5135 | 739 | 15 |
787556 | 787556 | 2020-12-02 | St. Francis | Arkansas | 5123 | 2082 | 15 |
787557 | 787557 | 2020-12-02 | Stone | Arkansas | 5137 | 495 | 25 |
787558 | 787558 | 2020-12-02 | Union | Arkansas | 5139 | 1606 | 59 |
787559 | 787559 | 2020-12-02 | Unknown | Arkansas | 2499 | 0 | |
787560 | 787560 | 2020-12-02 | Van Buren | Arkansas | 5141 | 407 | 4 |
787561 | 787561 | 2020-12-02 | Washington | Arkansas | 5143 | 15866 | 178 |
787562 | 787562 | 2020-12-02 | White | Arkansas | 5145 | 3133 | 51 |
787563 | 787563 | 2020-12-02 | Woodruff | Arkansas | 5147 | 206 | 1 |
787564 | 787564 | 2020-12-02 | Yell | Arkansas | 5149 | 1681 | 34 |
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);