ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502329 | 2502329 | 2022-05-13 | Jefferson | Texas | 48245 | 49316 | 843 |
2499071 | 2499071 | 2022-05-12 | Jefferson | Texas | 48245 | 49162 | 842 |
2495813 | 2495813 | 2022-05-11 | Jefferson | Texas | 48245 | 49044 | 842 |
2492555 | 2492555 | 2022-05-10 | Jefferson | Texas | 48245 | 48936 | 842 |
2489297 | 2489297 | 2022-05-09 | Jefferson | Texas | 48245 | 48831 | 841 |
2486040 | 2486040 | 2022-05-08 | Jefferson | Texas | 48245 | 48825 | 841 |
2482782 | 2482782 | 2022-05-07 | Jefferson | Texas | 48245 | 48821 | 841 |
2479524 | 2479524 | 2022-05-06 | Jefferson | Texas | 48245 | 48799 | 841 |
2476266 | 2476266 | 2022-05-05 | Jefferson | Texas | 48245 | 48759 | 841 |
2473009 | 2473009 | 2022-05-04 | Jefferson | Texas | 48245 | 48629 | 841 |
2469753 | 2469753 | 2022-05-03 | Jefferson | Texas | 48245 | 48511 | 841 |
2466497 | 2466497 | 2022-05-02 | Jefferson | Texas | 48245 | 48414 | 841 |
2463242 | 2463242 | 2022-05-01 | Jefferson | Texas | 48245 | 48408 | 841 |
2459986 | 2459986 | 2022-04-30 | Jefferson | Texas | 48245 | 48403 | 841 |
2456730 | 2456730 | 2022-04-29 | Jefferson | Texas | 48245 | 48380 | 841 |
2453474 | 2453474 | 2022-04-28 | Jefferson | Texas | 48245 | 48311 | 841 |
2450218 | 2450218 | 2022-04-27 | Jefferson | Texas | 48245 | 48246 | 841 |
2446961 | 2446961 | 2022-04-26 | Jefferson | Texas | 48245 | 48162 | 841 |
2443706 | 2443706 | 2022-04-25 | Jefferson | Texas | 48245 | 48022 | 841 |
2440450 | 2440450 | 2022-04-24 | Jefferson | Texas | 48245 | 48020 | 841 |
2437194 | 2437194 | 2022-04-23 | Jefferson | Texas | 48245 | 48019 | 840 |
2433938 | 2433938 | 2022-04-22 | Jefferson | Texas | 48245 | 47909 | 840 |
2430682 | 2430682 | 2022-04-21 | Jefferson | Texas | 48245 | 47776 | 839 |
2427426 | 2427426 | 2022-04-20 | Jefferson | Texas | 48245 | 47652 | 838 |
2424170 | 2424170 | 2022-04-19 | Jefferson | Texas | 48245 | 47522 | 836 |
2420914 | 2420914 | 2022-04-18 | Jefferson | Texas | 48245 | 47307 | 836 |
2417658 | 2417658 | 2022-04-17 | Jefferson | Texas | 48245 | 47161 | 835 |
2414402 | 2414402 | 2022-04-16 | Jefferson | Texas | 48245 | 47161 | 835 |
2411146 | 2411146 | 2022-04-15 | Jefferson | Texas | 48245 | 47161 | 835 |
2407890 | 2407890 | 2022-04-14 | Jefferson | Texas | 48245 | 47161 | 835 |
2404634 | 2404634 | 2022-04-13 | Jefferson | Texas | 48245 | 47031 | 834 |
2401379 | 2401379 | 2022-04-12 | Jefferson | Texas | 48245 | 46959 | 834 |
2398124 | 2398124 | 2022-04-11 | Jefferson | Texas | 48245 | 46956 | 834 |
2394869 | 2394869 | 2022-04-10 | Jefferson | Texas | 48245 | 46955 | 834 |
2391613 | 2391613 | 2022-04-09 | Jefferson | Texas | 48245 | 46949 | 833 |
2388357 | 2388357 | 2022-04-08 | Jefferson | Texas | 48245 | 46877 | 832 |
2385102 | 2385102 | 2022-04-07 | Jefferson | Texas | 48245 | 46785 | 832 |
2381847 | 2381847 | 2022-04-06 | Jefferson | Texas | 48245 | 46725 | 831 |
2378592 | 2378592 | 2022-04-05 | Jefferson | Texas | 48245 | 46672 | 831 |
2375338 | 2375338 | 2022-04-04 | Jefferson | Texas | 48245 | 46626 | 831 |
2372086 | 2372086 | 2022-04-03 | Jefferson | Texas | 48245 | 46624 | 831 |
2368833 | 2368833 | 2022-04-02 | Jefferson | Texas | 48245 | 46617 | 831 |
2365580 | 2365580 | 2022-04-01 | Jefferson | Texas | 48245 | 46546 | 830 |
2362327 | 2362327 | 2022-03-31 | Jefferson | Texas | 48245 | 46493 | 828 |
2359073 | 2359073 | 2022-03-30 | Jefferson | Texas | 48245 | 46425 | 828 |
2355819 | 2355819 | 2022-03-29 | Jefferson | Texas | 48245 | 46345 | 827 |
2352566 | 2352566 | 2022-03-28 | Jefferson | Texas | 48245 | 46279 | 825 |
2349314 | 2349314 | 2022-03-27 | Jefferson | Texas | 48245 | 46277 | 825 |
2346061 | 2346061 | 2022-03-26 | Jefferson | Texas | 48245 | 46277 | 825 |
2342808 | 2342808 | 2022-03-25 | Jefferson | Texas | 48245 | 46210 | 825 |
2339555 | 2339555 | 2022-03-24 | Jefferson | Texas | 48245 | 46139 | 824 |
2336301 | 2336301 | 2022-03-23 | Jefferson | Texas | 48245 | 46051 | 824 |
2333047 | 2333047 | 2022-03-22 | Jefferson | Texas | 48245 | 45970 | 824 |
2329794 | 2329794 | 2022-03-21 | Jefferson | Texas | 48245 | 45891 | 824 |
2326542 | 2326542 | 2022-03-20 | Jefferson | Texas | 48245 | 45885 | 823 |
2323289 | 2323289 | 2022-03-19 | Jefferson | Texas | 48245 | 45878 | 823 |
2320035 | 2320035 | 2022-03-18 | Jefferson | Texas | 48245 | 45825 | 823 |
2316781 | 2316781 | 2022-03-17 | Jefferson | Texas | 48245 | 45753 | 822 |
2313528 | 2313528 | 2022-03-16 | Jefferson | Texas | 48245 | 45637 | 819 |
2310275 | 2310275 | 2022-03-15 | Jefferson | Texas | 48245 | 45354 | 817 |
2307022 | 2307022 | 2022-03-14 | Jefferson | Texas | 48245 | 45144 | 816 |
2303771 | 2303771 | 2022-03-13 | Jefferson | Texas | 48245 | 45136 | 816 |
2300519 | 2300519 | 2022-03-12 | Jefferson | Texas | 48245 | 45133 | 816 |
2297267 | 2297267 | 2022-03-11 | Jefferson | Texas | 48245 | 45005 | 816 |
2294015 | 2294015 | 2022-03-10 | Jefferson | Texas | 48245 | 44856 | 815 |
2290763 | 2290763 | 2022-03-09 | Jefferson | Texas | 48245 | 44724 | 813 |
2287511 | 2287511 | 2022-03-08 | Jefferson | Texas | 48245 | 44577 | 812 |
2284259 | 2284259 | 2022-03-07 | Jefferson | Texas | 48245 | 44491 | 812 |
2281007 | 2281007 | 2022-03-06 | Jefferson | Texas | 48245 | 44486 | 812 |
2277754 | 2277754 | 2022-03-05 | Jefferson | Texas | 48245 | 44483 | 810 |
2274501 | 2274501 | 2022-03-04 | Jefferson | Texas | 48245 | 44388 | 809 |
2271248 | 2271248 | 2022-03-03 | Jefferson | Texas | 48245 | 44216 | 808 |
2267996 | 2267996 | 2022-03-02 | Jefferson | Texas | 48245 | 44067 | 807 |
2264743 | 2264743 | 2022-03-01 | Jefferson | Texas | 48245 | 43908 | 806 |
2261493 | 2261493 | 2022-02-28 | Jefferson | Texas | 48245 | 43799 | 805 |
2258242 | 2258242 | 2022-02-27 | Jefferson | Texas | 48245 | 43781 | 805 |
2254991 | 2254991 | 2022-02-26 | Jefferson | Texas | 48245 | 43774 | 804 |
2251740 | 2251740 | 2022-02-25 | Jefferson | Texas | 48245 | 43663 | 802 |
2248489 | 2248489 | 2022-02-24 | Jefferson | Texas | 48245 | 43553 | 799 |
2245238 | 2245238 | 2022-02-23 | Jefferson | Texas | 48245 | 43445 | 797 |
2241987 | 2241987 | 2022-02-22 | Jefferson | Texas | 48245 | 43359 | 796 |
2238736 | 2238736 | 2022-02-21 | Jefferson | Texas | 48245 | 43230 | 796 |
2235485 | 2235485 | 2022-02-20 | Jefferson | Texas | 48245 | 43211 | 796 |
2232234 | 2232234 | 2022-02-19 | Jefferson | Texas | 48245 | 43200 | 795 |
2228983 | 2228983 | 2022-02-18 | Jefferson | Texas | 48245 | 43111 | 793 |
2225732 | 2225732 | 2022-02-17 | Jefferson | Texas | 48245 | 42928 | 790 |
2222481 | 2222481 | 2022-02-16 | Jefferson | Texas | 48245 | 42830 | 789 |
2219230 | 2219230 | 2022-02-15 | Jefferson | Texas | 48245 | 42729 | 786 |
2215979 | 2215979 | 2022-02-14 | Jefferson | Texas | 48245 | 42644 | 786 |
2212728 | 2212728 | 2022-02-13 | Jefferson | Texas | 48245 | 42596 | 785 |
2209475 | 2209475 | 2022-02-12 | Jefferson | Texas | 48245 | 42550 | 783 |
2206222 | 2206222 | 2022-02-11 | Jefferson | Texas | 48245 | 42441 | 781 |
2202969 | 2202969 | 2022-02-10 | Jefferson | Texas | 48245 | 42321 | 779 |
2199715 | 2199715 | 2022-02-09 | Jefferson | Texas | 48245 | 42150 | 777 |
2196461 | 2196461 | 2022-02-08 | Jefferson | Texas | 48245 | 41973 | 774 |
2193207 | 2193207 | 2022-02-07 | Jefferson | Texas | 48245 | 41806 | 771 |
2189953 | 2189953 | 2022-02-06 | Jefferson | Texas | 48245 | 41752 | 771 |
2186700 | 2186700 | 2022-02-05 | Jefferson | Texas | 48245 | 41647 | 771 |
2183448 | 2183448 | 2022-02-04 | Jefferson | Texas | 48245 | 41518 | 770 |
2180196 | 2180196 | 2022-02-03 | Jefferson | Texas | 48245 | 41336 | 769 |
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);