ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where fips = 48065 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324490 | 324490 | 2020-07-11 | Carson | Texas | 48065 | 10 | 0 |
321309 | 321309 | 2020-07-10 | Carson | Texas | 48065 | 10 | 0 |
318131 | 318131 | 2020-07-09 | Carson | Texas | 48065 | 10 | 0 |
314958 | 314958 | 2020-07-08 | Carson | Texas | 48065 | 7 | 0 |
311784 | 311784 | 2020-07-07 | Carson | Texas | 48065 | 7 | 0 |
308615 | 308615 | 2020-07-06 | Carson | Texas | 48065 | 7 | 0 |
305447 | 305447 | 2020-07-05 | Carson | Texas | 48065 | 7 | 0 |
302283 | 302283 | 2020-07-04 | Carson | Texas | 48065 | 7 | 0 |
299119 | 299119 | 2020-07-03 | Carson | Texas | 48065 | 7 | 0 |
295959 | 295959 | 2020-07-02 | Carson | Texas | 48065 | 7 | 0 |
292804 | 292804 | 2020-07-01 | Carson | Texas | 48065 | 6 | 0 |
289651 | 289651 | 2020-06-30 | Carson | Texas | 48065 | 6 | 0 |
286501 | 286501 | 2020-06-29 | Carson | Texas | 48065 | 6 | 0 |
283355 | 283355 | 2020-06-28 | Carson | Texas | 48065 | 6 | 0 |
280209 | 280209 | 2020-06-27 | Carson | Texas | 48065 | 6 | 0 |
277061 | 277061 | 2020-06-26 | Carson | Texas | 48065 | 6 | 0 |
273914 | 273914 | 2020-06-25 | Carson | Texas | 48065 | 6 | 0 |
270775 | 270775 | 2020-06-24 | Carson | Texas | 48065 | 6 | 0 |
267641 | 267641 | 2020-06-23 | Carson | Texas | 48065 | 6 | 0 |
264513 | 264513 | 2020-06-22 | Carson | Texas | 48065 | 6 | 0 |
261385 | 261385 | 2020-06-21 | Carson | Texas | 48065 | 6 | 0 |
258258 | 258258 | 2020-06-20 | Carson | Texas | 48065 | 6 | 0 |
255132 | 255132 | 2020-06-19 | Carson | Texas | 48065 | 6 | 0 |
252017 | 252017 | 2020-06-18 | Carson | Texas | 48065 | 6 | 0 |
248902 | 248902 | 2020-06-17 | Carson | Texas | 48065 | 6 | 0 |
245789 | 245789 | 2020-06-16 | Carson | Texas | 48065 | 6 | 0 |
242677 | 242677 | 2020-06-15 | Carson | Texas | 48065 | 6 | 0 |
239567 | 239567 | 2020-06-14 | Carson | Texas | 48065 | 6 | 0 |
236459 | 236459 | 2020-06-13 | Carson | Texas | 48065 | 6 | 0 |
233353 | 233353 | 2020-06-12 | Carson | Texas | 48065 | 6 | 0 |
230249 | 230249 | 2020-06-11 | Carson | Texas | 48065 | 6 | 0 |
227145 | 227145 | 2020-06-10 | Carson | Texas | 48065 | 6 | 0 |
224045 | 224045 | 2020-06-09 | Carson | Texas | 48065 | 6 | 0 |
220950 | 220950 | 2020-06-08 | Carson | Texas | 48065 | 6 | 0 |
217858 | 217858 | 2020-06-07 | Carson | Texas | 48065 | 6 | 0 |
214768 | 214768 | 2020-06-06 | Carson | Texas | 48065 | 6 | 0 |
211681 | 211681 | 2020-06-05 | Carson | Texas | 48065 | 6 | 0 |
208598 | 208598 | 2020-06-04 | Carson | Texas | 48065 | 6 | 0 |
205516 | 205516 | 2020-06-03 | Carson | Texas | 48065 | 6 | 0 |
202437 | 202437 | 2020-06-02 | Carson | Texas | 48065 | 6 | 0 |
199362 | 199362 | 2020-06-01 | Carson | Texas | 48065 | 6 | 0 |
196289 | 196289 | 2020-05-31 | Carson | Texas | 48065 | 6 | 0 |
193219 | 193219 | 2020-05-30 | Carson | Texas | 48065 | 6 | 0 |
190154 | 190154 | 2020-05-29 | Carson | Texas | 48065 | 6 | 0 |
187090 | 187090 | 2020-05-28 | Carson | Texas | 48065 | 6 | 0 |
184033 | 184033 | 2020-05-27 | Carson | Texas | 48065 | 6 | 0 |
180983 | 180983 | 2020-05-26 | Carson | Texas | 48065 | 6 | 0 |
177940 | 177940 | 2020-05-25 | Carson | Texas | 48065 | 6 | 0 |
174896 | 174896 | 2020-05-24 | Carson | Texas | 48065 | 6 | 0 |
171853 | 171853 | 2020-05-23 | Carson | Texas | 48065 | 6 | 0 |
168814 | 168814 | 2020-05-22 | Carson | Texas | 48065 | 6 | 0 |
165778 | 165778 | 2020-05-21 | Carson | Texas | 48065 | 6 | 0 |
162749 | 162749 | 2020-05-20 | Carson | Texas | 48065 | 5 | 0 |
159722 | 159722 | 2020-05-19 | Carson | Texas | 48065 | 5 | 0 |
156700 | 156700 | 2020-05-18 | Carson | Texas | 48065 | 5 | 0 |
153683 | 153683 | 2020-05-17 | Carson | Texas | 48065 | 4 | 0 |
150672 | 150672 | 2020-05-16 | Carson | Texas | 48065 | 3 | 0 |
147664 | 147664 | 2020-05-15 | Carson | Texas | 48065 | 3 | 0 |
144662 | 144662 | 2020-05-14 | Carson | Texas | 48065 | 3 | 0 |
141665 | 141665 | 2020-05-13 | Carson | Texas | 48065 | 3 | 0 |
138669 | 138669 | 2020-05-12 | Carson | Texas | 48065 | 3 | 0 |
135679 | 135679 | 2020-05-11 | Carson | Texas | 48065 | 3 | 0 |
132688 | 132688 | 2020-05-10 | Carson | Texas | 48065 | 3 | 0 |
129698 | 129698 | 2020-05-09 | Carson | Texas | 48065 | 3 | 0 |
126709 | 126709 | 2020-05-08 | Carson | Texas | 48065 | 3 | 0 |
123726 | 123726 | 2020-05-07 | Carson | Texas | 48065 | 3 | 0 |
120747 | 120747 | 2020-05-06 | Carson | Texas | 48065 | 3 | 0 |
117783 | 117783 | 2020-05-05 | Carson | Texas | 48065 | 3 | 0 |
114826 | 114826 | 2020-05-04 | Carson | Texas | 48065 | 3 | 0 |
111944 | 111944 | 2020-05-03 | Carson | Texas | 48065 | 3 | 0 |
109070 | 109070 | 2020-05-02 | Carson | Texas | 48065 | 2 | 0 |
106202 | 106202 | 2020-05-01 | Carson | Texas | 48065 | 2 | 0 |
103338 | 103338 | 2020-04-30 | Carson | Texas | 48065 | 2 | 0 |
100485 | 100485 | 2020-04-29 | Carson | Texas | 48065 | 2 | 0 |
97635 | 97635 | 2020-04-28 | Carson | Texas | 48065 | 1 | 0 |
94795 | 94795 | 2020-04-27 | Carson | Texas | 48065 | 1 | 0 |
91967 | 91967 | 2020-04-26 | Carson | Texas | 48065 | 1 | 0 |
89150 | 89150 | 2020-04-25 | Carson | Texas | 48065 | 1 | 0 |
86335 | 86335 | 2020-04-24 | Carson | Texas | 48065 | 1 | 0 |
83530 | 83530 | 2020-04-23 | Carson | Texas | 48065 | 1 | 0 |
80731 | 80731 | 2020-04-22 | Carson | Texas | 48065 | 1 | 0 |
77940 | 77940 | 2020-04-21 | Carson | Texas | 48065 | 1 | 0 |
75158 | 75158 | 2020-04-20 | Carson | Texas | 48065 | 1 | 0 |
72383 | 72383 | 2020-04-19 | Carson | Texas | 48065 | 1 | 0 |
69616 | 69616 | 2020-04-18 | Carson | Texas | 48065 | 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);