ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,491 rows where county = "Texas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19075 | 19075 | 2020-03-29 | Texas | Oklahoma | 40139 | 1 | 0 |
21125 | 21125 | 2020-03-30 | Texas | Oklahoma | 40139 | 1 | 0 |
23258 | 23258 | 2020-03-31 | Texas | Oklahoma | 40139 | 1 | 0 |
25455 | 25455 | 2020-04-01 | Texas | Oklahoma | 40139 | 1 | 0 |
27727 | 27727 | 2020-04-02 | Texas | Oklahoma | 40139 | 1 | 0 |
30059 | 30059 | 2020-04-03 | Texas | Oklahoma | 40139 | 1 | 0 |
32448 | 32448 | 2020-04-04 | Texas | Oklahoma | 40139 | 1 | 0 |
34882 | 34882 | 2020-04-05 | Texas | Oklahoma | 40139 | 2 | 0 |
37356 | 37356 | 2020-04-06 | Texas | Oklahoma | 40139 | 3 | 0 |
39877 | 39877 | 2020-04-07 | Texas | Oklahoma | 40139 | 3 | 0 |
42437 | 42437 | 2020-04-08 | Texas | Oklahoma | 40139 | 3 | 0 |
45023 | 45023 | 2020-04-09 | Texas | Oklahoma | 40139 | 3 | 0 |
47640 | 47640 | 2020-04-10 | Texas | Oklahoma | 40139 | 3 | 0 |
50296 | 50296 | 2020-04-11 | Texas | Oklahoma | 40139 | 3 | 0 |
52969 | 52969 | 2020-04-12 | Texas | Oklahoma | 40139 | 3 | 0 |
55654 | 55654 | 2020-04-13 | Texas | Oklahoma | 40139 | 5 | 0 |
58356 | 58356 | 2020-04-14 | Texas | Oklahoma | 40139 | 6 | 1 |
61071 | 61071 | 2020-04-15 | Texas | Oklahoma | 40139 | 9 | 1 |
63797 | 63797 | 2020-04-16 | Texas | Oklahoma | 40139 | 9 | 1 |
66542 | 66542 | 2020-04-17 | Texas | Oklahoma | 40139 | 9 | 1 |
69300 | 69300 | 2020-04-18 | Texas | Oklahoma | 40139 | 13 | 1 |
72067 | 72067 | 2020-04-19 | Texas | Oklahoma | 40139 | 13 | 1 |
74842 | 74842 | 2020-04-20 | Texas | Oklahoma | 40139 | 20 | 1 |
77624 | 77624 | 2020-04-21 | Texas | Oklahoma | 40139 | 32 | 1 |
80414 | 80414 | 2020-04-22 | Texas | Oklahoma | 40139 | 34 | 1 |
83213 | 83213 | 2020-04-23 | Texas | Oklahoma | 40139 | 46 | 1 |
86017 | 86017 | 2020-04-24 | Texas | Oklahoma | 40139 | 59 | 1 |
88831 | 88831 | 2020-04-25 | Texas | Oklahoma | 40139 | 68 | 1 |
91647 | 91647 | 2020-04-26 | Texas | Oklahoma | 40139 | 73 | 1 |
94474 | 94474 | 2020-04-27 | Texas | Oklahoma | 40139 | 85 | 1 |
97312 | 97312 | 2020-04-28 | Texas | Oklahoma | 40139 | 107 | 1 |
100161 | 100161 | 2020-04-29 | Texas | Oklahoma | 40139 | 119 | 1 |
103014 | 103014 | 2020-04-30 | Texas | Oklahoma | 40139 | 131 | 1 |
105877 | 105877 | 2020-05-01 | Texas | Oklahoma | 40139 | 138 | 1 |
108744 | 108744 | 2020-05-02 | Texas | Oklahoma | 40139 | 172 | 2 |
111618 | 111618 | 2020-05-03 | Texas | Oklahoma | 40139 | 201 | 2 |
114500 | 114500 | 2020-05-04 | Texas | Oklahoma | 40139 | 236 | 2 |
117381 | 117381 | 2020-05-05 | Texas | Oklahoma | 40139 | 252 | 3 |
120342 | 120342 | 2020-05-06 | Texas | Oklahoma | 40139 | 274 | 3 |
123319 | 123319 | 2020-05-07 | Texas | Oklahoma | 40139 | 308 | 3 |
126302 | 126302 | 2020-05-08 | Texas | Oklahoma | 40139 | 343 | 3 |
129291 | 129291 | 2020-05-09 | Texas | Oklahoma | 40139 | 345 | 3 |
132280 | 132280 | 2020-05-10 | Texas | Oklahoma | 40139 | 403 | 3 |
135271 | 135271 | 2020-05-11 | Texas | Oklahoma | 40139 | 404 | 4 |
138261 | 138261 | 2020-05-12 | Texas | Oklahoma | 40139 | 424 | 4 |
141257 | 141257 | 2020-05-13 | Texas | Oklahoma | 40139 | 474 | 4 |
144252 | 144252 | 2020-05-14 | Texas | Oklahoma | 40139 | 541 | 4 |
147253 | 147253 | 2020-05-15 | Texas | Oklahoma | 40139 | 606 | 4 |
150260 | 150260 | 2020-05-16 | Texas | Oklahoma | 40139 | 658 | 4 |
153271 | 153271 | 2020-05-17 | Texas | Oklahoma | 40139 | 696 | 4 |
156288 | 156288 | 2020-05-18 | Texas | Oklahoma | 40139 | 752 | 4 |
159309 | 159309 | 2020-05-19 | Texas | Oklahoma | 40139 | 784 | 4 |
162336 | 162336 | 2020-05-20 | Texas | Oklahoma | 40139 | 791 | 4 |
165365 | 165365 | 2020-05-21 | Texas | Oklahoma | 40139 | 820 | 4 |
168401 | 168401 | 2020-05-22 | Texas | Oklahoma | 40139 | 851 | 5 |
171440 | 171440 | 2020-05-23 | Texas | Oklahoma | 40139 | 855 | 5 |
174482 | 174482 | 2020-05-24 | Texas | Oklahoma | 40139 | 881 | 5 |
177526 | 177526 | 2020-05-25 | Texas | Oklahoma | 40139 | 886 | 5 |
180569 | 180569 | 2020-05-26 | Texas | Oklahoma | 40139 | 890 | 5 |
183618 | 183618 | 2020-05-27 | Texas | Oklahoma | 40139 | 902 | 5 |
186675 | 186675 | 2020-05-28 | Texas | Oklahoma | 40139 | 904 | 5 |
189193 | 189193 | 2020-05-29 | Texas | Missouri | 29215 | 1 | 0 |
189736 | 189736 | 2020-05-29 | Texas | Oklahoma | 40139 | 908 | 5 |
192257 | 192257 | 2020-05-30 | Texas | Missouri | 29215 | 1 | 0 |
192801 | 192801 | 2020-05-30 | Texas | Oklahoma | 40139 | 917 | 5 |
195327 | 195327 | 2020-05-31 | Texas | Missouri | 29215 | 1 | 0 |
195870 | 195870 | 2020-05-31 | Texas | Oklahoma | 40139 | 925 | 5 |
198398 | 198398 | 2020-06-01 | Texas | Missouri | 29215 | 1 | 0 |
198943 | 198943 | 2020-06-01 | Texas | Oklahoma | 40139 | 926 | 5 |
201471 | 201471 | 2020-06-02 | Texas | Missouri | 29215 | 1 | 0 |
202018 | 202018 | 2020-06-02 | Texas | Oklahoma | 40139 | 934 | 5 |
204548 | 204548 | 2020-06-03 | Texas | Missouri | 29215 | 1 | 0 |
205095 | 205095 | 2020-06-03 | Texas | Oklahoma | 40139 | 939 | 6 |
207629 | 207629 | 2020-06-04 | Texas | Missouri | 29215 | 1 | 0 |
208176 | 208176 | 2020-06-04 | Texas | Oklahoma | 40139 | 944 | 6 |
210710 | 210710 | 2020-06-05 | Texas | Missouri | 29215 | 1 | 0 |
211258 | 211258 | 2020-06-05 | Texas | Oklahoma | 40139 | 944 | 6 |
213794 | 213794 | 2020-06-06 | Texas | Missouri | 29215 | 1 | 0 |
214344 | 214344 | 2020-06-06 | Texas | Oklahoma | 40139 | 944 | 6 |
216883 | 216883 | 2020-06-07 | Texas | Missouri | 29215 | 1 | 0 |
217434 | 217434 | 2020-06-07 | Texas | Oklahoma | 40139 | 947 | 6 |
219975 | 219975 | 2020-06-08 | Texas | Missouri | 29215 | 1 | 0 |
220526 | 220526 | 2020-06-08 | Texas | Oklahoma | 40139 | 947 | 6 |
223070 | 223070 | 2020-06-09 | Texas | Missouri | 29215 | 1 | 0 |
223621 | 223621 | 2020-06-09 | Texas | Oklahoma | 40139 | 954 | 6 |
226169 | 226169 | 2020-06-10 | Texas | Missouri | 29215 | 1 | 0 |
226721 | 226721 | 2020-06-10 | Texas | Oklahoma | 40139 | 955 | 6 |
229272 | 229272 | 2020-06-11 | Texas | Missouri | 29215 | 1 | 0 |
229825 | 229825 | 2020-06-11 | Texas | Oklahoma | 40139 | 956 | 6 |
232376 | 232376 | 2020-06-12 | Texas | Missouri | 29215 | 1 | 0 |
232930 | 232930 | 2020-06-12 | Texas | Oklahoma | 40139 | 963 | 6 |
235482 | 235482 | 2020-06-13 | Texas | Missouri | 29215 | 1 | 0 |
236035 | 236035 | 2020-06-13 | Texas | Oklahoma | 40139 | 968 | 6 |
238589 | 238589 | 2020-06-14 | Texas | Missouri | 29215 | 1 | 0 |
239143 | 239143 | 2020-06-14 | Texas | Oklahoma | 40139 | 975 | 6 |
241699 | 241699 | 2020-06-15 | Texas | Missouri | 29215 | 1 | 0 |
242252 | 242252 | 2020-06-15 | Texas | Oklahoma | 40139 | 975 | 6 |
244810 | 244810 | 2020-06-16 | Texas | Missouri | 29215 | 1 | 0 |
245364 | 245364 | 2020-06-16 | Texas | Oklahoma | 40139 | 975 | 6 |
247923 | 247923 | 2020-06-17 | Texas | Missouri | 29215 | 1 | 0 |
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);