ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 48339 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324623 | 324623 | 2020-07-11 | Montgomery | Texas | 48339 | 3007 | 41 |
321442 | 321442 | 2020-07-10 | Montgomery | Texas | 48339 | 3007 | 41 |
318263 | 318263 | 2020-07-09 | Montgomery | Texas | 48339 | 2876 | 40 |
315090 | 315090 | 2020-07-08 | Montgomery | Texas | 48339 | 2784 | 38 |
311916 | 311916 | 2020-07-07 | Montgomery | Texas | 48339 | 2654 | 38 |
308747 | 308747 | 2020-07-06 | Montgomery | Texas | 48339 | 2550 | 37 |
305579 | 305579 | 2020-07-05 | Montgomery | Texas | 48339 | 2353 | 37 |
302415 | 302415 | 2020-07-04 | Montgomery | Texas | 48339 | 2353 | 37 |
299251 | 299251 | 2020-07-03 | Montgomery | Texas | 48339 | 2353 | 37 |
296090 | 296090 | 2020-07-02 | Montgomery | Texas | 48339 | 2353 | 37 |
292935 | 292935 | 2020-07-01 | Montgomery | Texas | 48339 | 2257 | 36 |
289782 | 289782 | 2020-06-30 | Montgomery | Texas | 48339 | 2133 | 36 |
286632 | 286632 | 2020-06-29 | Montgomery | Texas | 48339 | 2028 | 36 |
283486 | 283486 | 2020-06-28 | Montgomery | Texas | 48339 | 1952 | 36 |
280340 | 280340 | 2020-06-27 | Montgomery | Texas | 48339 | 1952 | 36 |
277192 | 277192 | 2020-06-26 | Montgomery | Texas | 48339 | 1952 | 36 |
274044 | 274044 | 2020-06-25 | Montgomery | Texas | 48339 | 1889 | 36 |
270904 | 270904 | 2020-06-24 | Montgomery | Texas | 48339 | 1831 | 36 |
267770 | 267770 | 2020-06-23 | Montgomery | Texas | 48339 | 1737 | 34 |
264642 | 264642 | 2020-06-22 | Montgomery | Texas | 48339 | 1647 | 34 |
261513 | 261513 | 2020-06-21 | Montgomery | Texas | 48339 | 1555 | 34 |
258386 | 258386 | 2020-06-20 | Montgomery | Texas | 48339 | 1555 | 34 |
255259 | 255259 | 2020-06-19 | Montgomery | Texas | 48339 | 1555 | 34 |
252144 | 252144 | 2020-06-18 | Montgomery | Texas | 48339 | 1484 | 33 |
249029 | 249029 | 2020-06-17 | Montgomery | Texas | 48339 | 1428 | 33 |
245916 | 245916 | 2020-06-16 | Montgomery | Texas | 48339 | 1359 | 33 |
242804 | 242804 | 2020-06-15 | Montgomery | Texas | 48339 | 1300 | 33 |
239694 | 239694 | 2020-06-14 | Montgomery | Texas | 48339 | 1258 | 32 |
236586 | 236586 | 2020-06-13 | Montgomery | Texas | 48339 | 1258 | 32 |
233480 | 233480 | 2020-06-12 | Montgomery | Texas | 48339 | 1258 | 32 |
230376 | 230376 | 2020-06-11 | Montgomery | Texas | 48339 | 1197 | 32 |
227272 | 227272 | 2020-06-10 | Montgomery | Texas | 48339 | 1162 | 32 |
224172 | 224172 | 2020-06-09 | Montgomery | Texas | 48339 | 1122 | 31 |
221077 | 221077 | 2020-06-08 | Montgomery | Texas | 48339 | 1090 | 31 |
217985 | 217985 | 2020-06-07 | Montgomery | Texas | 48339 | 1064 | 28 |
214895 | 214895 | 2020-06-06 | Montgomery | Texas | 48339 | 1064 | 28 |
211808 | 211808 | 2020-06-05 | Montgomery | Texas | 48339 | 1064 | 28 |
208724 | 208724 | 2020-06-04 | Montgomery | Texas | 48339 | 1053 | 27 |
205642 | 205642 | 2020-06-03 | Montgomery | Texas | 48339 | 1033 | 26 |
202563 | 202563 | 2020-06-02 | Montgomery | Texas | 48339 | 1010 | 26 |
199487 | 199487 | 2020-06-01 | Montgomery | Texas | 48339 | 966 | 26 |
196414 | 196414 | 2020-05-31 | Montgomery | Texas | 48339 | 954 | 26 |
193344 | 193344 | 2020-05-30 | Montgomery | Texas | 48339 | 954 | 26 |
190278 | 190278 | 2020-05-29 | Montgomery | Texas | 48339 | 954 | 26 |
187214 | 187214 | 2020-05-28 | Montgomery | Texas | 48339 | 940 | 26 |
184157 | 184157 | 2020-05-27 | Montgomery | Texas | 48339 | 926 | 26 |
181107 | 181107 | 2020-05-26 | Montgomery | Texas | 48339 | 913 | 24 |
178063 | 178063 | 2020-05-25 | Montgomery | Texas | 48339 | 888 | 23 |
175019 | 175019 | 2020-05-24 | Montgomery | Texas | 48339 | 888 | 23 |
171976 | 171976 | 2020-05-23 | Montgomery | Texas | 48339 | 888 | 23 |
168936 | 168936 | 2020-05-22 | Montgomery | Texas | 48339 | 888 | 23 |
165900 | 165900 | 2020-05-21 | Montgomery | Texas | 48339 | 881 | 21 |
162871 | 162871 | 2020-05-20 | Montgomery | Texas | 48339 | 861 | 21 |
159843 | 159843 | 2020-05-19 | Montgomery | Texas | 48339 | 848 | 18 |
156820 | 156820 | 2020-05-18 | Montgomery | Texas | 48339 | 817 | 18 |
153803 | 153803 | 2020-05-17 | Montgomery | Texas | 48339 | 798 | 18 |
150792 | 150792 | 2020-05-16 | Montgomery | Texas | 48339 | 798 | 18 |
147784 | 147784 | 2020-05-15 | Montgomery | Texas | 48339 | 798 | 18 |
144780 | 144780 | 2020-05-14 | Montgomery | Texas | 48339 | 773 | 18 |
141783 | 141783 | 2020-05-13 | Montgomery | Texas | 48339 | 758 | 17 |
138787 | 138787 | 2020-05-12 | Montgomery | Texas | 48339 | 742 | 17 |
135797 | 135797 | 2020-05-11 | Montgomery | Texas | 48339 | 724 | 17 |
132806 | 132806 | 2020-05-10 | Montgomery | Texas | 48339 | 699 | 16 |
129816 | 129816 | 2020-05-09 | Montgomery | Texas | 48339 | 699 | 16 |
126827 | 126827 | 2020-05-08 | Montgomery | Texas | 48339 | 699 | 15 |
123843 | 123843 | 2020-05-07 | Montgomery | Texas | 48339 | 689 | 15 |
120864 | 120864 | 2020-05-06 | Montgomery | Texas | 48339 | 672 | 15 |
117900 | 117900 | 2020-05-05 | Montgomery | Texas | 48339 | 662 | 15 |
114941 | 114941 | 2020-05-04 | Montgomery | Texas | 48339 | 640 | 15 |
112059 | 112059 | 2020-05-03 | Montgomery | Texas | 48339 | 634 | 14 |
109185 | 109185 | 2020-05-02 | Montgomery | Texas | 48339 | 634 | 14 |
106316 | 106316 | 2020-05-01 | Montgomery | Texas | 48339 | 629 | 14 |
103452 | 103452 | 2020-04-30 | Montgomery | Texas | 48339 | 602 | 12 |
100597 | 100597 | 2020-04-29 | Montgomery | Texas | 48339 | 582 | 12 |
97747 | 97747 | 2020-04-28 | Montgomery | Texas | 48339 | 562 | 12 |
94906 | 94906 | 2020-04-27 | Montgomery | Texas | 48339 | 530 | 10 |
92077 | 92077 | 2020-04-26 | Montgomery | Texas | 48339 | 506 | 9 |
89260 | 89260 | 2020-04-25 | Montgomery | Texas | 48339 | 496 | 9 |
86445 | 86445 | 2020-04-24 | Montgomery | Texas | 48339 | 496 | 9 |
83640 | 83640 | 2020-04-23 | Montgomery | Texas | 48339 | 467 | 8 |
80839 | 80839 | 2020-04-22 | Montgomery | Texas | 48339 | 440 | 7 |
78048 | 78048 | 2020-04-21 | Montgomery | Texas | 48339 | 417 | 7 |
75266 | 75266 | 2020-04-20 | Montgomery | Texas | 48339 | 393 | 7 |
72490 | 72490 | 2020-04-19 | Montgomery | Texas | 48339 | 377 | 7 |
69721 | 69721 | 2020-04-18 | Montgomery | Texas | 48339 | 377 | 7 |
66961 | 66961 | 2020-04-17 | Montgomery | Texas | 48339 | 370 | 7 |
64214 | 64214 | 2020-04-16 | Montgomery | Texas | 48339 | 350 | 6 |
61485 | 61485 | 2020-04-15 | Montgomery | Texas | 48339 | 331 | 6 |
58767 | 58767 | 2020-04-14 | Montgomery | Texas | 48339 | 308 | 6 |
56062 | 56062 | 2020-04-13 | Montgomery | Texas | 48339 | 266 | 6 |
53374 | 53374 | 2020-04-12 | Montgomery | Texas | 48339 | 251 | 5 |
50699 | 50699 | 2020-04-11 | Montgomery | Texas | 48339 | 245 | 4 |
48041 | 48041 | 2020-04-10 | Montgomery | Texas | 48339 | 231 | 4 |
45420 | 45420 | 2020-04-09 | Montgomery | Texas | 48339 | 210 | 4 |
42828 | 42828 | 2020-04-08 | Montgomery | Texas | 48339 | 197 | 4 |
40260 | 40260 | 2020-04-07 | Montgomery | Texas | 48339 | 161 | 3 |
37731 | 37731 | 2020-04-06 | Montgomery | Texas | 48339 | 161 | 3 |
35255 | 35255 | 2020-04-05 | Montgomery | Texas | 48339 | 142 | 3 |
32817 | 32817 | 2020-04-04 | Montgomery | Texas | 48339 | 130 | 3 |
30421 | 30421 | 2020-04-03 | Montgomery | Texas | 48339 | 119 | 3 |
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);