ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Harris" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324558 | 324558 | 2020-07-11 | Harris | Texas | 48201 | 43939 | 455 |
321377 | 321377 | 2020-07-10 | Harris | Texas | 48201 | 42000 | 439 |
318198 | 318198 | 2020-07-09 | Harris | Texas | 48201 | 40919 | 423 |
315025 | 315025 | 2020-07-08 | Harris | Texas | 48201 | 40012 | 411 |
311851 | 311851 | 2020-07-07 | Harris | Texas | 48201 | 39311 | 407 |
308682 | 308682 | 2020-07-06 | Harris | Texas | 48201 | 37776 | 401 |
305514 | 305514 | 2020-07-05 | Harris | Texas | 48201 | 36597 | 400 |
302350 | 302350 | 2020-07-04 | Harris | Texas | 48201 | 35913 | 400 |
299186 | 299186 | 2020-07-03 | Harris | Texas | 48201 | 35316 | 395 |
296026 | 296026 | 2020-07-02 | Harris | Texas | 48201 | 34108 | 387 |
292871 | 292871 | 2020-07-01 | Harris | Texas | 48201 | 32859 | 384 |
289718 | 289718 | 2020-06-30 | Harris | Texas | 48201 | 31422 | 378 |
286568 | 286568 | 2020-06-29 | Harris | Texas | 48201 | 30729 | 376 |
283422 | 283422 | 2020-06-28 | Harris | Texas | 48201 | 29276 | 371 |
280276 | 280276 | 2020-06-27 | Harris | Texas | 48201 | 29163 | 369 |
277128 | 277128 | 2020-06-26 | Harris | Texas | 48201 | 28255 | 361 |
273981 | 273981 | 2020-06-25 | Harris | Texas | 48201 | 27017 | 353 |
270841 | 270841 | 2020-06-24 | Harris | Texas | 48201 | 25786 | 346 |
267707 | 267707 | 2020-06-23 | Harris | Texas | 48201 | 24421 | 335 |
264579 | 264579 | 2020-06-22 | Harris | Texas | 48201 | 23047 | 332 |
261451 | 261451 | 2020-06-21 | Harris | Texas | 48201 | 21053 | 325 |
258324 | 258324 | 2020-06-20 | Harris | Texas | 48201 | 20874 | 322 |
255197 | 255197 | 2020-06-19 | Harris | Texas | 48201 | 19739 | 311 |
252082 | 252082 | 2020-06-18 | Harris | Texas | 48201 | 18552 | 305 |
248967 | 248967 | 2020-06-17 | Harris | Texas | 48201 | 18157 | 298 |
245854 | 245854 | 2020-06-16 | Harris | Texas | 48201 | 17707 | 289 |
242742 | 242742 | 2020-06-15 | Harris | Texas | 48201 | 17282 | 284 |
239632 | 239632 | 2020-06-14 | Harris | Texas | 48201 | 16778 | 275 |
236524 | 236524 | 2020-06-13 | Harris | Texas | 48201 | 16568 | 275 |
233418 | 233418 | 2020-06-12 | Harris | Texas | 48201 | 16188 | 271 |
230314 | 230314 | 2020-06-11 | Harris | Texas | 48201 | 15864 | 267 |
227210 | 227210 | 2020-06-10 | Harris | Texas | 48201 | 15552 | 267 |
224110 | 224110 | 2020-06-09 | Harris | Texas | 48201 | 15238 | 262 |
221015 | 221015 | 2020-06-08 | Harris | Texas | 48201 | 14918 | 262 |
217923 | 217923 | 2020-06-07 | Harris | Texas | 48201 | 14586 | 261 |
214833 | 214833 | 2020-06-06 | Harris | Texas | 48201 | 14423 | 259 |
211746 | 211746 | 2020-06-05 | Harris | Texas | 48201 | 13940 | 253 |
208662 | 208662 | 2020-06-04 | Harris | Texas | 48201 | 13603 | 247 |
205580 | 205580 | 2020-06-03 | Harris | Texas | 48201 | 13268 | 241 |
202501 | 202501 | 2020-06-02 | Harris | Texas | 48201 | 13027 | 236 |
199426 | 199426 | 2020-06-01 | Harris | Texas | 48201 | 12664 | 235 |
196353 | 196353 | 2020-05-31 | Harris | Texas | 48201 | 12276 | 232 |
193283 | 193283 | 2020-05-30 | Harris | Texas | 48201 | 12220 | 231 |
190218 | 190218 | 2020-05-29 | Harris | Texas | 48201 | 12009 | 228 |
187154 | 187154 | 2020-05-28 | Harris | Texas | 48201 | 11770 | 224 |
184097 | 184097 | 2020-05-27 | Harris | Texas | 48201 | 11542 | 223 |
181047 | 181047 | 2020-05-26 | Harris | Texas | 48201 | 11281 | 221 |
178004 | 178004 | 2020-05-25 | Harris | Texas | 48201 | 10921 | 220 |
174960 | 174960 | 2020-05-24 | Harris | Texas | 48201 | 10921 | 220 |
171917 | 171917 | 2020-05-23 | Harris | Texas | 48201 | 10770 | 219 |
168877 | 168877 | 2020-05-22 | Harris | Texas | 48201 | 10526 | 217 |
165841 | 165841 | 2020-05-21 | Harris | Texas | 48201 | 10283 | 216 |
162812 | 162812 | 2020-05-20 | Harris | Texas | 48201 | 10095 | 210 |
159784 | 159784 | 2020-05-19 | Harris | Texas | 48201 | 9859 | 207 |
156762 | 156762 | 2020-05-18 | Harris | Texas | 48201 | 9635 | 205 |
153745 | 153745 | 2020-05-17 | Harris | Texas | 48201 | 9465 | 204 |
150734 | 150734 | 2020-05-16 | Harris | Texas | 48201 | 9126 | 204 |
147726 | 147726 | 2020-05-15 | Harris | Texas | 48201 | 9050 | 193 |
144723 | 144723 | 2020-05-14 | Harris | Texas | 48201 | 8817 | 193 |
141726 | 141726 | 2020-05-13 | Harris | Texas | 48201 | 8621 | 188 |
138730 | 138730 | 2020-05-12 | Harris | Texas | 48201 | 8416 | 183 |
135740 | 135740 | 2020-05-11 | Harris | Texas | 48201 | 8176 | 179 |
132749 | 132749 | 2020-05-10 | Harris | Texas | 48201 | 7878 | 172 |
129759 | 129759 | 2020-05-09 | Harris | Texas | 48201 | 7803 | 168 |
126770 | 126770 | 2020-05-08 | Harris | Texas | 48201 | 7594 | 160 |
123787 | 123787 | 2020-05-07 | Harris | Texas | 48201 | 7377 | 154 |
120808 | 120808 | 2020-05-06 | Harris | Texas | 48201 | 7244 | 150 |
117844 | 117844 | 2020-05-05 | Harris | Texas | 48201 | 7128 | 144 |
114885 | 114885 | 2020-05-04 | Harris | Texas | 48201 | 6967 | 140 |
112003 | 112003 | 2020-05-03 | Harris | Texas | 48201 | 6838 | 133 |
109129 | 109129 | 2020-05-02 | Harris | Texas | 48201 | 6708 | 129 |
106260 | 106260 | 2020-05-01 | Harris | Texas | 48201 | 6551 | 122 |
103396 | 103396 | 2020-04-30 | Harris | Texas | 48201 | 6356 | 114 |
100541 | 100541 | 2020-04-29 | Harris | Texas | 48201 | 6161 | 109 |
97691 | 97691 | 2020-04-28 | Harris | Texas | 48201 | 5986 | 103 |
94851 | 94851 | 2020-04-27 | Harris | Texas | 48201 | 5827 | 98 |
92022 | 92022 | 2020-04-26 | Harris | Texas | 48201 | 5729 | 93 |
89205 | 89205 | 2020-04-25 | Harris | Texas | 48201 | 5628 | 89 |
86390 | 86390 | 2020-04-24 | Harris | Texas | 48201 | 5482 | 84 |
83585 | 83585 | 2020-04-23 | Harris | Texas | 48201 | 5330 | 82 |
80785 | 80785 | 2020-04-22 | Harris | Texas | 48201 | 5211 | 80 |
77994 | 77994 | 2020-04-21 | Harris | Texas | 48201 | 5143 | 79 |
75212 | 75212 | 2020-04-20 | Harris | Texas | 48201 | 4977 | 78 |
72437 | 72437 | 2020-04-19 | Harris | Texas | 48201 | 4823 | 75 |
69669 | 69669 | 2020-04-18 | Harris | Texas | 48201 | 4653 | 71 |
66909 | 66909 | 2020-04-17 | Harris | Texas | 48201 | 4460 | 67 |
64162 | 64162 | 2020-04-16 | Harris | Texas | 48201 | 4306 | 63 |
61435 | 61435 | 2020-04-15 | Harris | Texas | 48201 | 4097 | 58 |
58717 | 58717 | 2020-04-14 | Harris | Texas | 48201 | 3907 | 52 |
56012 | 56012 | 2020-04-13 | Harris | Texas | 48201 | 3747 | 46 |
53324 | 53324 | 2020-04-12 | Harris | Texas | 48201 | 3629 | 44 |
50649 | 50649 | 2020-04-11 | Harris | Texas | 48201 | 3561 | 41 |
47991 | 47991 | 2020-04-10 | Harris | Texas | 48201 | 3261 | 40 |
45371 | 45371 | 2020-04-09 | Harris | Texas | 48201 | 3047 | 34 |
42782 | 42782 | 2020-04-08 | Harris | Texas | 48201 | 2341 | 31 |
40215 | 40215 | 2020-04-07 | Harris | Texas | 48201 | 2146 | 23 |
37688 | 37688 | 2020-04-06 | Harris | Texas | 48201 | 1809 | 22 |
35212 | 35212 | 2020-04-05 | Harris | Texas | 48201 | 1395 | 20 |
32774 | 32774 | 2020-04-04 | Harris | Texas | 48201 | 1284 | 17 |
30381 | 30381 | 2020-04-03 | Harris | Texas | 48201 | 1036 | 12 |
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);