ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where fips = 48029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 638 ✖
- 11 15
- 2 8
- 187758 7
- 224679 7
- 225559 7
- 226416 7
- 227486 7
- 228650 7
- 230635 7
- 222910 6
- 233179 6
- 224197 5
- 239062 5
- 288389 5
- 326570 5
- 10 4
- 68388 4
- 106805 4
- 205789 4
- 322466 4
- 334634 4
- 339899 4
- 557963 4
- 4 3
- 13 3
- 50 3
- 2120 3
- 76762 3
- 115697 3
- 208864 3
- 211434 3
- 214711 3
- 217498 3
- 219133 3
- 220629 3
- 221676 3
- 249550 3
- 259648 3
- 270223 3
- 279378 3
- 296585 3
- 302976 3
- 307529 3
- 311345 3
- 314488 3
- 316907 3
- 319170 3
- 321198 3
- 324022 3
- 325502 3
- 328286 3
- 12 2
- 514 2
- 901 2
- 42971 2
- 44277 2
- 44653 2
- 47555 2
- 54207 2
- 59526 2
- 236694 2
- 244814 2
- 313017 2
- 320471 2
- 321884 2
- 323649 2
- 1 1
- 17 1
- 40 1
- 68 1
- 69 1
- 84 1
- 113 1
- 125 1
- 140 1
- 157 1
- 207 1
- 229 1
- 254 1
- 342 1
- 395 1
- 421 1
- 467 1
- 626 1
- 676 1
- 723 1
- 734 1
- 783 1
- 805 1
- 970 1
- 1003 1
- 1015 1
- 1040 1
- 1080 1
- 1126 1
- 1178 1
- 1206 1
- 1243 1
- 1254 1
- 1287 1
- 1307 1
- 1326 1
- 1374 1
- 1489 1
- 1585 1
- 1625 1
- 1664 1
- 1689 1
- 1761 1
- 1805 1
- 1835 1
- 1887 1
- 1901 1
- 1920 1
- 1942 1
- 1976 1
- 2041 1
- 2192 1
- 2278 1
- 2322 1
- 2371 1
- 2392 1
- 2418 1
- 2454 1
- 2461 1
- 2492 1
- 2537 1
- 2595 1
- 2648 1
- 2837 1
- 2842 1
- 2851 1
- 2894 1
- 2965 1
- 3030 1
- 3155 1
- 3302 1
- 3323 1
- 3345 1
- 3525 1
- 3660 1
- 3852 1
- 4024 1
- 4254 1
- 4405 1
- 4449 1
- 4888 1
- 5154 1
- 5562 1
- 5974 1
- 6356 1
- 6894 1
- 7168 1
- 7479 1
- 7826 1
- 8464 1
- 8869 1
- 9664 1
- 10159 1
- 10809 1
- 12077 1
- 12516 1
- 12890 1
- 14224 1
- 14565 1
- 14763 1
- 15114 1
- 15892 1
- 16737 1
- 17691 1
- 18614 1
- 19149 1
- 19660 1
- 20225 1
- 21079 1
- 21558 1
- 27059 1
- 27537 1
- 28645 1
- 30847 1
- 31328 1
- 31879 1
- 33567 1
- 34645 1
- 34944 1
- 35702 1
- 36095 1
- 36450 1
- 37996 1
- 38942 1
- 40265 1
- 40815 1
- 41094 1
- 41150 1
- 41189 1
- 41286 1
- 41626 1
- 41951 1
- 42311 1
- 42543 1
- 42795 1
- 43467 1
- 43685 1
- 43835 1
- 44005 1
- 44064 1
- 44134 1
- 45168 1
- 45267 1
- 45376 1
- 45500 1
- 45634 1
- 45823 1
- 46095 1
- 46303 1
- 46413 1
- 46453 1
- 46645 1
- 46925 1
- 47082 1
- 47196 1
- 47327 1
- 47748 1
- 47899 1
- 47968 1
- 48086 1
- 48210 1
- 49927 1
- 50028 1
- 50143 1
- 50296 1
- 50437 1
- 50599 1
- 50772 1
- 53353 1
- 53455 1
- 53651 1
- 53806 1
- 53983 1
- 57157 1
- 57220 1
- 57689 1
- 57844 1
- 57948 1
- 58051 1
- 58196 1
- 58690 1
- 58758 1
- 58951 1
- 59165 1
- 59335 1
- 59696 1
- 59742 1
- 59914 1
- 60046 1
- 60270 1
- 60454 1
- 60641 1
- 63340 1
- 63438 1
- 63606 1
- 63819 1
- 64026 1
- 64273 1
- 64488 1
- 64628 1
- 64779 1
- 64953 1
- 65234 1
- 65435 1
- 65612 1
- 65885 1
- 66076 1
- 66243 1
- 66541 1
- 66726 1
- 66921 1
- 67139 1
- 67377 1
- 67639 1
- 68056 1
- 69805 1
- 70054 1
- 70248 1
- 70540 1
- 70906 1
- 71389 1
- 72325 1
- 72817 1
- 73894 1
- 74603 1
- 75730 1
- 78423 1
- 80069 1
- 81186 1
- 81638 1
- 83137 1
- 83897 1
- 85213 1
- 85907 1
- 86998 1
- 88208 1
- 89502 1
- 90232 1
- 91406 1
- 92496 1
- 93488 1
- 94194 1
- 94793 1
- 96152 1
- 97548 1
- 99154 1
- 100090 1
- 100834 1
- 102176 1
- 103459 1
- 105176 1
- 112230 1
- 112273 1
- 114374 1
- 119367 1
- 121603 1
- 122660 1
- 124812 1
- 126909 1
- 128079 1
- 129158 1
- 130459 1
- 133531 1
- 135116 1
- 137419 1
- 138797 1
- 140626 1
- 143515 1
- 146355 1
- 148567 1
- 149848 1
- 152243 1
- 153093 1
- 155600 1
- 157847 1
- 159531 1
- 160038 1
- 162120 1
- 162941 1
- 164282 1
- 166034 1
- 167579 1
- 169700 1
- 173166 1
- 175542 1
- 176802 1
- 177814 1
- 178674 1
- 180398 1
- 181023 1
- 183213 1
- 183448 1
- 184796 1
- 185456 1
- 186358 1
- 187074 1
- 189975 1
- 193473 1
- 193703 1
- 193973 1
- 194344 1
- 194748 1
- 195249 1
- 195731 1
- 196540 1
- 196828 1
- 197077 1
- 197267 1
- 197509 1
- 197796 1
- 197933 1
- 198580 1
- 198810 1
- 198981 1
- 199077 1
- 199443 1
- 199601 1
- 199685 1
- 200676 1
- 200830 1
- 201022 1
- 201208 1
- 201285 1
- 201423 1
- 201704 1
- 202562 1
- 202728 1
- 202861 1
- 202993 1
- 203203 1
- 203382 1
- 203535 1
- 205111 1
- 205270 1
- 205418 1
- 205540 1
- 207961 1
- 208184 1
- 208474 1
- 208618 1
- 210808 1
- 211081 1
- 211333 1
- 211409 1
- 213689 1
- 214083 1
- 214394 1
- 214643 1
- 216351 1
- 216488 1
- 216890 1
- 217231 1
- 218559 1
- 218724 1
- 218831 1
- 219020 1
- 219941 1
- 220066 1
- 220264 1
- 220529 1
- 221190 1
- 221349 1
- 221497 1
- 221615 1
- 222441 1
- 222583 1
- 222598 1
- 222772 1
- 224096 1
- 248196 1
- 252731 1
- 254645 1
- 256594 1
- 257806 1
- 264250 1
- 266039 1
- 267642 1
- 268982 1
- 273925 1
- 275179 1
- 276447 1
- 277788 1
- 282921 1
- 283785 1
- 285742 1
- 287423 1
- 294000 1
- 295965 1
- 299500 1
- 300275 1
- 301432 1
- 302166 1
- 304946 1
- 305290 1
- 306210 1
- 306781 1
- 309469 1
- 309910 1
- 310552 1
- 310969 1
- 313801 1
- 314197 1
- 315661 1
- 316092 1
- 316402 1
- 316651 1
- 318138 1
- 318399 1
- 318747 1
- 318961 1
- 320626 1
- 321025 1
- 322157 1
- 322327 1
- 323434 1
- 324838 1
- 325106 1
- 325332 1
- 325489 1
- 326147 1
- 326435 1
- 327406 1
- 327604 1
- 327794 1
- 328044 1
- 329136 1
- 329490 1
- 329723 1
- 329990 1
- 330299 1
- 330630 1
- 330791 1
- 331071 1
- 331322 1
- 331565 1
- 331846 1
- 332130 1
- 332445 1
- 332811 1
- 333260 1
- 333807 1
- 334216 1
- 337657 1
- 338678 1
- 339155 1
- 353345 1
- 358229 1
- 361438 1
- 364052 1
- 368897 1
- 373793 1
- 377656 1
- 382083 1
- 387060 1
- 395893 1
- 402353 1
- 411317 1
- 419517 1
- 423977 1
- 433429 1
- 439392 1
- 446704 1
- 453025 1
- 459181 1
- 464736 1
- 468927 1
- 475972 1
- 481819 1
- 486741 1
- 491302 1
- 496811 1
- 502221 1
- 504911 1
- 507920 1
- 513824 1
- 516859 1
- 519321 1
- 521501 1
- 523514 1
- 525923 1
- 527675 1
- 529136 1
- 530179 1
- 532001 1
- 533372 1
- 534410 1
- 535332 1
- 535791 1
- 537149 1
- 537781 1
- 538648 1
- 539172 1
- 540313 1
- 540487 1
- 540858 1
- 541581 1
- 541961 1
- 542472 1
- 542930 1
- 543350 1
- 543450 1
- 544104 1
- 544615 1
- 544984 1
- 545340 1
- 545702 1
- 546165 1
- 546219 1
- 546417 1
- 547096 1
- 547710 1
- 548413 1
- 549669 1
- 549990 1
- 550078 1
- 550137 1
- 550386 1
- 550651 1
- 550886 1
- 551177 1
- 551258 1
- 551384 1
- 551429 1
- 551603 1
- 551869 1
- 552157 1
- 552514 1
- 554964 1
- 554992 1
- 555008 1
- 555291 1
- 555452 1
- 555651 1
- 555738 1
- 555890 1
- 555976 1
- 556055 1
- 556312 1
- 556552 1
- 556782 1
- 556988 1
- 557072 1
- 557147 1
- 557213 1
- 557456 1
- 557710 1
- 558662 1
- 558922 1
- 559154 1
- 559395 1
- 559708 1
- 559941 1
- 560085 1
- 560200 1
- 560455 1
- 560772 1
- 561122 1
- 561401 1
- 561726 1
- 561892 1
- 562018 1
- 562259 1
- 562471 1
- 562708 1
- 563014 1
- 563315 1
- 563508 1
- 563679 1
- 564018 1
- 564350 1
- 564722 1
- 565111 1
state 1
- Texas 822
fips 1
- 48029 · 822 ✖
county 1
- Bexar 822
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502221 | 2502221 | 2022-05-13 | Bexar | Texas | 48029 | 565111 | 6131 |
2498963 | 2498963 | 2022-05-12 | Bexar | Texas | 48029 | 564722 | 6129 |
2495705 | 2495705 | 2022-05-11 | Bexar | Texas | 48029 | 564350 | 6127 |
2492447 | 2492447 | 2022-05-10 | Bexar | Texas | 48029 | 564018 | 6127 |
2489189 | 2489189 | 2022-05-09 | Bexar | Texas | 48029 | 563679 | 6126 |
2485932 | 2485932 | 2022-05-08 | Bexar | Texas | 48029 | 563508 | 6127 |
2482674 | 2482674 | 2022-05-07 | Bexar | Texas | 48029 | 563315 | 6127 |
2479416 | 2479416 | 2022-05-06 | Bexar | Texas | 48029 | 563014 | 6126 |
2476158 | 2476158 | 2022-05-05 | Bexar | Texas | 48029 | 562708 | 6124 |
2472901 | 2472901 | 2022-05-04 | Bexar | Texas | 48029 | 562471 | 6124 |
2469645 | 2469645 | 2022-05-03 | Bexar | Texas | 48029 | 562259 | 6123 |
2466389 | 2466389 | 2022-05-02 | Bexar | Texas | 48029 | 562018 | 6123 |
2463134 | 2463134 | 2022-05-01 | Bexar | Texas | 48029 | 561892 | 6123 |
2459878 | 2459878 | 2022-04-30 | Bexar | Texas | 48029 | 561726 | 6123 |
2456622 | 2456622 | 2022-04-29 | Bexar | Texas | 48029 | 561401 | 6122 |
2453366 | 2453366 | 2022-04-28 | Bexar | Texas | 48029 | 561122 | 6121 |
2450110 | 2450110 | 2022-04-27 | Bexar | Texas | 48029 | 560772 | 6121 |
2446853 | 2446853 | 2022-04-26 | Bexar | Texas | 48029 | 560455 | 6120 |
2443598 | 2443598 | 2022-04-25 | Bexar | Texas | 48029 | 560200 | 6120 |
2440342 | 2440342 | 2022-04-24 | Bexar | Texas | 48029 | 560085 | 6120 |
2437086 | 2437086 | 2022-04-23 | Bexar | Texas | 48029 | 559941 | 6120 |
2433830 | 2433830 | 2022-04-22 | Bexar | Texas | 48029 | 559708 | 6118 |
2430574 | 2430574 | 2022-04-21 | Bexar | Texas | 48029 | 559395 | 6118 |
2427318 | 2427318 | 2022-04-20 | Bexar | Texas | 48029 | 559154 | 6117 |
2424062 | 2424062 | 2022-04-19 | Bexar | Texas | 48029 | 558922 | 6117 |
2420806 | 2420806 | 2022-04-18 | Bexar | Texas | 48029 | 558662 | 6112 |
2417550 | 2417550 | 2022-04-17 | Bexar | Texas | 48029 | 557963 | 6111 |
2414294 | 2414294 | 2022-04-16 | Bexar | Texas | 48029 | 557963 | 6111 |
2411038 | 2411038 | 2022-04-15 | Bexar | Texas | 48029 | 557963 | 6111 |
2407782 | 2407782 | 2022-04-14 | Bexar | Texas | 48029 | 557963 | 6111 |
2404526 | 2404526 | 2022-04-13 | Bexar | Texas | 48029 | 557710 | 6109 |
2401271 | 2401271 | 2022-04-12 | Bexar | Texas | 48029 | 557456 | 6105 |
2398016 | 2398016 | 2022-04-11 | Bexar | Texas | 48029 | 557213 | 6103 |
2394761 | 2394761 | 2022-04-10 | Bexar | Texas | 48029 | 557147 | 6103 |
2391505 | 2391505 | 2022-04-09 | Bexar | Texas | 48029 | 557072 | 6104 |
2388249 | 2388249 | 2022-04-08 | Bexar | Texas | 48029 | 556988 | 6102 |
2384994 | 2384994 | 2022-04-07 | Bexar | Texas | 48029 | 556782 | 6101 |
2381739 | 2381739 | 2022-04-06 | Bexar | Texas | 48029 | 556552 | 6097 |
2378484 | 2378484 | 2022-04-05 | Bexar | Texas | 48029 | 556312 | 6094 |
2375230 | 2375230 | 2022-04-04 | Bexar | Texas | 48029 | 556055 | 6092 |
2371978 | 2371978 | 2022-04-03 | Bexar | Texas | 48029 | 555976 | 6091 |
2368725 | 2368725 | 2022-04-02 | Bexar | Texas | 48029 | 555890 | 6089 |
2365472 | 2365472 | 2022-04-01 | Bexar | Texas | 48029 | 555738 | 6087 |
2362219 | 2362219 | 2022-03-31 | Bexar | Texas | 48029 | 555651 | 6084 |
2358965 | 2358965 | 2022-03-30 | Bexar | Texas | 48029 | 555452 | 6080 |
2355711 | 2355711 | 2022-03-29 | Bexar | Texas | 48029 | 555291 | 6075 |
2352458 | 2352458 | 2022-03-28 | Bexar | Texas | 48029 | 555008 | 6071 |
2349206 | 2349206 | 2022-03-27 | Bexar | Texas | 48029 | 554992 | 6071 |
2345953 | 2345953 | 2022-03-26 | Bexar | Texas | 48029 | 554964 | 6069 |
2342700 | 2342700 | 2022-03-25 | Bexar | Texas | 48029 | 552514 | 6066 |
2339447 | 2339447 | 2022-03-24 | Bexar | Texas | 48029 | 552157 | 6058 |
2336193 | 2336193 | 2022-03-23 | Bexar | Texas | 48029 | 551869 | 6049 |
2332939 | 2332939 | 2022-03-22 | Bexar | Texas | 48029 | 551603 | 6042 |
2329686 | 2329686 | 2022-03-21 | Bexar | Texas | 48029 | 551429 | 6037 |
2326434 | 2326434 | 2022-03-20 | Bexar | Texas | 48029 | 551384 | 6036 |
2323181 | 2323181 | 2022-03-19 | Bexar | Texas | 48029 | 551258 | 6036 |
2319927 | 2319927 | 2022-03-18 | Bexar | Texas | 48029 | 551177 | 6029 |
2316673 | 2316673 | 2022-03-17 | Bexar | Texas | 48029 | 550886 | 6020 |
2313420 | 2313420 | 2022-03-16 | Bexar | Texas | 48029 | 550651 | 6015 |
2310167 | 2310167 | 2022-03-15 | Bexar | Texas | 48029 | 550386 | 6003 |
2306914 | 2306914 | 2022-03-14 | Bexar | Texas | 48029 | 550137 | 6001 |
2303663 | 2303663 | 2022-03-13 | Bexar | Texas | 48029 | 550078 | 6001 |
2300411 | 2300411 | 2022-03-12 | Bexar | Texas | 48029 | 549990 | 5999 |
2297159 | 2297159 | 2022-03-11 | Bexar | Texas | 48029 | 549669 | 5990 |
2293907 | 2293907 | 2022-03-10 | Bexar | Texas | 48029 | 548413 | 5983 |
2290655 | 2290655 | 2022-03-09 | Bexar | Texas | 48029 | 547710 | 5975 |
2287403 | 2287403 | 2022-03-08 | Bexar | Texas | 48029 | 547096 | 5959 |
2284151 | 2284151 | 2022-03-07 | Bexar | Texas | 48029 | 546417 | 5956 |
2280899 | 2280899 | 2022-03-06 | Bexar | Texas | 48029 | 546219 | 5956 |
2277646 | 2277646 | 2022-03-05 | Bexar | Texas | 48029 | 546165 | 5956 |
2274393 | 2274393 | 2022-03-04 | Bexar | Texas | 48029 | 545702 | 5950 |
2271140 | 2271140 | 2022-03-03 | Bexar | Texas | 48029 | 545340 | 5934 |
2267888 | 2267888 | 2022-03-02 | Bexar | Texas | 48029 | 544984 | 5926 |
2264635 | 2264635 | 2022-03-01 | Bexar | Texas | 48029 | 544615 | 5913 |
2261385 | 2261385 | 2022-02-28 | Bexar | Texas | 48029 | 544104 | 5904 |
2258134 | 2258134 | 2022-02-27 | Bexar | Texas | 48029 | 543450 | 5902 |
2254883 | 2254883 | 2022-02-26 | Bexar | Texas | 48029 | 543350 | 5895 |
2251632 | 2251632 | 2022-02-25 | Bexar | Texas | 48029 | 542930 | 5882 |
2248381 | 2248381 | 2022-02-24 | Bexar | Texas | 48029 | 542472 | 5871 |
2245130 | 2245130 | 2022-02-23 | Bexar | Texas | 48029 | 541961 | 5850 |
2241879 | 2241879 | 2022-02-22 | Bexar | Texas | 48029 | 541581 | 5825 |
2238628 | 2238628 | 2022-02-21 | Bexar | Texas | 48029 | 540858 | 5812 |
2235377 | 2235377 | 2022-02-20 | Bexar | Texas | 48029 | 540487 | 5812 |
2232126 | 2232126 | 2022-02-19 | Bexar | Texas | 48029 | 540313 | 5809 |
2228875 | 2228875 | 2022-02-18 | Bexar | Texas | 48029 | 539172 | 5789 |
2225624 | 2225624 | 2022-02-17 | Bexar | Texas | 48029 | 538648 | 5776 |
2222373 | 2222373 | 2022-02-16 | Bexar | Texas | 48029 | 537781 | 5762 |
2219122 | 2219122 | 2022-02-15 | Bexar | Texas | 48029 | 537149 | 5739 |
2215871 | 2215871 | 2022-02-14 | Bexar | Texas | 48029 | 535791 | 5724 |
2212620 | 2212620 | 2022-02-13 | Bexar | Texas | 48029 | 535332 | 5722 |
2209367 | 2209367 | 2022-02-12 | Bexar | Texas | 48029 | 534410 | 5706 |
2206114 | 2206114 | 2022-02-11 | Bexar | Texas | 48029 | 533372 | 5686 |
2202861 | 2202861 | 2022-02-10 | Bexar | Texas | 48029 | 532001 | 5665 |
2199607 | 2199607 | 2022-02-09 | Bexar | Texas | 48029 | 530179 | 5645 |
2196353 | 2196353 | 2022-02-08 | Bexar | Texas | 48029 | 529136 | 5629 |
2193099 | 2193099 | 2022-02-07 | Bexar | Texas | 48029 | 527675 | 5612 |
2189845 | 2189845 | 2022-02-06 | Bexar | Texas | 48029 | 525923 | 5610 |
2186592 | 2186592 | 2022-02-05 | Bexar | Texas | 48029 | 523514 | 5611 |
2183340 | 2183340 | 2022-02-04 | Bexar | Texas | 48029 | 521501 | 5601 |
2180088 | 2180088 | 2022-02-03 | Bexar | Texas | 48029 | 519321 | 5592 |
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);