ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Montgomery" and state = "Texas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- …
state 1
- Texas · 795 ✖
fips 1
- 48339 795
county 1
- Montgomery · 795 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1137 | 1137 | 2020-03-10 | Montgomery | Texas | 48339 | 1 | 0 |
1334 | 1334 | 2020-03-11 | Montgomery | Texas | 48339 | 1 | 0 |
1581 | 1581 | 2020-03-12 | Montgomery | Texas | 48339 | 1 | 0 |
1888 | 1888 | 2020-03-13 | Montgomery | Texas | 48339 | 1 | 0 |
2255 | 2255 | 2020-03-14 | Montgomery | Texas | 48339 | 1 | 0 |
2681 | 2681 | 2020-03-15 | Montgomery | Texas | 48339 | 1 | 0 |
3150 | 3150 | 2020-03-16 | Montgomery | Texas | 48339 | 3 | 0 |
3686 | 3686 | 2020-03-17 | Montgomery | Texas | 48339 | 3 | 0 |
4312 | 4312 | 2020-03-18 | Montgomery | Texas | 48339 | 3 | 0 |
5067 | 5067 | 2020-03-19 | Montgomery | Texas | 48339 | 3 | 0 |
5960 | 5960 | 2020-03-20 | Montgomery | Texas | 48339 | 4 | 0 |
6981 | 6981 | 2020-03-21 | Montgomery | Texas | 48339 | 4 | 0 |
8111 | 8111 | 2020-03-22 | Montgomery | Texas | 48339 | 13 | 0 |
9329 | 9329 | 2020-03-23 | Montgomery | Texas | 48339 | 15 | 0 |
10669 | 10669 | 2020-03-24 | Montgomery | Texas | 48339 | 15 | 0 |
12172 | 12172 | 2020-03-25 | Montgomery | Texas | 48339 | 23 | 0 |
13804 | 13804 | 2020-03-26 | Montgomery | Texas | 48339 | 31 | 0 |
15561 | 15561 | 2020-03-27 | Montgomery | Texas | 48339 | 46 | 0 |
17432 | 17432 | 2020-03-28 | Montgomery | Texas | 48339 | 47 | 0 |
19387 | 19387 | 2020-03-29 | Montgomery | Texas | 48339 | 64 | 0 |
21448 | 21448 | 2020-03-30 | Montgomery | Texas | 48339 | 66 | 0 |
23587 | 23587 | 2020-03-31 | Montgomery | Texas | 48339 | 81 | 0 |
25799 | 25799 | 2020-04-01 | Montgomery | Texas | 48339 | 110 | 2 |
28085 | 28085 | 2020-04-02 | Montgomery | Texas | 48339 | 110 | 2 |
30421 | 30421 | 2020-04-03 | Montgomery | Texas | 48339 | 119 | 3 |
32817 | 32817 | 2020-04-04 | Montgomery | Texas | 48339 | 130 | 3 |
35255 | 35255 | 2020-04-05 | Montgomery | Texas | 48339 | 142 | 3 |
37731 | 37731 | 2020-04-06 | Montgomery | Texas | 48339 | 161 | 3 |
40260 | 40260 | 2020-04-07 | Montgomery | Texas | 48339 | 161 | 3 |
42828 | 42828 | 2020-04-08 | Montgomery | Texas | 48339 | 197 | 4 |
45420 | 45420 | 2020-04-09 | Montgomery | Texas | 48339 | 210 | 4 |
48041 | 48041 | 2020-04-10 | Montgomery | Texas | 48339 | 231 | 4 |
50699 | 50699 | 2020-04-11 | Montgomery | Texas | 48339 | 245 | 4 |
53374 | 53374 | 2020-04-12 | Montgomery | Texas | 48339 | 251 | 5 |
56062 | 56062 | 2020-04-13 | Montgomery | Texas | 48339 | 266 | 6 |
58767 | 58767 | 2020-04-14 | Montgomery | Texas | 48339 | 308 | 6 |
61485 | 61485 | 2020-04-15 | Montgomery | Texas | 48339 | 331 | 6 |
64214 | 64214 | 2020-04-16 | Montgomery | Texas | 48339 | 350 | 6 |
66961 | 66961 | 2020-04-17 | Montgomery | Texas | 48339 | 370 | 7 |
69721 | 69721 | 2020-04-18 | Montgomery | Texas | 48339 | 377 | 7 |
72490 | 72490 | 2020-04-19 | Montgomery | Texas | 48339 | 377 | 7 |
75266 | 75266 | 2020-04-20 | Montgomery | Texas | 48339 | 393 | 7 |
78048 | 78048 | 2020-04-21 | Montgomery | Texas | 48339 | 417 | 7 |
80839 | 80839 | 2020-04-22 | Montgomery | Texas | 48339 | 440 | 7 |
83640 | 83640 | 2020-04-23 | Montgomery | Texas | 48339 | 467 | 8 |
86445 | 86445 | 2020-04-24 | Montgomery | Texas | 48339 | 496 | 9 |
89260 | 89260 | 2020-04-25 | Montgomery | Texas | 48339 | 496 | 9 |
92077 | 92077 | 2020-04-26 | Montgomery | Texas | 48339 | 506 | 9 |
94906 | 94906 | 2020-04-27 | Montgomery | Texas | 48339 | 530 | 10 |
97747 | 97747 | 2020-04-28 | Montgomery | Texas | 48339 | 562 | 12 |
100597 | 100597 | 2020-04-29 | Montgomery | Texas | 48339 | 582 | 12 |
103452 | 103452 | 2020-04-30 | Montgomery | Texas | 48339 | 602 | 12 |
106316 | 106316 | 2020-05-01 | Montgomery | Texas | 48339 | 629 | 14 |
109185 | 109185 | 2020-05-02 | Montgomery | Texas | 48339 | 634 | 14 |
112059 | 112059 | 2020-05-03 | Montgomery | Texas | 48339 | 634 | 14 |
114941 | 114941 | 2020-05-04 | Montgomery | Texas | 48339 | 640 | 15 |
117900 | 117900 | 2020-05-05 | Montgomery | Texas | 48339 | 662 | 15 |
120864 | 120864 | 2020-05-06 | Montgomery | Texas | 48339 | 672 | 15 |
123843 | 123843 | 2020-05-07 | Montgomery | Texas | 48339 | 689 | 15 |
126827 | 126827 | 2020-05-08 | Montgomery | Texas | 48339 | 699 | 15 |
129816 | 129816 | 2020-05-09 | Montgomery | Texas | 48339 | 699 | 16 |
132806 | 132806 | 2020-05-10 | Montgomery | Texas | 48339 | 699 | 16 |
135797 | 135797 | 2020-05-11 | Montgomery | Texas | 48339 | 724 | 17 |
138787 | 138787 | 2020-05-12 | Montgomery | Texas | 48339 | 742 | 17 |
141783 | 141783 | 2020-05-13 | Montgomery | Texas | 48339 | 758 | 17 |
144780 | 144780 | 2020-05-14 | Montgomery | Texas | 48339 | 773 | 18 |
147784 | 147784 | 2020-05-15 | Montgomery | Texas | 48339 | 798 | 18 |
150792 | 150792 | 2020-05-16 | Montgomery | Texas | 48339 | 798 | 18 |
153803 | 153803 | 2020-05-17 | Montgomery | Texas | 48339 | 798 | 18 |
156820 | 156820 | 2020-05-18 | Montgomery | Texas | 48339 | 817 | 18 |
159843 | 159843 | 2020-05-19 | Montgomery | Texas | 48339 | 848 | 18 |
162871 | 162871 | 2020-05-20 | Montgomery | Texas | 48339 | 861 | 21 |
165900 | 165900 | 2020-05-21 | Montgomery | Texas | 48339 | 881 | 21 |
168936 | 168936 | 2020-05-22 | Montgomery | Texas | 48339 | 888 | 23 |
171976 | 171976 | 2020-05-23 | Montgomery | Texas | 48339 | 888 | 23 |
175019 | 175019 | 2020-05-24 | Montgomery | Texas | 48339 | 888 | 23 |
178063 | 178063 | 2020-05-25 | Montgomery | Texas | 48339 | 888 | 23 |
181107 | 181107 | 2020-05-26 | Montgomery | Texas | 48339 | 913 | 24 |
184157 | 184157 | 2020-05-27 | Montgomery | Texas | 48339 | 926 | 26 |
187214 | 187214 | 2020-05-28 | Montgomery | Texas | 48339 | 940 | 26 |
190278 | 190278 | 2020-05-29 | Montgomery | Texas | 48339 | 954 | 26 |
193344 | 193344 | 2020-05-30 | Montgomery | Texas | 48339 | 954 | 26 |
196414 | 196414 | 2020-05-31 | Montgomery | Texas | 48339 | 954 | 26 |
199487 | 199487 | 2020-06-01 | Montgomery | Texas | 48339 | 966 | 26 |
202563 | 202563 | 2020-06-02 | Montgomery | Texas | 48339 | 1010 | 26 |
205642 | 205642 | 2020-06-03 | Montgomery | Texas | 48339 | 1033 | 26 |
208724 | 208724 | 2020-06-04 | Montgomery | Texas | 48339 | 1053 | 27 |
211808 | 211808 | 2020-06-05 | Montgomery | Texas | 48339 | 1064 | 28 |
214895 | 214895 | 2020-06-06 | Montgomery | Texas | 48339 | 1064 | 28 |
217985 | 217985 | 2020-06-07 | Montgomery | Texas | 48339 | 1064 | 28 |
221077 | 221077 | 2020-06-08 | Montgomery | Texas | 48339 | 1090 | 31 |
224172 | 224172 | 2020-06-09 | Montgomery | Texas | 48339 | 1122 | 31 |
227272 | 227272 | 2020-06-10 | Montgomery | Texas | 48339 | 1162 | 32 |
230376 | 230376 | 2020-06-11 | Montgomery | Texas | 48339 | 1197 | 32 |
233480 | 233480 | 2020-06-12 | Montgomery | Texas | 48339 | 1258 | 32 |
236586 | 236586 | 2020-06-13 | Montgomery | Texas | 48339 | 1258 | 32 |
239694 | 239694 | 2020-06-14 | Montgomery | Texas | 48339 | 1258 | 32 |
242804 | 242804 | 2020-06-15 | Montgomery | Texas | 48339 | 1300 | 33 |
245916 | 245916 | 2020-06-16 | Montgomery | Texas | 48339 | 1359 | 33 |
249029 | 249029 | 2020-06-17 | Montgomery | Texas | 48339 | 1428 | 33 |
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);