ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "St. Mary's" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7579 | 7579 | 2020-03-22 | St. Mary's | Maryland | 24037 | 1 | 0 |
8751 | 8751 | 2020-03-23 | St. Mary's | Maryland | 24037 | 1 | 0 |
10040 | 10040 | 2020-03-24 | St. Mary's | Maryland | 24037 | 2 | 0 |
11451 | 11451 | 2020-03-25 | St. Mary's | Maryland | 24037 | 2 | 0 |
13032 | 13032 | 2020-03-26 | St. Mary's | Maryland | 24037 | 4 | 0 |
14740 | 14740 | 2020-03-27 | St. Mary's | Maryland | 24037 | 4 | 0 |
16560 | 16560 | 2020-03-28 | St. Mary's | Maryland | 24037 | 8 | 0 |
18475 | 18475 | 2020-03-29 | St. Mary's | Maryland | 24037 | 9 | 0 |
20491 | 20491 | 2020-03-30 | St. Mary's | Maryland | 24037 | 9 | 0 |
22600 | 22600 | 2020-03-31 | St. Mary's | Maryland | 24037 | 15 | 0 |
24778 | 24778 | 2020-04-01 | St. Mary's | Maryland | 24037 | 19 | 0 |
27030 | 27030 | 2020-04-02 | St. Mary's | Maryland | 24037 | 27 | 0 |
29349 | 29349 | 2020-04-03 | St. Mary's | Maryland | 24037 | 30 | 0 |
31727 | 31727 | 2020-04-04 | St. Mary's | Maryland | 24037 | 34 | 0 |
34152 | 34152 | 2020-04-05 | St. Mary's | Maryland | 24037 | 40 | 0 |
36611 | 36611 | 2020-04-06 | St. Mary's | Maryland | 24037 | 41 | 0 |
39119 | 39119 | 2020-04-07 | St. Mary's | Maryland | 24037 | 46 | 0 |
41671 | 41671 | 2020-04-08 | St. Mary's | Maryland | 24037 | 62 | 0 |
44247 | 44247 | 2020-04-09 | St. Mary's | Maryland | 24037 | 65 | 0 |
46855 | 46855 | 2020-04-10 | St. Mary's | Maryland | 24037 | 71 | 0 |
49497 | 49497 | 2020-04-11 | St. Mary's | Maryland | 24037 | 73 | 0 |
52167 | 52167 | 2020-04-12 | St. Mary's | Maryland | 24037 | 82 | 0 |
54848 | 54848 | 2020-04-13 | St. Mary's | Maryland | 24037 | 95 | 1 |
57546 | 57546 | 2020-04-14 | St. Mary's | Maryland | 24037 | 98 | 3 |
60254 | 60254 | 2020-04-15 | St. Mary's | Maryland | 24037 | 99 | 1 |
62975 | 62975 | 2020-04-16 | St. Mary's | Maryland | 24037 | 98 | 1 |
65713 | 65713 | 2020-04-17 | St. Mary's | Maryland | 24037 | 100 | 1 |
68463 | 68463 | 2020-04-18 | St. Mary's | Maryland | 24037 | 101 | 1 |
71227 | 71227 | 2020-04-19 | St. Mary's | Maryland | 24037 | 105 | 2 |
73999 | 73999 | 2020-04-20 | St. Mary's | Maryland | 24037 | 107 | 2 |
76779 | 76779 | 2020-04-21 | St. Mary's | Maryland | 24037 | 107 | 3 |
79565 | 79565 | 2020-04-22 | St. Mary's | Maryland | 24037 | 112 | 3 |
82360 | 82360 | 2020-04-23 | St. Mary's | Maryland | 24037 | 115 | 4 |
85164 | 85164 | 2020-04-24 | St. Mary's | Maryland | 24037 | 119 | 6 |
87974 | 87974 | 2020-04-25 | St. Mary's | Maryland | 24037 | 124 | 6 |
90790 | 90790 | 2020-04-26 | St. Mary's | Maryland | 24037 | 133 | 6 |
93611 | 93611 | 2020-04-27 | St. Mary's | Maryland | 24037 | 144 | 6 |
96446 | 96446 | 2020-04-28 | St. Mary's | Maryland | 24037 | 145 | 7 |
99292 | 99292 | 2020-04-29 | St. Mary's | Maryland | 24037 | 146 | 8 |
102144 | 102144 | 2020-04-30 | St. Mary's | Maryland | 24037 | 152 | 8 |
105004 | 105004 | 2020-05-01 | St. Mary's | Maryland | 24037 | 159 | 7 |
107868 | 107868 | 2020-05-02 | St. Mary's | Maryland | 24037 | 164 | 7 |
110740 | 110740 | 2020-05-03 | St. Mary's | Maryland | 24037 | 165 | 7 |
113618 | 113618 | 2020-05-04 | St. Mary's | Maryland | 24037 | 168 | 7 |
116499 | 116499 | 2020-05-05 | St. Mary's | Maryland | 24037 | 170 | 7 |
119460 | 119460 | 2020-05-06 | St. Mary's | Maryland | 24037 | 186 | 7 |
122432 | 122432 | 2020-05-07 | St. Mary's | Maryland | 24037 | 193 | 8 |
125414 | 125414 | 2020-05-08 | St. Mary's | Maryland | 24037 | 207 | 8 |
128401 | 128401 | 2020-05-09 | St. Mary's | Maryland | 24037 | 234 | 8 |
131391 | 131391 | 2020-05-10 | St. Mary's | Maryland | 24037 | 241 | 8 |
134382 | 134382 | 2020-05-11 | St. Mary's | Maryland | 24037 | 244 | 9 |
137372 | 137372 | 2020-05-12 | St. Mary's | Maryland | 24037 | 246 | 9 |
140366 | 140366 | 2020-05-13 | St. Mary's | Maryland | 24037 | 254 | 9 |
143361 | 143361 | 2020-05-14 | St. Mary's | Maryland | 24037 | 271 | 9 |
146361 | 146361 | 2020-05-15 | St. Mary's | Maryland | 24037 | 299 | 9 |
149366 | 149366 | 2020-05-16 | St. Mary's | Maryland | 24037 | 306 | 10 |
152377 | 152377 | 2020-05-17 | St. Mary's | Maryland | 24037 | 313 | 11 |
155391 | 155391 | 2020-05-18 | St. Mary's | Maryland | 24037 | 326 | 11 |
158409 | 158409 | 2020-05-19 | St. Mary's | Maryland | 24037 | 338 | 12 |
161435 | 161435 | 2020-05-20 | St. Mary's | Maryland | 24037 | 340 | 12 |
164464 | 164464 | 2020-05-21 | St. Mary's | Maryland | 24037 | 357 | 13 |
167500 | 167500 | 2020-05-22 | St. Mary's | Maryland | 24037 | 370 | 13 |
170537 | 170537 | 2020-05-23 | St. Mary's | Maryland | 24037 | 379 | 14 |
173579 | 173579 | 2020-05-24 | St. Mary's | Maryland | 24037 | 393 | 14 |
176622 | 176622 | 2020-05-25 | St. Mary's | Maryland | 24037 | 395 | 15 |
179666 | 179666 | 2020-05-26 | St. Mary's | Maryland | 24037 | 400 | 15 |
182712 | 182712 | 2020-05-27 | St. Mary's | Maryland | 24037 | 400 | 16 |
185767 | 185767 | 2020-05-28 | St. Mary's | Maryland | 24037 | 417 | 19 |
188825 | 188825 | 2020-05-29 | St. Mary's | Maryland | 24037 | 460 | 20 |
191889 | 191889 | 2020-05-30 | St. Mary's | Maryland | 24037 | 471 | 20 |
194957 | 194957 | 2020-05-31 | St. Mary's | Maryland | 24037 | 499 | 22 |
198028 | 198028 | 2020-06-01 | St. Mary's | Maryland | 24037 | 505 | 23 |
201100 | 201100 | 2020-06-02 | St. Mary's | Maryland | 24037 | 518 | 24 |
204177 | 204177 | 2020-06-03 | St. Mary's | Maryland | 24037 | 536 | 27 |
207258 | 207258 | 2020-06-04 | St. Mary's | Maryland | 24037 | 542 | 28 |
210339 | 210339 | 2020-06-05 | St. Mary's | Maryland | 24037 | 547 | 30 |
213423 | 213423 | 2020-06-06 | St. Mary's | Maryland | 24037 | 548 | 33 |
216511 | 216511 | 2020-06-07 | St. Mary's | Maryland | 24037 | 553 | 34 |
219603 | 219603 | 2020-06-08 | St. Mary's | Maryland | 24037 | 553 | 34 |
222698 | 222698 | 2020-06-09 | St. Mary's | Maryland | 24037 | 561 | 34 |
225794 | 225794 | 2020-06-10 | St. Mary's | Maryland | 24037 | 565 | 35 |
228896 | 228896 | 2020-06-11 | St. Mary's | Maryland | 24037 | 573 | 36 |
232000 | 232000 | 2020-06-12 | St. Mary's | Maryland | 24037 | 575 | 40 |
235105 | 235105 | 2020-06-13 | St. Mary's | Maryland | 24037 | 578 | 40 |
238212 | 238212 | 2020-06-14 | St. Mary's | Maryland | 24037 | 580 | 39 |
241321 | 241321 | 2020-06-15 | St. Mary's | Maryland | 24037 | 582 | 40 |
244432 | 244432 | 2020-06-16 | St. Mary's | Maryland | 24037 | 585 | 40 |
247545 | 247545 | 2020-06-17 | St. Mary's | Maryland | 24037 | 587 | 41 |
250657 | 250657 | 2020-06-18 | St. Mary's | Maryland | 24037 | 595 | 44 |
253772 | 253772 | 2020-06-19 | St. Mary's | Maryland | 24037 | 599 | 44 |
256892 | 256892 | 2020-06-20 | St. Mary's | Maryland | 24037 | 597 | 44 |
260018 | 260018 | 2020-06-21 | St. Mary's | Maryland | 24037 | 602 | 45 |
263147 | 263147 | 2020-06-22 | St. Mary's | Maryland | 24037 | 599 | 46 |
266273 | 266273 | 2020-06-23 | St. Mary's | Maryland | 24037 | 605 | 48 |
269406 | 269406 | 2020-06-24 | St. Mary's | Maryland | 24037 | 606 | 48 |
272543 | 272543 | 2020-06-25 | St. Mary's | Maryland | 24037 | 610 | 48 |
275686 | 275686 | 2020-06-26 | St. Mary's | Maryland | 24037 | 611 | 50 |
278834 | 278834 | 2020-06-27 | St. Mary's | Maryland | 24037 | 619 | 51 |
281982 | 281982 | 2020-06-28 | St. Mary's | Maryland | 24037 | 620 | 51 |
285127 | 285127 | 2020-06-29 | St. Mary's | Maryland | 24037 | 633 | 51 |
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);