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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
deaths 264 ✖
- 19 26
- 325 23
- 310 16
- 309 15
- 0 13
- 21 13
- 68 13
- 323 13
- 324 12
- 12 11
- 2 9
- 322 9
- 11 8
- 3 7
- 6 7
- 311 7
- 300 6
- 312 6
- 319 6
- 475 6
- 479 6
- 489 6
- 490 6
- 1 5
- 4 5
- 16 5
- 20 5
- 55 5
- 60 5
- 62 5
- 266 5
- 308 5
- 314 5
- 327 5
- 470 5
- 486 5
- 491 5
- 5 4
- 14 4
- 33 4
- 54 4
- 56 4
- 71 4
- 74 4
- 75 4
- 100 4
- 127 4
- 143 4
- 288 4
- 296 4
- 316 4
- 331 4
- 336 4
- 465 4
- 480 4
- 509 4
- 15 3
- 18 3
- 34 3
- 48 3
- 51 3
- 66 3
- 76 3
- 83 3
- 138 3
- 159 3
- 176 3
- 267 3
- 302 3
- 306 3
- 313 3
- 329 3
- 350 3
- 410 3
- 411 3
- 430 3
- 467 3
- 478 3
- 485 3
- 493 3
- 497 3
- 503 3
- 518 3
- 13 2
- 41 2
- 58 2
- 61 2
- 64 2
- 67 2
- 73 2
- 81 2
- 91 2
- 103 2
- 107 2
- 108 2
- 111 2
- 115 2
- 185 2
- 187 2
- 199 2
- 219 2
- 232 2
- 268 2
- 270 2
- 276 2
- 280 2
- 292 2
- 360 2
- 374 2
- 388 2
- 400 2
- 401 2
- 438 2
- 455 2
- 477 2
- 481 2
- 482 2
- 500 2
- 508 2
- 9 1
- 10 1
- 32 1
- 35 1
- 37 1
- 38 1
- 40 1
- 42 1
- 43 1
- 50 1
- 53 1
- 63 1
- 69 1
- 70 1
- 72 1
- 77 1
- 78 1
- 79 1
- 84 1
- 85 1
- 87 1
- 88 1
- 92 1
- 95 1
- 96 1
- 101 1
- 104 1
- 106 1
- 113 1
- 116 1
- 117 1
- 118 1
- 121 1
- 128 1
- 132 1
- 137 1
- 139 1
- 141 1
- 145 1
- 147 1
- 151 1
- 156 1
- 158 1
- 163 1
- 167 1
- 174 1
- 175 1
- 177 1
- 179 1
- 180 1
- 181 1
- 183 1
- 188 1
- 192 1
- 196 1
- 201 1
- 205 1
- 209 1
- 213 1
- 217 1
- 223 1
- 228 1
- 229 1
- 231 1
- 233 1
- 237 1
- 242 1
- 244 1
- 247 1
- 249 1
- 250 1
- 251 1
- 256 1
- 258 1
- 263 1
- 264 1
- 272 1
- 273 1
- 274 1
- 283 1
- 284 1
- 294 1
- 299 1
- 303 1
- 307 1
- 315 1
- 317 1
- 318 1
- 333 1
- 335 1
- 337 1
- 342 1
- 345 1
- 346 1
- 349 1
- 353 1
- 357 1
- 358 1
- 361 1
- 362 1
- 363 1
- 364 1
- 366 1
- 370 1
- 377 1
- 379 1
- 380 1
- 383 1
- 385 1
- 390 1
- 394 1
- 397 1
- 406 1
- 413 1
- 416 1
- 419 1
- 422 1
- 427 1
- 431 1
- 434 1
- 435 1
- 437 1
- 441 1
- 444 1
- 445 1
- 449 1
- 454 1
- 458 1
- 461 1
- 463 1
- 469 1
- 473 1
- 484 1
- 487 1
- 494 1
- 495 1
- 498 1
- 499 1
- 504 1
- 506 1
- 513 1
- 514 1
- 516 1
- 517 1
- 521 1
state 1
- Texas 688
fips 1
- 48139 · 688 ✖
county 1
- Ellis 688
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176893 | 2176893 | 2022-02-02 | Ellis | Texas | 48139 | 46599 | 521 |
2173639 | 2173639 | 2022-02-01 | Ellis | Texas | 48139 | 46424 | 518 |
2170387 | 2170387 | 2022-01-31 | Ellis | Texas | 48139 | 46209 | 518 |
2167133 | 2167133 | 2022-01-30 | Ellis | Texas | 48139 | 46050 | 518 |
2163878 | 2163878 | 2022-01-29 | Ellis | Texas | 48139 | 45907 | 517 |
2160623 | 2160623 | 2022-01-28 | Ellis | Texas | 48139 | 45638 | 516 |
2157367 | 2157367 | 2022-01-27 | Ellis | Texas | 48139 | 45431 | 514 |
2154114 | 2154114 | 2022-01-26 | Ellis | Texas | 48139 | 45181 | 513 |
2150862 | 2150862 | 2022-01-25 | Ellis | Texas | 48139 | 45002 | 509 |
2147610 | 2147610 | 2022-01-24 | Ellis | Texas | 48139 | 44704 | 509 |
2144356 | 2144356 | 2022-01-23 | Ellis | Texas | 48139 | 44457 | 509 |
2141101 | 2141101 | 2022-01-22 | Ellis | Texas | 48139 | 43975 | 509 |
2137845 | 2137845 | 2022-01-21 | Ellis | Texas | 48139 | 43302 | 508 |
2134591 | 2134591 | 2022-01-20 | Ellis | Texas | 48139 | 42928 | 508 |
2131339 | 2131339 | 2022-01-19 | Ellis | Texas | 48139 | 42685 | 506 |
2128085 | 2128085 | 2022-01-18 | Ellis | Texas | 48139 | 42209 | 504 |
2124833 | 2124833 | 2022-01-17 | Ellis | Texas | 48139 | 41783 | 503 |
2121581 | 2121581 | 2022-01-16 | Ellis | Texas | 48139 | 41303 | 503 |
2118329 | 2118329 | 2022-01-15 | Ellis | Texas | 48139 | 40869 | 503 |
2115078 | 2115078 | 2022-01-14 | Ellis | Texas | 48139 | 40590 | 500 |
2111826 | 2111826 | 2022-01-13 | Ellis | Texas | 48139 | 40493 | 500 |
2108574 | 2108574 | 2022-01-12 | Ellis | Texas | 48139 | 40047 | 499 |
2105323 | 2105323 | 2022-01-11 | Ellis | Texas | 48139 | 39509 | 498 |
2102072 | 2102072 | 2022-01-10 | Ellis | Texas | 48139 | 39098 | 497 |
2098821 | 2098821 | 2022-01-09 | Ellis | Texas | 48139 | 38727 | 497 |
2095569 | 2095569 | 2022-01-08 | Ellis | Texas | 48139 | 38472 | 497 |
2092317 | 2092317 | 2022-01-07 | Ellis | Texas | 48139 | 38092 | 495 |
2089065 | 2089065 | 2022-01-06 | Ellis | Texas | 48139 | 37817 | 494 |
2085814 | 2085814 | 2022-01-05 | Ellis | Texas | 48139 | 37472 | 493 |
2082562 | 2082562 | 2022-01-04 | Ellis | Texas | 48139 | 37129 | 493 |
2079310 | 2079310 | 2022-01-03 | Ellis | Texas | 48139 | 36730 | 493 |
2076059 | 2076059 | 2022-01-02 | Ellis | Texas | 48139 | 35546 | 491 |
2072808 | 2072808 | 2022-01-01 | Ellis | Texas | 48139 | 35546 | 491 |
2069557 | 2069557 | 2021-12-31 | Ellis | Texas | 48139 | 35546 | 491 |
2066306 | 2066306 | 2021-12-30 | Ellis | Texas | 48139 | 35546 | 491 |
2063056 | 2063056 | 2021-12-29 | Ellis | Texas | 48139 | 35408 | 491 |
2059806 | 2059806 | 2021-12-28 | Ellis | Texas | 48139 | 35354 | 490 |
2056557 | 2056557 | 2021-12-27 | Ellis | Texas | 48139 | 35231 | 490 |
2053308 | 2053308 | 2021-12-26 | Ellis | Texas | 48139 | 34917 | 490 |
2050058 | 2050058 | 2021-12-25 | Ellis | Texas | 48139 | 34917 | 490 |
2046808 | 2046808 | 2021-12-24 | Ellis | Texas | 48139 | 34917 | 490 |
2043558 | 2043558 | 2021-12-23 | Ellis | Texas | 48139 | 34917 | 490 |
2040309 | 2040309 | 2021-12-22 | Ellis | Texas | 48139 | 34846 | 489 |
2037059 | 2037059 | 2021-12-21 | Ellis | Texas | 48139 | 34822 | 489 |
2033809 | 2033809 | 2021-12-20 | Ellis | Texas | 48139 | 34746 | 489 |
2030559 | 2030559 | 2021-12-19 | Ellis | Texas | 48139 | 34688 | 489 |
2027308 | 2027308 | 2021-12-18 | Ellis | Texas | 48139 | 34658 | 489 |
2024057 | 2024057 | 2021-12-17 | Ellis | Texas | 48139 | 34606 | 489 |
2020806 | 2020806 | 2021-12-16 | Ellis | Texas | 48139 | 34563 | 487 |
2017555 | 2017555 | 2021-12-15 | Ellis | Texas | 48139 | 34523 | 486 |
2014305 | 2014305 | 2021-12-14 | Ellis | Texas | 48139 | 34484 | 486 |
2011054 | 2011054 | 2021-12-13 | Ellis | Texas | 48139 | 34452 | 486 |
2007803 | 2007803 | 2021-12-12 | Ellis | Texas | 48139 | 34424 | 486 |
2004552 | 2004552 | 2021-12-11 | Ellis | Texas | 48139 | 34413 | 486 |
2001301 | 2001301 | 2021-12-10 | Ellis | Texas | 48139 | 34380 | 485 |
1998051 | 1998051 | 2021-12-09 | Ellis | Texas | 48139 | 34233 | 485 |
1994800 | 1994800 | 2021-12-08 | Ellis | Texas | 48139 | 34221 | 485 |
1991549 | 1991549 | 2021-12-07 | Ellis | Texas | 48139 | 34199 | 484 |
1988298 | 1988298 | 2021-12-06 | Ellis | Texas | 48139 | 34173 | 482 |
1985048 | 1985048 | 2021-12-05 | Ellis | Texas | 48139 | 34163 | 482 |
1981798 | 1981798 | 2021-12-04 | Ellis | Texas | 48139 | 34159 | 481 |
1978548 | 1978548 | 2021-12-03 | Ellis | Texas | 48139 | 34147 | 481 |
1975298 | 1975298 | 2021-12-02 | Ellis | Texas | 48139 | 34133 | 480 |
1972049 | 1972049 | 2021-12-01 | Ellis | Texas | 48139 | 34118 | 480 |
1968799 | 1968799 | 2021-11-30 | Ellis | Texas | 48139 | 34108 | 480 |
1965548 | 1965548 | 2021-11-29 | Ellis | Texas | 48139 | 34071 | 480 |
1962296 | 1962296 | 2021-11-28 | Ellis | Texas | 48139 | 34066 | 479 |
1959045 | 1959045 | 2021-11-27 | Ellis | Texas | 48139 | 34066 | 479 |
1955794 | 1955794 | 2021-11-26 | Ellis | Texas | 48139 | 34066 | 479 |
1952543 | 1952543 | 2021-11-25 | Ellis | Texas | 48139 | 34066 | 479 |
1949292 | 1949292 | 2021-11-24 | Ellis | Texas | 48139 | 34066 | 479 |
1946041 | 1946041 | 2021-11-23 | Ellis | Texas | 48139 | 34050 | 479 |
1942790 | 1942790 | 2021-11-22 | Ellis | Texas | 48139 | 34028 | 478 |
1939540 | 1939540 | 2021-11-21 | Ellis | Texas | 48139 | 34028 | 478 |
1936290 | 1936290 | 2021-11-20 | Ellis | Texas | 48139 | 34028 | 478 |
1933040 | 1933040 | 2021-11-19 | Ellis | Texas | 48139 | 34023 | 477 |
1929789 | 1929789 | 2021-11-18 | Ellis | Texas | 48139 | 34018 | 477 |
1926539 | 1926539 | 2021-11-17 | Ellis | Texas | 48139 | 34016 | 475 |
1923289 | 1923289 | 2021-11-16 | Ellis | Texas | 48139 | 34008 | 475 |
1920040 | 1920040 | 2021-11-15 | Ellis | Texas | 48139 | 33993 | 475 |
1916790 | 1916790 | 2021-11-14 | Ellis | Texas | 48139 | 33993 | 475 |
1913540 | 1913540 | 2021-11-13 | Ellis | Texas | 48139 | 33993 | 475 |
1910290 | 1910290 | 2021-11-12 | Ellis | Texas | 48139 | 33967 | 475 |
1907041 | 1907041 | 2021-11-11 | Ellis | Texas | 48139 | 33967 | 473 |
1903792 | 1903792 | 2021-11-10 | Ellis | Texas | 48139 | 33917 | 470 |
1900542 | 1900542 | 2021-11-09 | Ellis | Texas | 48139 | 33917 | 470 |
1897292 | 1897292 | 2021-11-08 | Ellis | Texas | 48139 | 33878 | 470 |
1894042 | 1894042 | 2021-11-07 | Ellis | Texas | 48139 | 33878 | 470 |
1890792 | 1890792 | 2021-11-06 | Ellis | Texas | 48139 | 33878 | 470 |
1887542 | 1887542 | 2021-11-05 | Ellis | Texas | 48139 | 33857 | 469 |
1884292 | 1884292 | 2021-11-04 | Ellis | Texas | 48139 | 33848 | 467 |
1881043 | 1881043 | 2021-11-03 | Ellis | Texas | 48139 | 33828 | 467 |
1877794 | 1877794 | 2021-11-02 | Ellis | Texas | 48139 | 33812 | 467 |
1874545 | 1874545 | 2021-11-01 | Ellis | Texas | 48139 | 33623 | 465 |
1871296 | 1871296 | 2021-10-31 | Ellis | Texas | 48139 | 33623 | 465 |
1868047 | 1868047 | 2021-10-30 | Ellis | Texas | 48139 | 33623 | 465 |
1864798 | 1864798 | 2021-10-29 | Ellis | Texas | 48139 | 33594 | 465 |
1861549 | 1861549 | 2021-10-28 | Ellis | Texas | 48139 | 33568 | 463 |
1858300 | 1858300 | 2021-10-27 | Ellis | Texas | 48139 | 33390 | 461 |
1855051 | 1855051 | 2021-10-26 | Ellis | Texas | 48139 | 33350 | 458 |
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);