ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 48139 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, 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 ▼ |
---|---|---|---|---|---|---|---|
3678 | 3678 | 2020-03-17 | Ellis | Texas | 48139 | 2 | 0 |
4301 | 4301 | 2020-03-18 | Ellis | Texas | 48139 | 2 | 0 |
5055 | 5055 | 2020-03-19 | Ellis | Texas | 48139 | 2 | 0 |
5946 | 5946 | 2020-03-20 | Ellis | Texas | 48139 | 2 | 0 |
6966 | 6966 | 2020-03-21 | Ellis | Texas | 48139 | 3 | 0 |
8096 | 8096 | 2020-03-22 | Ellis | Texas | 48139 | 5 | 0 |
9314 | 9314 | 2020-03-23 | Ellis | Texas | 48139 | 5 | 0 |
10650 | 10650 | 2020-03-24 | Ellis | Texas | 48139 | 5 | 0 |
12136 | 12136 | 2020-03-25 | Ellis | Texas | 48139 | 6 | 0 |
13765 | 13765 | 2020-03-26 | Ellis | Texas | 48139 | 6 | 0 |
15519 | 15519 | 2020-03-27 | Ellis | Texas | 48139 | 13 | 0 |
17388 | 17388 | 2020-03-28 | Ellis | Texas | 48139 | 13 | 0 |
19340 | 19340 | 2020-03-29 | Ellis | Texas | 48139 | 15 | 0 |
21399 | 21399 | 2020-03-30 | Ellis | Texas | 48139 | 16 | 1 |
23538 | 23538 | 2020-03-31 | Ellis | Texas | 48139 | 16 | 1 |
25746 | 25746 | 2020-04-01 | Ellis | Texas | 48139 | 20 | 1 |
28027 | 28027 | 2020-04-02 | Ellis | Texas | 48139 | 26 | 1 |
30362 | 30362 | 2020-04-03 | Ellis | Texas | 48139 | 27 | 1 |
32755 | 32755 | 2020-04-04 | Ellis | Texas | 48139 | 32 | 2 |
35193 | 35193 | 2020-04-05 | Ellis | Texas | 48139 | 32 | 2 |
37669 | 37669 | 2020-04-06 | Ellis | Texas | 48139 | 38 | 2 |
40194 | 40194 | 2020-04-07 | Ellis | Texas | 48139 | 38 | 2 |
42759 | 42759 | 2020-04-08 | Ellis | Texas | 48139 | 44 | 2 |
45348 | 45348 | 2020-04-09 | Ellis | Texas | 48139 | 44 | 2 |
47968 | 47968 | 2020-04-10 | Ellis | Texas | 48139 | 63 | 2 |
50626 | 50626 | 2020-04-11 | Ellis | Texas | 48139 | 71 | 2 |
53301 | 53301 | 2020-04-12 | Ellis | Texas | 48139 | 71 | 2 |
55989 | 55989 | 2020-04-13 | Ellis | Texas | 48139 | 73 | 3 |
58694 | 58694 | 2020-04-14 | Ellis | Texas | 48139 | 73 | 3 |
61411 | 61411 | 2020-04-15 | Ellis | Texas | 48139 | 83 | 3 |
64138 | 64138 | 2020-04-16 | Ellis | Texas | 48139 | 83 | 3 |
66885 | 66885 | 2020-04-17 | Ellis | Texas | 48139 | 94 | 3 |
69645 | 69645 | 2020-04-18 | Ellis | Texas | 48139 | 94 | 3 |
72413 | 72413 | 2020-04-19 | Ellis | Texas | 48139 | 99 | 3 |
75188 | 75188 | 2020-04-20 | Ellis | Texas | 48139 | 101 | 4 |
77970 | 77970 | 2020-04-21 | Ellis | Texas | 48139 | 101 | 4 |
80761 | 80761 | 2020-04-22 | Ellis | Texas | 48139 | 110 | 4 |
83561 | 83561 | 2020-04-23 | Ellis | Texas | 48139 | 111 | 4 |
86366 | 86366 | 2020-04-24 | Ellis | Texas | 48139 | 121 | 4 |
89181 | 89181 | 2020-04-25 | Ellis | Texas | 48139 | 127 | 5 |
91998 | 91998 | 2020-04-26 | Ellis | Texas | 48139 | 127 | 5 |
94827 | 94827 | 2020-04-27 | Ellis | Texas | 48139 | 133 | 5 |
97667 | 97667 | 2020-04-28 | Ellis | Texas | 48139 | 133 | 5 |
100517 | 100517 | 2020-04-29 | Ellis | Texas | 48139 | 143 | 6 |
103370 | 103370 | 2020-04-30 | Ellis | Texas | 48139 | 148 | 6 |
106234 | 106234 | 2020-05-01 | Ellis | Texas | 48139 | 148 | 6 |
109103 | 109103 | 2020-05-02 | Ellis | Texas | 48139 | 166 | 6 |
111977 | 111977 | 2020-05-03 | Ellis | Texas | 48139 | 166 | 6 |
114859 | 114859 | 2020-05-04 | Ellis | Texas | 48139 | 169 | 6 |
117818 | 117818 | 2020-05-05 | Ellis | Texas | 48139 | 176 | 6 |
120782 | 120782 | 2020-05-06 | Ellis | Texas | 48139 | 184 | 9 |
123761 | 123761 | 2020-05-07 | Ellis | Texas | 48139 | 188 | 10 |
126744 | 126744 | 2020-05-08 | Ellis | Texas | 48139 | 193 | 11 |
129733 | 129733 | 2020-05-09 | Ellis | Texas | 48139 | 202 | 11 |
132723 | 132723 | 2020-05-10 | Ellis | Texas | 48139 | 202 | 11 |
135714 | 135714 | 2020-05-11 | Ellis | Texas | 48139 | 211 | 11 |
138704 | 138704 | 2020-05-12 | Ellis | Texas | 48139 | 216 | 11 |
141700 | 141700 | 2020-05-13 | Ellis | Texas | 48139 | 221 | 11 |
144697 | 144697 | 2020-05-14 | Ellis | Texas | 48139 | 236 | 11 |
147699 | 147699 | 2020-05-15 | Ellis | Texas | 48139 | 241 | 11 |
150707 | 150707 | 2020-05-16 | Ellis | Texas | 48139 | 247 | 12 |
153718 | 153718 | 2020-05-17 | Ellis | Texas | 48139 | 247 | 12 |
156735 | 156735 | 2020-05-18 | Ellis | Texas | 48139 | 247 | 12 |
159757 | 159757 | 2020-05-19 | Ellis | Texas | 48139 | 258 | 12 |
162784 | 162784 | 2020-05-20 | Ellis | Texas | 48139 | 264 | 12 |
165813 | 165813 | 2020-05-21 | Ellis | Texas | 48139 | 266 | 12 |
168849 | 168849 | 2020-05-22 | Ellis | Texas | 48139 | 266 | 12 |
171888 | 171888 | 2020-05-23 | Ellis | Texas | 48139 | 272 | 12 |
174931 | 174931 | 2020-05-24 | Ellis | Texas | 48139 | 272 | 12 |
177975 | 177975 | 2020-05-25 | Ellis | Texas | 48139 | 272 | 12 |
181018 | 181018 | 2020-05-26 | Ellis | Texas | 48139 | 289 | 12 |
184068 | 184068 | 2020-05-27 | Ellis | Texas | 48139 | 290 | 13 |
187125 | 187125 | 2020-05-28 | Ellis | Texas | 48139 | 305 | 13 |
190189 | 190189 | 2020-05-29 | Ellis | Texas | 48139 | 309 | 14 |
193254 | 193254 | 2020-05-30 | Ellis | Texas | 48139 | 317 | 14 |
196324 | 196324 | 2020-05-31 | Ellis | Texas | 48139 | 317 | 14 |
199397 | 199397 | 2020-06-01 | Ellis | Texas | 48139 | 317 | 14 |
202472 | 202472 | 2020-06-02 | Ellis | Texas | 48139 | 325 | 15 |
205551 | 205551 | 2020-06-03 | Ellis | Texas | 48139 | 332 | 15 |
208633 | 208633 | 2020-06-04 | Ellis | Texas | 48139 | 338 | 15 |
211717 | 211717 | 2020-06-05 | Ellis | Texas | 48139 | 361 | 16 |
214804 | 214804 | 2020-06-06 | Ellis | Texas | 48139 | 364 | 16 |
217894 | 217894 | 2020-06-07 | Ellis | Texas | 48139 | 364 | 16 |
220986 | 220986 | 2020-06-08 | Ellis | Texas | 48139 | 364 | 16 |
224081 | 224081 | 2020-06-09 | Ellis | Texas | 48139 | 399 | 16 |
227181 | 227181 | 2020-06-10 | Ellis | Texas | 48139 | 418 | 18 |
230285 | 230285 | 2020-06-11 | Ellis | Texas | 48139 | 429 | 18 |
233389 | 233389 | 2020-06-12 | Ellis | Texas | 48139 | 437 | 18 |
236495 | 236495 | 2020-06-13 | Ellis | Texas | 48139 | 448 | 19 |
239603 | 239603 | 2020-06-14 | Ellis | Texas | 48139 | 448 | 19 |
242713 | 242713 | 2020-06-15 | Ellis | Texas | 48139 | 448 | 19 |
245825 | 245825 | 2020-06-16 | Ellis | Texas | 48139 | 458 | 19 |
248938 | 248938 | 2020-06-17 | Ellis | Texas | 48139 | 470 | 19 |
252053 | 252053 | 2020-06-18 | Ellis | Texas | 48139 | 490 | 19 |
255168 | 255168 | 2020-06-19 | Ellis | Texas | 48139 | 510 | 19 |
258295 | 258295 | 2020-06-20 | Ellis | Texas | 48139 | 510 | 19 |
261422 | 261422 | 2020-06-21 | Ellis | Texas | 48139 | 510 | 19 |
264550 | 264550 | 2020-06-22 | Ellis | Texas | 48139 | 510 | 19 |
267678 | 267678 | 2020-06-23 | Ellis | Texas | 48139 | 539 | 19 |
270812 | 270812 | 2020-06-24 | Ellis | Texas | 48139 | 684 | 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);