ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Ellis" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 564 ✖
- 34066 5
- 2 4
- 510 4
- 3486 4
- 3888 4
- 4192 4
- 4729 4
- 5229 4
- 13261 4
- 16403 4
- 20066 4
- 23031 4
- 26600 4
- 27840 4
- 34917 4
- 35546 4
- 48803 4
- 5 3
- 247 3
- 272 3
- 317 3
- 364 3
- 448 3
- 684 3
- 711 3
- 1046 3
- 1510 3
- 1972 3
- 2268 3
- 2472 3
- 2855 3
- 3255 3
- 3758 3
- 3998 3
- 4398 3
- 4482 3
- 4574 3
- 4875 3
- 5043 3
- 5714 3
- 6107 3
- 6828 3
- 6898 3
- 7905 3
- 9726 3
- 11023 3
- 11961 3
- 14984 3
- 17597 3
- 18561 3
- 19505 3
- 20331 3
- 20406 3
- 20714 3
- 21380 3
- 21541 3
- 21650 3
- 22043 3
- 22164 3
- 22252 3
- 22368 3
- 22468 3
- 22677 3
- 22765 3
- 22859 3
- 22963 3
- 23094 3
- 23131 3
- 23151 3
- 23164 3
- 23217 3
- 23256 3
- 23270 3
- 23367 3
- 23767 3
- 24381 3
- 24992 3
- 25854 3
- 29160 3
- 30145 3
- 30912 3
- 31652 3
- 32192 3
- 32780 3
- 33241 3
- 33623 3
- 33878 3
- 33993 3
- 34028 3
- 6 2
- 13 2
- 16 2
- 32 2
- 38 2
- 44 2
- 71 2
- 73 2
- 83 2
- 94 2
- 101 2
- 127 2
- 133 2
- 148 2
- 166 2
- 202 2
- 266 2
- 3951 2
- 4328 2
- 4796 2
- 5530 2
- 12230 2
- 23167 2
- 23183 2
- 30671 2
- 33917 2
- 33967 2
- 48647 2
- 3 1
- 15 1
- 20 1
- 26 1
- 27 1
- 63 1
- 99 1
- 110 1
- 111 1
- 121 1
- 143 1
- 169 1
- 176 1
- 184 1
- 188 1
- 193 1
- 211 1
- 216 1
- 221 1
- 236 1
- 241 1
- 258 1
- 264 1
- 289 1
- 290 1
- 305 1
- 309 1
- 325 1
- 332 1
- 338 1
- 361 1
- 399 1
- 418 1
- 429 1
- 437 1
- 458 1
- 470 1
- 490 1
- 539 1
- 820 1
- 862 1
- 901 1
- 978 1
- 1182 1
- 1351 1
- 1424 1
- 1485 1
- 1729 1
- 1811 1
- 1837 1
- 1957 1
- 2090 1
- 2129 1
- 2183 1
- 2216 1
- 2332 1
- 2387 1
- 2407 1
- 2452 1
- 2545 1
- 2691 1
- 2739 1
- 2808 1
- 3120 1
- 3218 1
- 3238 1
- 3244 1
- 3427 1
- 3433 1
- 3445 1
- 3562 1
- 3670 1
- 3700 1
- 3740 1
- 3801 1
- 3828 1
- 3843 1
- 3856 1
- 3988 1
- 4119 1
- 4136 1
- 4181 1
- 4291 1
- 4298 1
- 4450 1
- 4451 1
- 4459 1
- 4472 1
- 4484 1
- 4523 1
- 4536 1
- 4570 1
- 4605 1
- 4638 1
- 4684 1
- 4700 1
- 4816 1
- 4945 1
- 4968 1
- 4999 1
- 5029 1
- 5130 1
- 5146 1
- 5190 1
- 5509 1
- 5641 1
- 5770 1
- 5831 1
- 6008 1
- 6070 1
- 6614 1
- 6701 1
- 7460 1
- 7755 1
- 7817 1
- 8270 1
- 8349 1
- 8436 1
- 9635 1
- 10189 1
- 10403 1
- 10609 1
- 10876 1
- 11490 1
- 11704 1
- 12665 1
- 12893 1
- 13216 1
- 14136 1
- 14355 1
- 14578 1
- 14836 1
- 15676 1
- 15799 1
- 16083 1
- 16269 1
- 17207 1
- 17297 1
- 17459 1
- 18046 1
- 18139 1
- 18313 1
- 18450 1
- 18984 1
- 19104 1
- 19234 1
- 19356 1
- 19695 1
- 19813 1
- 19900 1
- 19981 1
- 20473 1
- 20516 1
- 20589 1
- 20659 1
- 20833 1
- 20936 1
- 21317 1
- 21338 1
- 21407 1
- 21437 1
- 21471 1
- 21523 1
- 21587 1
- 21602 1
- 21610 1
- 21626 1
- 21691 1
- 21721 1
- 21729 1
- 22033 1
- 22094 1
- 22139 1
- 22172 1
- 22183 1
- 22201 1
- 22203 1
- 22223 1
- 22237 1
- 22314 1
- 22334 1
- 22349 1
- 22359 1
- 22412 1
- 22429 1
- 22454 1
- 22462 1
- 22511 1
- 22611 1
- 22635 1
- 22657 1
- 22720 1
- 22727 1
- 22745 1
- 22753 1
- 22797 1
- 22805 1
- 22814 1
- 22841 1
- 22914 1
- 22933 1
- 22942 1
- 22947 1
- 22993 1
- 23003 1
- 23013 1
- 23025 1
- 23067 1
- 23084 1
- 23088 1
- 23112 1
- 23119 1
- 23122 1
- 23133 1
- 23149 1
- 23152 1
- 23153 1
- 23156 1
- 23157 1
- 23159 1
- 23181 1
- 23216 1
- 23218 1
- 23234 1
- 23235 1
- 23237 1
- 23267 1
- 23273 1
- 23279 1
- 23283 1
- 23297 1
- 23304 1
- 23318 1
- 23343 1
- 23487 1
- 23511 1
- 23613 1
- 23680 1
- 23955 1
- 24014 1
- 24168 1
- 24294 1
- 24593 1
- 24684 1
- 24820 1
- 24892 1
- 25366 1
- 25580 1
- 25713 1
- 25790 1
- 26070 1
- 26295 1
- 26431 1
- 26996 1
- 27128 1
- 27410 1
- 27723 1
- 28633 1
- 28895 1
- 29041 1
- 29555 1
- 29718 1
- 29905 1
- 30044 1
- 30453 1
- 30486 1
- 31230 1
- 31354 1
- 31466 1
- 31562 1
- 31838 1
- 31951 1
- 32070 1
- 32136 1
- 32425 1
- 32538 1
- 32620 1
- 32710 1
- 32945 1
- 33006 1
- 33106 1
- 33152 1
- 33350 1
- 33390 1
- 33568 1
- 33594 1
- 33812 1
- 33828 1
- 33848 1
- 33857 1
- 34008 1
- 34016 1
- 34018 1
- 34023 1
- 34050 1
- 34071 1
- 34108 1
- 34118 1
- 34133 1
- 34147 1
- 34159 1
- 34163 1
- 34173 1
- 34199 1
- 34221 1
- 34233 1
- 34380 1
- 34413 1
- 34424 1
- 34452 1
- 34484 1
- 34523 1
- 34563 1
- 34606 1
- 34658 1
- 34688 1
- 34746 1
- 34822 1
- 34846 1
- 35231 1
- 35354 1
- 35408 1
- 36730 1
- 37129 1
- 37472 1
- 37817 1
- 38092 1
- 38472 1
- 38727 1
- 39098 1
- 39509 1
- 40047 1
- 40493 1
- 40590 1
- 40869 1
- 41303 1
- 41783 1
- 42209 1
- 42685 1
- 42928 1
- 43302 1
- 43975 1
- 44457 1
- 44704 1
- 45002 1
- 45181 1
- 45431 1
- 45638 1
- 45907 1
- 46050 1
- 46209 1
- 46424 1
- 46599 1
- 46759 1
- 46891 1
- 47016 1
- 47099 1
- 47185 1
- 47251 1
- 47324 1
- 47406 1
- 47500 1
- 47573 1
- 47624 1
- 47650 1
- 47698 1
- 47731 1
- 47764 1
- 47809 1
- 47862 1
- 47871 1
- 47894 1
- 47911 1
- 47941 1
- 47971 1
- 48187 1
- 48220 1
- 48227 1
- 48231 1
- 48265 1
- 48304 1
- 48343 1
- 48369 1
- 48391 1
- 48393 1
- 48398 1
- 48417 1
- 48442 1
- 48466 1
- 48481 1
- 48505 1
- 48535 1
- 48537 1
- 48544 1
- 48559 1
- 48565 1
- 48571 1
- 48580 1
- 48591 1
- 48603 1
- 48604 1
- 48617 1
- 48631 1
- 48636 1
- 48649 1
- 48658 1
- 48668 1
- 48685 1
- 48697 1
- 48714 1
- 48717 1
- 48720 1
- 48727 1
- 48738 1
- 48755 1
- 48765 1
- 48772 1
- 48774 1
- 48777 1
- 48782 1
- 48790 1
- 48837 1
- 48851 1
- 48873 1
- 48886 1
- 48896 1
- 48910 1
- 48920 1
- 48926 1
- 48938 1
- 48951 1
- 48967 1
- 48983 1
- 49007 1
- 49012 1
- 49016 1
- 49027 1
- 49035 1
- 49050 1
- 49064 1
- 49091 1
- 49097 1
- 49106 1
- 49122 1
- 49143 1
- 49157 1
- 49172 1
state 1
- Texas · 788 ✖
fips 1
- 48139 788
county 1
- Ellis · 788 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502277 | 2502277 | 2022-05-13 | Ellis | Texas | 48139 | 49172 | 582 |
2499019 | 2499019 | 2022-05-12 | Ellis | Texas | 48139 | 49157 | 582 |
2495761 | 2495761 | 2022-05-11 | Ellis | Texas | 48139 | 49143 | 582 |
2492503 | 2492503 | 2022-05-10 | Ellis | Texas | 48139 | 49122 | 582 |
2489245 | 2489245 | 2022-05-09 | Ellis | Texas | 48139 | 49106 | 582 |
2485988 | 2485988 | 2022-05-08 | Ellis | Texas | 48139 | 49097 | 582 |
2482730 | 2482730 | 2022-05-07 | Ellis | Texas | 48139 | 49091 | 582 |
2479472 | 2479472 | 2022-05-06 | Ellis | Texas | 48139 | 49064 | 582 |
2476214 | 2476214 | 2022-05-05 | Ellis | Texas | 48139 | 49050 | 582 |
2472957 | 2472957 | 2022-05-04 | Ellis | Texas | 48139 | 49035 | 582 |
2469701 | 2469701 | 2022-05-03 | Ellis | Texas | 48139 | 49027 | 582 |
2466445 | 2466445 | 2022-05-02 | Ellis | Texas | 48139 | 49016 | 582 |
2463190 | 2463190 | 2022-05-01 | Ellis | Texas | 48139 | 49012 | 582 |
2459934 | 2459934 | 2022-04-30 | Ellis | Texas | 48139 | 49007 | 582 |
2456678 | 2456678 | 2022-04-29 | Ellis | Texas | 48139 | 48983 | 582 |
2453422 | 2453422 | 2022-04-28 | Ellis | Texas | 48139 | 48967 | 582 |
2450166 | 2450166 | 2022-04-27 | Ellis | Texas | 48139 | 48951 | 582 |
2446909 | 2446909 | 2022-04-26 | Ellis | Texas | 48139 | 48938 | 582 |
2443654 | 2443654 | 2022-04-25 | Ellis | Texas | 48139 | 48926 | 582 |
2440398 | 2440398 | 2022-04-24 | Ellis | Texas | 48139 | 48920 | 582 |
2437142 | 2437142 | 2022-04-23 | Ellis | Texas | 48139 | 48910 | 582 |
2433886 | 2433886 | 2022-04-22 | Ellis | Texas | 48139 | 48896 | 582 |
2430630 | 2430630 | 2022-04-21 | Ellis | Texas | 48139 | 48886 | 582 |
2427374 | 2427374 | 2022-04-20 | Ellis | Texas | 48139 | 48873 | 582 |
2424118 | 2424118 | 2022-04-19 | Ellis | Texas | 48139 | 48851 | 582 |
2420862 | 2420862 | 2022-04-18 | Ellis | Texas | 48139 | 48837 | 582 |
2417606 | 2417606 | 2022-04-17 | Ellis | Texas | 48139 | 48803 | 581 |
2414350 | 2414350 | 2022-04-16 | Ellis | Texas | 48139 | 48803 | 581 |
2411094 | 2411094 | 2022-04-15 | Ellis | Texas | 48139 | 48803 | 581 |
2407838 | 2407838 | 2022-04-14 | Ellis | Texas | 48139 | 48803 | 581 |
2404582 | 2404582 | 2022-04-13 | Ellis | Texas | 48139 | 48790 | 581 |
2401327 | 2401327 | 2022-04-12 | Ellis | Texas | 48139 | 48782 | 580 |
2398072 | 2398072 | 2022-04-11 | Ellis | Texas | 48139 | 48777 | 580 |
2394817 | 2394817 | 2022-04-10 | Ellis | Texas | 48139 | 48774 | 580 |
2391561 | 2391561 | 2022-04-09 | Ellis | Texas | 48139 | 48772 | 580 |
2388305 | 2388305 | 2022-04-08 | Ellis | Texas | 48139 | 48765 | 578 |
2385050 | 2385050 | 2022-04-07 | Ellis | Texas | 48139 | 48755 | 578 |
2381795 | 2381795 | 2022-04-06 | Ellis | Texas | 48139 | 48738 | 578 |
2378540 | 2378540 | 2022-04-05 | Ellis | Texas | 48139 | 48727 | 577 |
2375286 | 2375286 | 2022-04-04 | Ellis | Texas | 48139 | 48720 | 577 |
2372034 | 2372034 | 2022-04-03 | Ellis | Texas | 48139 | 48717 | 577 |
2368781 | 2368781 | 2022-04-02 | Ellis | Texas | 48139 | 48714 | 577 |
2365528 | 2365528 | 2022-04-01 | Ellis | Texas | 48139 | 48697 | 577 |
2362275 | 2362275 | 2022-03-31 | Ellis | Texas | 48139 | 48685 | 577 |
2359021 | 2359021 | 2022-03-30 | Ellis | Texas | 48139 | 48668 | 577 |
2355767 | 2355767 | 2022-03-29 | Ellis | Texas | 48139 | 48658 | 576 |
2352514 | 2352514 | 2022-03-28 | Ellis | Texas | 48139 | 48649 | 576 |
2349262 | 2349262 | 2022-03-27 | Ellis | Texas | 48139 | 48647 | 576 |
2346009 | 2346009 | 2022-03-26 | Ellis | Texas | 48139 | 48647 | 576 |
2342756 | 2342756 | 2022-03-25 | Ellis | Texas | 48139 | 48636 | 575 |
2339503 | 2339503 | 2022-03-24 | Ellis | Texas | 48139 | 48631 | 575 |
2336249 | 2336249 | 2022-03-23 | Ellis | Texas | 48139 | 48617 | 575 |
2332995 | 2332995 | 2022-03-22 | Ellis | Texas | 48139 | 48604 | 574 |
2329742 | 2329742 | 2022-03-21 | Ellis | Texas | 48139 | 48603 | 574 |
2326490 | 2326490 | 2022-03-20 | Ellis | Texas | 48139 | 48591 | 574 |
2323237 | 2323237 | 2022-03-19 | Ellis | Texas | 48139 | 48580 | 574 |
2319983 | 2319983 | 2022-03-18 | Ellis | Texas | 48139 | 48571 | 573 |
2316729 | 2316729 | 2022-03-17 | Ellis | Texas | 48139 | 48565 | 573 |
2313476 | 2313476 | 2022-03-16 | Ellis | Texas | 48139 | 48559 | 573 |
2310223 | 2310223 | 2022-03-15 | Ellis | Texas | 48139 | 48544 | 573 |
2306970 | 2306970 | 2022-03-14 | Ellis | Texas | 48139 | 48537 | 573 |
2303719 | 2303719 | 2022-03-13 | Ellis | Texas | 48139 | 48535 | 573 |
2300467 | 2300467 | 2022-03-12 | Ellis | Texas | 48139 | 48505 | 573 |
2297215 | 2297215 | 2022-03-11 | Ellis | Texas | 48139 | 48481 | 573 |
2293963 | 2293963 | 2022-03-10 | Ellis | Texas | 48139 | 48466 | 573 |
2290711 | 2290711 | 2022-03-09 | Ellis | Texas | 48139 | 48442 | 573 |
2287459 | 2287459 | 2022-03-08 | Ellis | Texas | 48139 | 48417 | 573 |
2284207 | 2284207 | 2022-03-07 | Ellis | Texas | 48139 | 48398 | 572 |
2280955 | 2280955 | 2022-03-06 | Ellis | Texas | 48139 | 48393 | 572 |
2277702 | 2277702 | 2022-03-05 | Ellis | Texas | 48139 | 48391 | 571 |
2274449 | 2274449 | 2022-03-04 | Ellis | Texas | 48139 | 48369 | 571 |
2271196 | 2271196 | 2022-03-03 | Ellis | Texas | 48139 | 48343 | 569 |
2267944 | 2267944 | 2022-03-02 | Ellis | Texas | 48139 | 48304 | 568 |
2264691 | 2264691 | 2022-03-01 | Ellis | Texas | 48139 | 48265 | 567 |
2261441 | 2261441 | 2022-02-28 | Ellis | Texas | 48139 | 48231 | 566 |
2258190 | 2258190 | 2022-02-27 | Ellis | Texas | 48139 | 48227 | 566 |
2254939 | 2254939 | 2022-02-26 | Ellis | Texas | 48139 | 48220 | 566 |
2251688 | 2251688 | 2022-02-25 | Ellis | Texas | 48139 | 48187 | 563 |
2248437 | 2248437 | 2022-02-24 | Ellis | Texas | 48139 | 47971 | 563 |
2245186 | 2245186 | 2022-02-23 | Ellis | Texas | 48139 | 47941 | 562 |
2241935 | 2241935 | 2022-02-22 | Ellis | Texas | 48139 | 47911 | 561 |
2238684 | 2238684 | 2022-02-21 | Ellis | Texas | 48139 | 47894 | 559 |
2235433 | 2235433 | 2022-02-20 | Ellis | Texas | 48139 | 47871 | 559 |
2232182 | 2232182 | 2022-02-19 | Ellis | Texas | 48139 | 47862 | 557 |
2228931 | 2228931 | 2022-02-18 | Ellis | Texas | 48139 | 47809 | 556 |
2225680 | 2225680 | 2022-02-17 | Ellis | Texas | 48139 | 47764 | 552 |
2222429 | 2222429 | 2022-02-16 | Ellis | Texas | 48139 | 47731 | 550 |
2219178 | 2219178 | 2022-02-15 | Ellis | Texas | 48139 | 47698 | 545 |
2215927 | 2215927 | 2022-02-14 | Ellis | Texas | 48139 | 47650 | 541 |
2212676 | 2212676 | 2022-02-13 | Ellis | Texas | 48139 | 47624 | 540 |
2209423 | 2209423 | 2022-02-12 | Ellis | Texas | 48139 | 47573 | 539 |
2206170 | 2206170 | 2022-02-11 | Ellis | Texas | 48139 | 47500 | 537 |
2202917 | 2202917 | 2022-02-10 | Ellis | Texas | 48139 | 47406 | 534 |
2199663 | 2199663 | 2022-02-09 | Ellis | Texas | 48139 | 47324 | 529 |
2196409 | 2196409 | 2022-02-08 | Ellis | Texas | 48139 | 47251 | 524 |
2193155 | 2193155 | 2022-02-07 | Ellis | Texas | 48139 | 47185 | 524 |
2189901 | 2189901 | 2022-02-06 | Ellis | Texas | 48139 | 47099 | 524 |
2186648 | 2186648 | 2022-02-05 | Ellis | Texas | 48139 | 47016 | 523 |
2183396 | 2183396 | 2022-02-04 | Ellis | Texas | 48139 | 46891 | 523 |
2180144 | 2180144 | 2022-02-03 | Ellis | Texas | 48139 | 46759 | 523 |
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);