ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "McLennan" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 580 ✖
- 27794 11
- 28443 10
- 27984 9
- 24268 7
- 27716 7
- 29967 7
- 30940 7
- 94 5
- 14029 5
- 17809 5
- 28132 5
- 43001 5
- 76 4
- 81 4
- 91 4
- 107 4
- 19026 4
- 26164 4
- 27356 4
- 27496 4
- 29062 4
- 35596 4
- 43951 4
- 44547 4
- 58328 4
- 96 3
- 98 3
- 118 3
- 21894 3
- 25024 3
- 25335 3
- 25521 3
- 25747 3
- 25991 3
- 26347 3
- 26528 3
- 26761 3
- 26984 3
- 27043 3
- 27138 3
- 27256 3
- 27592 3
- 27640 3
- 27865 3
- 32216 3
- 33698 3
- 37492 3
- 39131 3
- 40030 3
- 40750 3
- 41354 3
- 41741 3
- 42082 3
- 42287 3
- 42498 3
- 42726 3
- 42918 3
- 16 2
- 20 2
- 39 2
- 48 2
- 62 2
- 74 2
- 87 2
- 92 2
- 97 2
- 129 2
- 163 2
- 1636 2
- 3291 2
- 10316 2
- 11093 2
- 12106 2
- 13375 2
- 15092 2
- 16274 2
- 17249 2
- 20594 2
- 22657 2
- 23200 2
- 23575 2
- 24245 2
- 26714 2
- 26896 2
- 27440 2
- 42597 2
- 42673 2
- 42850 2
- 43035 2
- 57738 2
- 5 1
- 7 1
- 13 1
- 23 1
- 28 1
- 33 1
- 34 1
- 36 1
- 49 1
- 50 1
- 51 1
- 56 1
- 66 1
- 68 1
- 69 1
- 71 1
- 72 1
- 77 1
- 78 1
- 82 1
- 88 1
- 89 1
- 102 1
- 106 1
- 112 1
- 113 1
- 117 1
- 120 1
- 121 1
- 123 1
- 125 1
- 127 1
- 132 1
- 138 1
- 141 1
- 150 1
- 153 1
- 158 1
- 196 1
- 222 1
- 245 1
- 262 1
- 303 1
- 354 1
- 371 1
- 421 1
- 473 1
- 552 1
- 624 1
- 697 1
- 744 1
- 795 1
- 957 1
- 1068 1
- 1292 1
- 1563 1
- 1798 1
- 2044 1
- 2283 1
- 2438 1
- 2442 1
- 2537 1
- 2557 1
- 2744 1
- 2920 1
- 3005 1
- 3096 1
- 3210 1
- 3472 1
- 3575 1
- 3688 1
- 3782 1
- 3885 1
- 3957 1
- 3986 1
- 4042 1
- 4108 1
- 4192 1
- 4263 1
- 4326 1
- 4405 1
- 4436 1
- 4571 1
- 4694 1
- 4748 1
- 4846 1
- 4889 1
- 4946 1
- 4970 1
- 5031 1
- 5106 1
- 5164 1
- 5248 1
- 5296 1
- 5322 1
- 5356 1
- 5372 1
- 5435 1
- 5547 1
- 5595 1
- 5642 1
- 5713 1
- 5760 1
- 5796 1
- 5907 1
- 6008 1
- 6100 1
- 6162 1
- 6228 1
- 6264 1
- 6355 1
- 6454 1
- 6549 1
- 6629 1
- 6668 1
- 6707 1
- 6726 1
- 6766 1
- 6813 1
- 6882 1
- 6991 1
- 7059 1
- 7109 1
- 7134 1
- 7188 1
- 7231 1
- 7271 1
- 7336 1
- 7428 1
- 7487 1
- 7520 1
- 7571 1
- 7626 1
- 7779 1
- 7870 1
- 7942 1
- 7983 1
- 8000 1
- 8061 1
- 8122 1
- 8179 1
- 8255 1
- 8334 1
- 8385 1
- 8411 1
- 8583 1
- 8642 1
- 8716 1
- 8800 1
- 8879 1
- 8934 1
- 8963 1
- 9029 1
- 9125 1
- 9187 1
- 9243 1
- 9290 1
- 9399 1
- 9431 1
- 9503 1
- 9573 1
- 9632 1
- 9695 1
- 9772 1
- 9846 1
- 9893 1
- 9961 1
- 10014 1
- 10077 1
- 10194 1
- 10263 1
- 10450 1
- 10528 1
- 10674 1
- 10784 1
- 10917 1
- 11289 1
- 11408 1
- 11625 1
- 11778 1
- 11956 1
- 12323 1
- 12572 1
- 12761 1
- 12947 1
- 13156 1
- 13630 1
- 13817 1
- 14410 1
- 14531 1
- 14672 1
- 14813 1
- 14937 1
- 15331 1
- 15440 1
- 15880 1
- 15990 1
- 16127 1
- 16431 1
- 16570 1
- 16818 1
- 16947 1
- 17087 1
- 17467 1
- 17649 1
- 18350 1
- 18559 1
- 18780 1
- 19561 1
- 19798 1
- 20006 1
- 20303 1
- 20471 1
- 20829 1
- 21296 1
- 21407 1
- 21598 1
- 21809 1
- 22292 1
- 22373 1
- 22506 1
- 22587 1
- 22801 1
- 22846 1
- 22994 1
- 23074 1
- 23140 1
- 23284 1
- 23333 1
- 23444 1
- 23499 1
- 23624 1
- 23826 1
- 23953 1
- 24112 1
- 24168 1
- 24214 1
- 24747 1
- 24826 1
- 24896 1
- 24966 1
- 25132 1
- 25192 1
- 25237 1
- 25291 1
- 25387 1
- 25428 1
- 25455 1
- 25493 1
- 25592 1
- 25644 1
- 25678 1
- 25713 1
- 25846 1
- 25885 1
- 25920 1
- 25950 1
- 26074 1
- 26096 1
- 26122 1
- 26236 1
- 26262 1
- 26297 1
- 26324 1
- 26406 1
- 26439 1
- 26473 1
- 26499 1
- 26603 1
- 26670 1
- 26822 1
- 26836 1
- 27090 1
- 27121 1
- 27183 1
- 27196 1
- 27224 1
- 27244 1
- 27292 1
- 27320 1
- 27333 1
- 27424 1
- 27486 1
- 27547 1
- 27563 1
- 27581 1
- 27605 1
- 27611 1
- 27617 1
- 27632 1
- 27661 1
- 27682 1
- 27697 1
- 27708 1
- 32779 1
- 32821 1
- 33139 1
- 33388 1
- 34242 1
- 34450 1
- 34951 1
- 35356 1
- 36450 1
- 36962 1
- 37205 1
- 38015 1
- 38342 1
- 38542 1
- 38990 1
- 39502 1
- 39635 1
- 39817 1
- 39918 1
- 40317 1
- 40453 1
- 40566 1
- 40670 1
- 41044 1
- 41149 1
- 41228 1
- 41306 1
- 41487 1
- 41558 1
- 41616 1
- 41657 1
- 41849 1
- 41883 1
- 41948 1
- 41989 1
- 42153 1
- 42173 1
- 42203 1
- 42265 1
- 42396 1
- 42420 1
- 42432 1
- 42452 1
- 42799 1
- 42822 1
- 42978 1
- 43073 1
- 43126 1
- 43168 1
- 43180 1
- 43198 1
- 43215 1
- 43238 1
- 43273 1
- 43320 1
- 43459 1
- 43477 1
- 43499 1
- 43518 1
- 43552 1
- 43596 1
- 43630 1
- 43685 1
- 43709 1
- 43729 1
- 43786 1
- 43826 1
- 43867 1
- 44237 1
- 44324 1
- 44473 1
- 45709 1
- 45947 1
- 46210 1
- 46465 1
- 46613 1
- 46919 1
- 47226 1
- 47270 1
- 47692 1
- 47809 1
- 48062 1
- 48484 1
- 48506 1
- 48838 1
- 49233 1
- 49301 1
- 49577 1
- 49847 1
- 50139 1
- 50882 1
- 51387 1
- 51633 1
- 51985 1
- 52156 1
- 52416 1
- 52638 1
- 52958 1
- 53229 1
- 53423 1
- 53647 1
- 53771 1
- 54031 1
- 54216 1
- 54331 1
- 54400 1
- 54452 1
- 54514 1
- 54595 1
- 54650 1
- 54732 1
- 54785 1
- 54838 1
- 54869 1
- 55393 1
- 55466 1
- 55554 1
- 55698 1
- 55820 1
- 55831 1
- 55843 1
- 55942 1
- 56038 1
- 56081 1
- 56153 1
- 56253 1
- 56261 1
- 56267 1
- 56314 1
- 56409 1
- 56462 1
- 56523 1
- 56572 1
- 56576 1
- 56589 1
- 56631 1
- 56677 1
- 56731 1
- 56795 1
- 56837 1
- 56843 1
- 56845 1
- 56915 1
- 56956 1
- 56991 1
- 57023 1
- 57064 1
- 57071 1
- 57076 1
- 57142 1
- 57194 1
- 57270 1
- 57344 1
- 57404 1
- 57407 1
- 57409 1
- 57486 1
- 57540 1
- 57604 1
- 57692 1
- 57739 1
- 57797 1
- 57871 1
- 57948 1
- 58018 1
- 58110 1
- 58122 1
- 58128 1
- 58191 1
- 58255 1
- 58438 1
- 58532 1
- 58619 1
- 58706 1
- 59234 1
- 59316 1
- 59321 1
- 59325 1
- 59401 1
- 59485 1
- 59555 1
- 59638 1
- 59715 1
- 59731 1
- 59742 1
- 59780 1
- 59908 1
- 60023 1
- 60104 1
- 60178 1
- 60189 1
- 60196 1
- 60250 1
- 60280 1
- 60372 1
- 60473 1
state 1
- Texas · 787 ✖
fips 1
- 48309 787
county 1
- McLennan · 787 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502367 | 2502367 | 2022-05-13 | McLennan | Texas | 48309 | 60473 | 902 |
2499109 | 2499109 | 2022-05-12 | McLennan | Texas | 48309 | 60372 | 902 |
2495851 | 2495851 | 2022-05-11 | McLennan | Texas | 48309 | 60280 | 902 |
2492593 | 2492593 | 2022-05-10 | McLennan | Texas | 48309 | 60250 | 902 |
2489335 | 2489335 | 2022-05-09 | McLennan | Texas | 48309 | 60196 | 902 |
2486078 | 2486078 | 2022-05-08 | McLennan | Texas | 48309 | 60189 | 902 |
2482820 | 2482820 | 2022-05-07 | McLennan | Texas | 48309 | 60178 | 902 |
2479562 | 2479562 | 2022-05-06 | McLennan | Texas | 48309 | 60104 | 902 |
2476304 | 2476304 | 2022-05-05 | McLennan | Texas | 48309 | 60023 | 902 |
2473047 | 2473047 | 2022-05-04 | McLennan | Texas | 48309 | 59908 | 902 |
2469791 | 2469791 | 2022-05-03 | McLennan | Texas | 48309 | 59780 | 902 |
2466535 | 2466535 | 2022-05-02 | McLennan | Texas | 48309 | 59742 | 902 |
2463280 | 2463280 | 2022-05-01 | McLennan | Texas | 48309 | 59731 | 902 |
2460024 | 2460024 | 2022-04-30 | McLennan | Texas | 48309 | 59715 | 902 |
2456768 | 2456768 | 2022-04-29 | McLennan | Texas | 48309 | 59638 | 902 |
2453512 | 2453512 | 2022-04-28 | McLennan | Texas | 48309 | 59555 | 901 |
2450256 | 2450256 | 2022-04-27 | McLennan | Texas | 48309 | 59485 | 901 |
2446999 | 2446999 | 2022-04-26 | McLennan | Texas | 48309 | 59401 | 901 |
2443744 | 2443744 | 2022-04-25 | McLennan | Texas | 48309 | 59325 | 901 |
2440488 | 2440488 | 2022-04-24 | McLennan | Texas | 48309 | 59321 | 901 |
2437232 | 2437232 | 2022-04-23 | McLennan | Texas | 48309 | 59316 | 900 |
2433976 | 2433976 | 2022-04-22 | McLennan | Texas | 48309 | 59234 | 899 |
2430720 | 2430720 | 2022-04-21 | McLennan | Texas | 48309 | 58706 | 899 |
2427464 | 2427464 | 2022-04-20 | McLennan | Texas | 48309 | 58619 | 899 |
2424208 | 2424208 | 2022-04-19 | McLennan | Texas | 48309 | 58532 | 899 |
2420952 | 2420952 | 2022-04-18 | McLennan | Texas | 48309 | 58438 | 899 |
2417696 | 2417696 | 2022-04-17 | McLennan | Texas | 48309 | 58328 | 899 |
2414440 | 2414440 | 2022-04-16 | McLennan | Texas | 48309 | 58328 | 899 |
2411184 | 2411184 | 2022-04-15 | McLennan | Texas | 48309 | 58328 | 899 |
2407928 | 2407928 | 2022-04-14 | McLennan | Texas | 48309 | 58328 | 899 |
2404672 | 2404672 | 2022-04-13 | McLennan | Texas | 48309 | 58255 | 899 |
2401417 | 2401417 | 2022-04-12 | McLennan | Texas | 48309 | 58191 | 899 |
2398162 | 2398162 | 2022-04-11 | McLennan | Texas | 48309 | 58128 | 899 |
2394907 | 2394907 | 2022-04-10 | McLennan | Texas | 48309 | 58122 | 899 |
2391651 | 2391651 | 2022-04-09 | McLennan | Texas | 48309 | 58110 | 899 |
2388395 | 2388395 | 2022-04-08 | McLennan | Texas | 48309 | 58018 | 899 |
2385140 | 2385140 | 2022-04-07 | McLennan | Texas | 48309 | 57948 | 899 |
2381885 | 2381885 | 2022-04-06 | McLennan | Texas | 48309 | 57871 | 899 |
2378630 | 2378630 | 2022-04-05 | McLennan | Texas | 48309 | 57797 | 899 |
2375376 | 2375376 | 2022-04-04 | McLennan | Texas | 48309 | 57739 | 899 |
2372124 | 2372124 | 2022-04-03 | McLennan | Texas | 48309 | 57738 | 899 |
2368871 | 2368871 | 2022-04-02 | McLennan | Texas | 48309 | 57738 | 898 |
2365618 | 2365618 | 2022-04-01 | McLennan | Texas | 48309 | 57692 | 898 |
2362365 | 2362365 | 2022-03-31 | McLennan | Texas | 48309 | 57604 | 898 |
2359111 | 2359111 | 2022-03-30 | McLennan | Texas | 48309 | 57540 | 897 |
2355857 | 2355857 | 2022-03-29 | McLennan | Texas | 48309 | 57486 | 897 |
2352604 | 2352604 | 2022-03-28 | McLennan | Texas | 48309 | 57409 | 897 |
2349352 | 2349352 | 2022-03-27 | McLennan | Texas | 48309 | 57407 | 897 |
2346099 | 2346099 | 2022-03-26 | McLennan | Texas | 48309 | 57404 | 897 |
2342846 | 2342846 | 2022-03-25 | McLennan | Texas | 48309 | 57344 | 897 |
2339593 | 2339593 | 2022-03-24 | McLennan | Texas | 48309 | 57270 | 896 |
2336339 | 2336339 | 2022-03-23 | McLennan | Texas | 48309 | 57194 | 896 |
2333085 | 2333085 | 2022-03-22 | McLennan | Texas | 48309 | 57142 | 896 |
2329832 | 2329832 | 2022-03-21 | McLennan | Texas | 48309 | 57076 | 895 |
2326580 | 2326580 | 2022-03-20 | McLennan | Texas | 48309 | 57071 | 895 |
2323327 | 2323327 | 2022-03-19 | McLennan | Texas | 48309 | 57064 | 895 |
2320073 | 2320073 | 2022-03-18 | McLennan | Texas | 48309 | 57023 | 895 |
2316819 | 2316819 | 2022-03-17 | McLennan | Texas | 48309 | 56991 | 894 |
2313566 | 2313566 | 2022-03-16 | McLennan | Texas | 48309 | 56956 | 892 |
2310313 | 2310313 | 2022-03-15 | McLennan | Texas | 48309 | 56915 | 892 |
2307060 | 2307060 | 2022-03-14 | McLennan | Texas | 48309 | 56845 | 892 |
2303809 | 2303809 | 2022-03-13 | McLennan | Texas | 48309 | 56843 | 892 |
2300557 | 2300557 | 2022-03-12 | McLennan | Texas | 48309 | 56837 | 892 |
2297305 | 2297305 | 2022-03-11 | McLennan | Texas | 48309 | 56795 | 891 |
2294053 | 2294053 | 2022-03-10 | McLennan | Texas | 48309 | 56731 | 891 |
2290801 | 2290801 | 2022-03-09 | McLennan | Texas | 48309 | 56677 | 891 |
2287549 | 2287549 | 2022-03-08 | McLennan | Texas | 48309 | 56631 | 891 |
2284297 | 2284297 | 2022-03-07 | McLennan | Texas | 48309 | 56589 | 891 |
2281045 | 2281045 | 2022-03-06 | McLennan | Texas | 48309 | 56576 | 891 |
2277792 | 2277792 | 2022-03-05 | McLennan | Texas | 48309 | 56572 | 891 |
2274539 | 2274539 | 2022-03-04 | McLennan | Texas | 48309 | 56523 | 889 |
2271286 | 2271286 | 2022-03-03 | McLennan | Texas | 48309 | 56462 | 886 |
2268034 | 2268034 | 2022-03-02 | McLennan | Texas | 48309 | 56409 | 886 |
2264781 | 2264781 | 2022-03-01 | McLennan | Texas | 48309 | 56314 | 878 |
2261531 | 2261531 | 2022-02-28 | McLennan | Texas | 48309 | 56267 | 877 |
2258280 | 2258280 | 2022-02-27 | McLennan | Texas | 48309 | 56261 | 877 |
2255029 | 2255029 | 2022-02-26 | McLennan | Texas | 48309 | 56253 | 876 |
2251778 | 2251778 | 2022-02-25 | McLennan | Texas | 48309 | 56153 | 874 |
2248527 | 2248527 | 2022-02-24 | McLennan | Texas | 48309 | 56081 | 874 |
2245276 | 2245276 | 2022-02-23 | McLennan | Texas | 48309 | 56038 | 867 |
2242025 | 2242025 | 2022-02-22 | McLennan | Texas | 48309 | 55942 | 857 |
2238774 | 2238774 | 2022-02-21 | McLennan | Texas | 48309 | 55843 | 856 |
2235523 | 2235523 | 2022-02-20 | McLennan | Texas | 48309 | 55831 | 856 |
2232272 | 2232272 | 2022-02-19 | McLennan | Texas | 48309 | 55820 | 852 |
2229021 | 2229021 | 2022-02-18 | McLennan | Texas | 48309 | 55698 | 851 |
2225770 | 2225770 | 2022-02-17 | McLennan | Texas | 48309 | 55554 | 850 |
2222519 | 2222519 | 2022-02-16 | McLennan | Texas | 48309 | 55466 | 847 |
2219268 | 2219268 | 2022-02-15 | McLennan | Texas | 48309 | 55393 | 840 |
2216017 | 2216017 | 2022-02-14 | McLennan | Texas | 48309 | 54869 | 838 |
2212766 | 2212766 | 2022-02-13 | McLennan | Texas | 48309 | 54838 | 838 |
2209513 | 2209513 | 2022-02-12 | McLennan | Texas | 48309 | 54785 | 837 |
2206260 | 2206260 | 2022-02-11 | McLennan | Texas | 48309 | 54732 | 836 |
2203007 | 2203007 | 2022-02-10 | McLennan | Texas | 48309 | 54650 | 833 |
2199753 | 2199753 | 2022-02-09 | McLennan | Texas | 48309 | 54595 | 832 |
2196499 | 2196499 | 2022-02-08 | McLennan | Texas | 48309 | 54514 | 827 |
2193245 | 2193245 | 2022-02-07 | McLennan | Texas | 48309 | 54452 | 822 |
2189991 | 2189991 | 2022-02-06 | McLennan | Texas | 48309 | 54400 | 822 |
2186738 | 2186738 | 2022-02-05 | McLennan | Texas | 48309 | 54331 | 822 |
2183486 | 2183486 | 2022-02-04 | McLennan | Texas | 48309 | 54216 | 821 |
2180234 | 2180234 | 2022-02-03 | McLennan | Texas | 48309 | 54031 | 818 |
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);