ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 42089 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
964 | 964 | 2020-03-09 | Monroe | Pennsylvania | 42089 | 1 | 0 |
1116 | 1116 | 2020-03-10 | Monroe | Pennsylvania | 42089 | 1 | 0 |
1310 | 1310 | 2020-03-11 | Monroe | Pennsylvania | 42089 | 2 | 0 |
1554 | 1554 | 2020-03-12 | Monroe | Pennsylvania | 42089 | 2 | 0 |
1852 | 1852 | 2020-03-13 | Monroe | Pennsylvania | 42089 | 3 | 0 |
2214 | 2214 | 2020-03-14 | Monroe | Pennsylvania | 42089 | 3 | 0 |
2636 | 2636 | 2020-03-15 | Monroe | Pennsylvania | 42089 | 7 | 0 |
3101 | 3101 | 2020-03-16 | Monroe | Pennsylvania | 42089 | 9 | 0 |
3631 | 3631 | 2020-03-17 | Monroe | Pennsylvania | 42089 | 9 | 0 |
4249 | 4249 | 2020-03-18 | Monroe | Pennsylvania | 42089 | 9 | 0 |
4990 | 4990 | 2020-03-19 | Monroe | Pennsylvania | 42089 | 15 | 0 |
5862 | 5862 | 2020-03-20 | Monroe | Pennsylvania | 42089 | 19 | 0 |
6865 | 6865 | 2020-03-21 | Monroe | Pennsylvania | 42089 | 25 | 0 |
7984 | 7984 | 2020-03-22 | Monroe | Pennsylvania | 42089 | 31 | 0 |
9195 | 9195 | 2020-03-23 | Monroe | Pennsylvania | 42089 | 43 | 1 |
10519 | 10519 | 2020-03-24 | Monroe | Pennsylvania | 42089 | 45 | 1 |
11984 | 11984 | 2020-03-25 | Monroe | Pennsylvania | 42089 | 51 | 1 |
13605 | 13605 | 2020-03-26 | Monroe | Pennsylvania | 42089 | 67 | 2 |
15351 | 15351 | 2020-03-27 | Monroe | Pennsylvania | 42089 | 98 | 2 |
17202 | 17202 | 2020-03-28 | Monroe | Pennsylvania | 42089 | 106 | 2 |
19141 | 19141 | 2020-03-29 | Monroe | Pennsylvania | 42089 | 135 | 3 |
21191 | 21191 | 2020-03-30 | Monroe | Pennsylvania | 42089 | 182 | 7 |
23327 | 23327 | 2020-03-31 | Monroe | Pennsylvania | 42089 | 236 | 7 |
25525 | 25525 | 2020-04-01 | Monroe | Pennsylvania | 42089 | 278 | 8 |
27798 | 27798 | 2020-04-02 | Monroe | Pennsylvania | 42089 | 321 | 10 |
30132 | 30132 | 2020-04-03 | Monroe | Pennsylvania | 42089 | 397 | 10 |
32522 | 32522 | 2020-04-04 | Monroe | Pennsylvania | 42089 | 484 | 11 |
34958 | 34958 | 2020-04-05 | Monroe | Pennsylvania | 42089 | 528 | 11 |
37433 | 37433 | 2020-04-06 | Monroe | Pennsylvania | 42089 | 572 | 11 |
39956 | 39956 | 2020-04-07 | Monroe | Pennsylvania | 42089 | 610 | 12 |
42516 | 42516 | 2020-04-08 | Monroe | Pennsylvania | 42089 | 671 | 17 |
45102 | 45102 | 2020-04-09 | Monroe | Pennsylvania | 42089 | 716 | 19 |
47719 | 47719 | 2020-04-10 | Monroe | Pennsylvania | 42089 | 752 | 19 |
50376 | 50376 | 2020-04-11 | Monroe | Pennsylvania | 42089 | 774 | 22 |
53049 | 53049 | 2020-04-12 | Monroe | Pennsylvania | 42089 | 795 | 23 |
55734 | 55734 | 2020-04-13 | Monroe | Pennsylvania | 42089 | 816 | 24 |
58437 | 58437 | 2020-04-14 | Monroe | Pennsylvania | 42089 | 847 | 27 |
61152 | 61152 | 2020-04-15 | Monroe | Pennsylvania | 42089 | 872 | 28 |
63878 | 63878 | 2020-04-16 | Monroe | Pennsylvania | 42089 | 898 | 29 |
66624 | 66624 | 2020-04-17 | Monroe | Pennsylvania | 42089 | 929 | 29 |
69382 | 69382 | 2020-04-18 | Monroe | Pennsylvania | 42089 | 943 | 34 |
72149 | 72149 | 2020-04-19 | Monroe | Pennsylvania | 42089 | 963 | 38 |
74924 | 74924 | 2020-04-20 | Monroe | Pennsylvania | 42089 | 970 | 39 |
77706 | 77706 | 2020-04-21 | Monroe | Pennsylvania | 42089 | 995 | 46 |
80496 | 80496 | 2020-04-22 | Monroe | Pennsylvania | 42089 | 1015 | 48 |
83295 | 83295 | 2020-04-23 | Monroe | Pennsylvania | 42089 | 1024 | 46 |
86099 | 86099 | 2020-04-24 | Monroe | Pennsylvania | 42089 | 1037 | 46 |
88913 | 88913 | 2020-04-25 | Monroe | Pennsylvania | 42089 | 1054 | 46 |
91729 | 91729 | 2020-04-26 | Monroe | Pennsylvania | 42089 | 1065 | 46 |
94556 | 94556 | 2020-04-27 | Monroe | Pennsylvania | 42089 | 1083 | 46 |
97395 | 97395 | 2020-04-28 | Monroe | Pennsylvania | 42089 | 1097 | 48 |
100244 | 100244 | 2020-04-29 | Monroe | Pennsylvania | 42089 | 1111 | 54 |
103097 | 103097 | 2020-04-30 | Monroe | Pennsylvania | 42089 | 1127 | 54 |
105960 | 105960 | 2020-05-01 | Monroe | Pennsylvania | 42089 | 1147 | 54 |
108827 | 108827 | 2020-05-02 | Monroe | Pennsylvania | 42089 | 1165 | 55 |
111701 | 111701 | 2020-05-03 | Monroe | Pennsylvania | 42089 | 1172 | 55 |
114583 | 114583 | 2020-05-04 | Monroe | Pennsylvania | 42089 | 1173 | 55 |
117464 | 117464 | 2020-05-05 | Monroe | Pennsylvania | 42089 | 1186 | 60 |
120426 | 120426 | 2020-05-06 | Monroe | Pennsylvania | 42089 | 1190 | 60 |
123403 | 123403 | 2020-05-07 | Monroe | Pennsylvania | 42089 | 1194 | 63 |
126386 | 126386 | 2020-05-08 | Monroe | Pennsylvania | 42089 | 1198 | 63 |
129375 | 129375 | 2020-05-09 | Monroe | Pennsylvania | 42089 | 1206 | 63 |
132364 | 132364 | 2020-05-10 | Monroe | Pennsylvania | 42089 | 1218 | 64 |
135355 | 135355 | 2020-05-11 | Monroe | Pennsylvania | 42089 | 1224 | 64 |
138345 | 138345 | 2020-05-12 | Monroe | Pennsylvania | 42089 | 1229 | 64 |
141341 | 141341 | 2020-05-13 | Monroe | Pennsylvania | 42089 | 1228 | 65 |
144337 | 144337 | 2020-05-14 | Monroe | Pennsylvania | 42089 | 1240 | 69 |
147338 | 147338 | 2020-05-15 | Monroe | Pennsylvania | 42089 | 1242 | 70 |
150345 | 150345 | 2020-05-16 | Monroe | Pennsylvania | 42089 | 1248 | 70 |
153356 | 153356 | 2020-05-17 | Monroe | Pennsylvania | 42089 | 1254 | 70 |
156373 | 156373 | 2020-05-18 | Monroe | Pennsylvania | 42089 | 1259 | 88 |
159394 | 159394 | 2020-05-19 | Monroe | Pennsylvania | 42089 | 1267 | 89 |
162421 | 162421 | 2020-05-20 | Monroe | Pennsylvania | 42089 | 1278 | 93 |
165450 | 165450 | 2020-05-21 | Monroe | Pennsylvania | 42089 | 1291 | 95 |
168486 | 168486 | 2020-05-22 | Monroe | Pennsylvania | 42089 | 1295 | 97 |
171525 | 171525 | 2020-05-23 | Monroe | Pennsylvania | 42089 | 1302 | 99 |
174567 | 174567 | 2020-05-24 | Monroe | Pennsylvania | 42089 | 1304 | 99 |
177611 | 177611 | 2020-05-25 | Monroe | Pennsylvania | 42089 | 1305 | 99 |
180654 | 180654 | 2020-05-26 | Monroe | Pennsylvania | 42089 | 1305 | 99 |
183704 | 183704 | 2020-05-27 | Monroe | Pennsylvania | 42089 | 1310 | 100 |
186761 | 186761 | 2020-05-28 | Monroe | Pennsylvania | 42089 | 1311 | 101 |
189822 | 189822 | 2020-05-29 | Monroe | Pennsylvania | 42089 | 1315 | 101 |
192887 | 192887 | 2020-05-30 | Monroe | Pennsylvania | 42089 | 1318 | 101 |
195956 | 195956 | 2020-05-31 | Monroe | Pennsylvania | 42089 | 1319 | 101 |
199029 | 199029 | 2020-06-01 | Monroe | Pennsylvania | 42089 | 1320 | 101 |
202104 | 202104 | 2020-06-02 | Monroe | Pennsylvania | 42089 | 1325 | 101 |
205181 | 205181 | 2020-06-03 | Monroe | Pennsylvania | 42089 | 1326 | 102 |
208262 | 208262 | 2020-06-04 | Monroe | Pennsylvania | 42089 | 1333 | 102 |
211344 | 211344 | 2020-06-05 | Monroe | Pennsylvania | 42089 | 1335 | 102 |
214430 | 214430 | 2020-06-06 | Monroe | Pennsylvania | 42089 | 1338 | 102 |
217520 | 217520 | 2020-06-07 | Monroe | Pennsylvania | 42089 | 1338 | 102 |
220612 | 220612 | 2020-06-08 | Monroe | Pennsylvania | 42089 | 1341 | 102 |
223707 | 223707 | 2020-06-09 | Monroe | Pennsylvania | 42089 | 1342 | 102 |
226807 | 226807 | 2020-06-10 | Monroe | Pennsylvania | 42089 | 1344 | 102 |
229911 | 229911 | 2020-06-11 | Monroe | Pennsylvania | 42089 | 1346 | 103 |
233016 | 233016 | 2020-06-12 | Monroe | Pennsylvania | 42089 | 1347 | 103 |
236121 | 236121 | 2020-06-13 | Monroe | Pennsylvania | 42089 | 1347 | 104 |
239229 | 239229 | 2020-06-14 | Monroe | Pennsylvania | 42089 | 1347 | 104 |
242338 | 242338 | 2020-06-15 | Monroe | Pennsylvania | 42089 | 1350 | 105 |
245450 | 245450 | 2020-06-16 | Monroe | Pennsylvania | 42089 | 1356 | 105 |
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);