ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Tarrant" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324671 | 324671 | 2020-07-11 | Tarrant | Texas | 48439 | 17757 | 268 |
321490 | 321490 | 2020-07-10 | Tarrant | Texas | 48439 | 17334 | 262 |
318311 | 318311 | 2020-07-09 | Tarrant | Texas | 48439 | 16700 | 259 |
315138 | 315138 | 2020-07-08 | Tarrant | Texas | 48439 | 16180 | 254 |
311964 | 311964 | 2020-07-07 | Tarrant | Texas | 48439 | 15585 | 248 |
308795 | 308795 | 2020-07-06 | Tarrant | Texas | 48439 | 14828 | 238 |
305627 | 305627 | 2020-07-05 | Tarrant | Texas | 48439 | 14008 | 236 |
302463 | 302463 | 2020-07-04 | Tarrant | Texas | 48439 | 13423 | 233 |
299299 | 299299 | 2020-07-03 | Tarrant | Texas | 48439 | 13423 | 233 |
296138 | 296138 | 2020-07-02 | Tarrant | Texas | 48439 | 13423 | 233 |
292983 | 292983 | 2020-07-01 | Tarrant | Texas | 48439 | 12950 | 231 |
289830 | 289830 | 2020-06-30 | Tarrant | Texas | 48439 | 12344 | 228 |
286680 | 286680 | 2020-06-29 | Tarrant | Texas | 48439 | 11739 | 225 |
283534 | 283534 | 2020-06-28 | Tarrant | Texas | 48439 | 11476 | 225 |
280388 | 280388 | 2020-06-27 | Tarrant | Texas | 48439 | 11083 | 224 |
277240 | 277240 | 2020-06-26 | Tarrant | Texas | 48439 | 10706 | 222 |
274092 | 274092 | 2020-06-25 | Tarrant | Texas | 48439 | 10363 | 218 |
270952 | 270952 | 2020-06-24 | Tarrant | Texas | 48439 | 9846 | 215 |
267818 | 267818 | 2020-06-23 | Tarrant | Texas | 48439 | 9386 | 211 |
264690 | 264690 | 2020-06-22 | Tarrant | Texas | 48439 | 9126 | 210 |
261561 | 261561 | 2020-06-21 | Tarrant | Texas | 48439 | 8955 | 208 |
258434 | 258434 | 2020-06-20 | Tarrant | Texas | 48439 | 8511 | 208 |
255307 | 255307 | 2020-06-19 | Tarrant | Texas | 48439 | 8331 | 207 |
252191 | 252191 | 2020-06-18 | Tarrant | Texas | 48439 | 8099 | 205 |
249076 | 249076 | 2020-06-17 | Tarrant | Texas | 48439 | 7822 | 199 |
245963 | 245963 | 2020-06-16 | Tarrant | Texas | 48439 | 7642 | 198 |
242851 | 242851 | 2020-06-15 | Tarrant | Texas | 48439 | 7498 | 197 |
239741 | 239741 | 2020-06-14 | Tarrant | Texas | 48439 | 7334 | 197 |
236633 | 236633 | 2020-06-13 | Tarrant | Texas | 48439 | 7253 | 194 |
233526 | 233526 | 2020-06-12 | Tarrant | Texas | 48439 | 7120 | 191 |
230422 | 230422 | 2020-06-11 | Tarrant | Texas | 48439 | 6824 | 190 |
227318 | 227318 | 2020-06-10 | Tarrant | Texas | 48439 | 6599 | 189 |
224218 | 224218 | 2020-06-09 | Tarrant | Texas | 48439 | 6433 | 184 |
221122 | 221122 | 2020-06-08 | Tarrant | Texas | 48439 | 6369 | 178 |
218030 | 218030 | 2020-06-07 | Tarrant | Texas | 48439 | 6150 | 178 |
214940 | 214940 | 2020-06-06 | Tarrant | Texas | 48439 | 6073 | 176 |
211853 | 211853 | 2020-06-05 | Tarrant | Texas | 48439 | 5985 | 174 |
208768 | 208768 | 2020-06-04 | Tarrant | Texas | 48439 | 5863 | 173 |
205686 | 205686 | 2020-06-03 | Tarrant | Texas | 48439 | 5761 | 168 |
202607 | 202607 | 2020-06-02 | Tarrant | Texas | 48439 | 5623 | 167 |
199531 | 199531 | 2020-06-01 | Tarrant | Texas | 48439 | 5534 | 165 |
196458 | 196458 | 2020-05-31 | Tarrant | Texas | 48439 | 5513 | 165 |
193388 | 193388 | 2020-05-30 | Tarrant | Texas | 48439 | 5463 | 165 |
190322 | 190322 | 2020-05-29 | Tarrant | Texas | 48439 | 5379 | 160 |
187258 | 187258 | 2020-05-28 | Tarrant | Texas | 48439 | 5294 | 158 |
184201 | 184201 | 2020-05-27 | Tarrant | Texas | 48439 | 5190 | 155 |
181150 | 181150 | 2020-05-26 | Tarrant | Texas | 48439 | 5039 | 144 |
178106 | 178106 | 2020-05-25 | Tarrant | Texas | 48439 | 4977 | 144 |
175061 | 175061 | 2020-05-24 | Tarrant | Texas | 48439 | 4977 | 144 |
172018 | 172018 | 2020-05-23 | Tarrant | Texas | 48439 | 4951 | 143 |
168978 | 168978 | 2020-05-22 | Tarrant | Texas | 48439 | 4899 | 141 |
165942 | 165942 | 2020-05-21 | Tarrant | Texas | 48439 | 4803 | 139 |
162913 | 162913 | 2020-05-20 | Tarrant | Texas | 48439 | 4711 | 132 |
159885 | 159885 | 2020-05-19 | Tarrant | Texas | 48439 | 4643 | 130 |
156861 | 156861 | 2020-05-18 | Tarrant | Texas | 48439 | 4559 | 123 |
153844 | 153844 | 2020-05-17 | Tarrant | Texas | 48439 | 4447 | 123 |
150833 | 150833 | 2020-05-16 | Tarrant | Texas | 48439 | 4350 | 121 |
147825 | 147825 | 2020-05-15 | Tarrant | Texas | 48439 | 4266 | 120 |
144821 | 144821 | 2020-05-14 | Tarrant | Texas | 48439 | 4211 | 117 |
141824 | 141824 | 2020-05-13 | Tarrant | Texas | 48439 | 4076 | 114 |
138828 | 138828 | 2020-05-12 | Tarrant | Texas | 48439 | 3810 | 109 |
135838 | 135838 | 2020-05-11 | Tarrant | Texas | 48439 | 3745 | 104 |
132847 | 132847 | 2020-05-10 | Tarrant | Texas | 48439 | 3695 | 103 |
129857 | 129857 | 2020-05-09 | Tarrant | Texas | 48439 | 3210 | 101 |
126868 | 126868 | 2020-05-08 | Tarrant | Texas | 48439 | 3127 | 95 |
123883 | 123883 | 2020-05-07 | Tarrant | Texas | 48439 | 2956 | 90 |
120903 | 120903 | 2020-05-06 | Tarrant | Texas | 48439 | 2813 | 88 |
117939 | 117939 | 2020-05-05 | Tarrant | Texas | 48439 | 2686 | 83 |
114980 | 114980 | 2020-05-04 | Tarrant | Texas | 48439 | 2624 | 77 |
112097 | 112097 | 2020-05-03 | Tarrant | Texas | 48439 | 2584 | 75 |
109223 | 109223 | 2020-05-02 | Tarrant | Texas | 48439 | 2503 | 71 |
106354 | 106354 | 2020-05-01 | Tarrant | Texas | 48439 | 2388 | 69 |
103490 | 103490 | 2020-04-30 | Tarrant | Texas | 48439 | 2246 | 68 |
100635 | 100635 | 2020-04-29 | Tarrant | Texas | 48439 | 2149 | 61 |
97785 | 97785 | 2020-04-28 | Tarrant | Texas | 48439 | 2088 | 58 |
94943 | 94943 | 2020-04-27 | Tarrant | Texas | 48439 | 2019 | 53 |
92114 | 92114 | 2020-04-26 | Tarrant | Texas | 48439 | 1947 | 53 |
89297 | 89297 | 2020-04-25 | Tarrant | Texas | 48439 | 1836 | 52 |
86482 | 86482 | 2020-04-24 | Tarrant | Texas | 48439 | 1706 | 48 |
83675 | 83675 | 2020-04-23 | Tarrant | Texas | 48439 | 1559 | 45 |
80874 | 80874 | 2020-04-22 | Tarrant | Texas | 48439 | 1430 | 44 |
78083 | 78083 | 2020-04-21 | Tarrant | Texas | 48439 | 1333 | 42 |
75301 | 75301 | 2020-04-20 | Tarrant | Texas | 48439 | 1249 | 39 |
72525 | 72525 | 2020-04-19 | Tarrant | Texas | 48439 | 1242 | 39 |
69755 | 69755 | 2020-04-18 | Tarrant | Texas | 48439 | 1229 | 38 |
66995 | 66995 | 2020-04-17 | Tarrant | Texas | 48439 | 1175 | 35 |
64248 | 64248 | 2020-04-16 | Tarrant | Texas | 48439 | 990 | 34 |
61516 | 61516 | 2020-04-15 | Tarrant | Texas | 48439 | 990 | 30 |
58798 | 58798 | 2020-04-14 | Tarrant | Texas | 48439 | 929 | 29 |
56093 | 56093 | 2020-04-13 | Tarrant | Texas | 48439 | 876 | 25 |
53404 | 53404 | 2020-04-12 | Tarrant | Texas | 48439 | 806 | 25 |
50729 | 50729 | 2020-04-11 | Tarrant | Texas | 48439 | 705 | 21 |
48071 | 48071 | 2020-04-10 | Tarrant | Texas | 48439 | 705 | 21 |
45448 | 45448 | 2020-04-09 | Tarrant | Texas | 48439 | 637 | 20 |
42854 | 42854 | 2020-04-08 | Tarrant | Texas | 48439 | 588 | 19 |
40286 | 40286 | 2020-04-07 | Tarrant | Texas | 48439 | 452 | 18 |
37757 | 37757 | 2020-04-06 | Tarrant | Texas | 48439 | 452 | 13 |
35280 | 35280 | 2020-04-05 | Tarrant | Texas | 48439 | 404 | 11 |
32842 | 32842 | 2020-04-04 | Tarrant | Texas | 48439 | 383 | 9 |
30446 | 30446 | 2020-04-03 | Tarrant | Texas | 48439 | 383 | 7 |
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);