ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 24001 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500781 | 2500781 | 2022-05-13 | Allegany | Maryland | 24001 | 17291 | 362 |
2497523 | 2497523 | 2022-05-12 | Allegany | Maryland | 24001 | 17277 | 362 |
2494265 | 2494265 | 2022-05-11 | Allegany | Maryland | 24001 | 17272 | 362 |
2491007 | 2491007 | 2022-05-10 | Allegany | Maryland | 24001 | 17265 | 362 |
2487750 | 2487750 | 2022-05-09 | Allegany | Maryland | 24001 | 17245 | 362 |
2484492 | 2484492 | 2022-05-08 | Allegany | Maryland | 24001 | 17237 | 362 |
2481234 | 2481234 | 2022-05-07 | Allegany | Maryland | 24001 | 17237 | 362 |
2477976 | 2477976 | 2022-05-06 | Allegany | Maryland | 24001 | 17237 | 362 |
2474718 | 2474718 | 2022-05-05 | Allegany | Maryland | 24001 | 17231 | 362 |
2471461 | 2471461 | 2022-05-04 | Allegany | Maryland | 24001 | 17229 | 361 |
2468205 | 2468205 | 2022-05-03 | Allegany | Maryland | 24001 | 17224 | 361 |
2464950 | 2464950 | 2022-05-02 | Allegany | Maryland | 24001 | 17211 | 361 |
2461694 | 2461694 | 2022-05-01 | Allegany | Maryland | 24001 | 17205 | 361 |
2458438 | 2458438 | 2022-04-30 | Allegany | Maryland | 24001 | 17205 | 361 |
2455182 | 2455182 | 2022-04-29 | Allegany | Maryland | 24001 | 17205 | 361 |
2451926 | 2451926 | 2022-04-28 | Allegany | Maryland | 24001 | 17199 | 361 |
2448670 | 2448670 | 2022-04-27 | Allegany | Maryland | 24001 | 17193 | 361 |
2445414 | 2445414 | 2022-04-26 | Allegany | Maryland | 24001 | 17189 | 361 |
2442158 | 2442158 | 2022-04-25 | Allegany | Maryland | 24001 | 17178 | 360 |
2438902 | 2438902 | 2022-04-24 | Allegany | Maryland | 24001 | 17176 | 360 |
2435646 | 2435646 | 2022-04-23 | Allegany | Maryland | 24001 | 17176 | 360 |
2432390 | 2432390 | 2022-04-22 | Allegany | Maryland | 24001 | 17176 | 360 |
2429134 | 2429134 | 2022-04-21 | Allegany | Maryland | 24001 | 17161 | 360 |
2425878 | 2425878 | 2022-04-20 | Allegany | Maryland | 24001 | 17152 | 360 |
2422622 | 2422622 | 2022-04-19 | Allegany | Maryland | 24001 | 17149 | 359 |
2419366 | 2419366 | 2022-04-18 | Allegany | Maryland | 24001 | 17145 | 359 |
2416110 | 2416110 | 2022-04-17 | Allegany | Maryland | 24001 | 17141 | 359 |
2412854 | 2412854 | 2022-04-16 | Allegany | Maryland | 24001 | 17141 | 359 |
2409598 | 2409598 | 2022-04-15 | Allegany | Maryland | 24001 | 17141 | 359 |
2406342 | 2406342 | 2022-04-14 | Allegany | Maryland | 24001 | 17138 | 359 |
2403086 | 2403086 | 2022-04-13 | Allegany | Maryland | 24001 | 17133 | 359 |
2399832 | 2399832 | 2022-04-12 | Allegany | Maryland | 24001 | 17131 | 358 |
2396576 | 2396576 | 2022-04-11 | Allegany | Maryland | 24001 | 17127 | 357 |
2393321 | 2393321 | 2022-04-10 | Allegany | Maryland | 24001 | 17123 | 357 |
2390065 | 2390065 | 2022-04-09 | Allegany | Maryland | 24001 | 17123 | 357 |
2386809 | 2386809 | 2022-04-08 | Allegany | Maryland | 24001 | 17123 | 357 |
2383554 | 2383554 | 2022-04-07 | Allegany | Maryland | 24001 | 17119 | 357 |
2380299 | 2380299 | 2022-04-06 | Allegany | Maryland | 24001 | 17119 | 357 |
2377044 | 2377044 | 2022-04-05 | Allegany | Maryland | 24001 | 17118 | 357 |
2373792 | 2373792 | 2022-04-04 | Allegany | Maryland | 24001 | 17116 | 357 |
2370539 | 2370539 | 2022-04-03 | Allegany | Maryland | 24001 | 17112 | 357 |
2367286 | 2367286 | 2022-04-02 | Allegany | Maryland | 24001 | 17112 | 357 |
2364033 | 2364033 | 2022-04-01 | Allegany | Maryland | 24001 | 17112 | 357 |
2360779 | 2360779 | 2022-03-31 | Allegany | Maryland | 24001 | 17112 | 357 |
2357525 | 2357525 | 2022-03-30 | Allegany | Maryland | 24001 | 17106 | 357 |
2354272 | 2354272 | 2022-03-29 | Allegany | Maryland | 24001 | 17102 | 357 |
2351020 | 2351020 | 2022-03-28 | Allegany | Maryland | 24001 | 17099 | 357 |
2347767 | 2347767 | 2022-03-27 | Allegany | Maryland | 24001 | 17099 | 357 |
2344514 | 2344514 | 2022-03-26 | Allegany | Maryland | 24001 | 17099 | 357 |
2341261 | 2341261 | 2022-03-25 | Allegany | Maryland | 24001 | 17097 | 356 |
2338008 | 2338008 | 2022-03-24 | Allegany | Maryland | 24001 | 17090 | 356 |
2334754 | 2334754 | 2022-03-23 | Allegany | Maryland | 24001 | 17084 | 356 |
2331500 | 2331500 | 2022-03-22 | Allegany | Maryland | 24001 | 17084 | 355 |
2328248 | 2328248 | 2022-03-21 | Allegany | Maryland | 24001 | 17082 | 355 |
2324995 | 2324995 | 2022-03-20 | Allegany | Maryland | 24001 | 17078 | 355 |
2321741 | 2321741 | 2022-03-19 | Allegany | Maryland | 24001 | 17078 | 355 |
2318487 | 2318487 | 2022-03-18 | Allegany | Maryland | 24001 | 17074 | 355 |
2315234 | 2315234 | 2022-03-17 | Allegany | Maryland | 24001 | 17070 | 353 |
2311981 | 2311981 | 2022-03-16 | Allegany | Maryland | 24001 | 17066 | 353 |
2308728 | 2308728 | 2022-03-15 | Allegany | Maryland | 24001 | 17062 | 353 |
2305477 | 2305477 | 2022-03-14 | Allegany | Maryland | 24001 | 17062 | 353 |
2302225 | 2302225 | 2022-03-13 | Allegany | Maryland | 24001 | 17062 | 353 |
2298973 | 2298973 | 2022-03-12 | Allegany | Maryland | 24001 | 17059 | 353 |
2295721 | 2295721 | 2022-03-11 | Allegany | Maryland | 24001 | 17052 | 352 |
2292469 | 2292469 | 2022-03-10 | Allegany | Maryland | 24001 | 17051 | 350 |
2289217 | 2289217 | 2022-03-09 | Allegany | Maryland | 24001 | 17043 | 350 |
2285966 | 2285966 | 2022-03-08 | Allegany | Maryland | 24001 | 17041 | 349 |
2282714 | 2282714 | 2022-03-07 | Allegany | Maryland | 24001 | 17026 | 349 |
2279461 | 2279461 | 2022-03-06 | Allegany | Maryland | 24001 | 17021 | 349 |
2276208 | 2276208 | 2022-03-05 | Allegany | Maryland | 24001 | 17019 | 349 |
2272955 | 2272955 | 2022-03-04 | Allegany | Maryland | 24001 | 17011 | 349 |
2269703 | 2269703 | 2022-03-03 | Allegany | Maryland | 24001 | 16997 | 348 |
2266450 | 2266450 | 2022-03-02 | Allegany | Maryland | 24001 | 16977 | 348 |
2263199 | 2263199 | 2022-03-01 | Allegany | Maryland | 24001 | 16970 | 347 |
2259948 | 2259948 | 2022-02-28 | Allegany | Maryland | 24001 | 16954 | 347 |
2256697 | 2256697 | 2022-02-27 | Allegany | Maryland | 24001 | 16946 | 347 |
2253446 | 2253446 | 2022-02-26 | Allegany | Maryland | 24001 | 16943 | 347 |
2250195 | 2250195 | 2022-02-25 | Allegany | Maryland | 24001 | 16917 | 346 |
2246944 | 2246944 | 2022-02-24 | Allegany | Maryland | 24001 | 16892 | 346 |
2243693 | 2243693 | 2022-02-23 | Allegany | Maryland | 24001 | 16859 | 344 |
2240442 | 2240442 | 2022-02-22 | Allegany | Maryland | 24001 | 16855 | 343 |
2237191 | 2237191 | 2022-02-21 | Allegany | Maryland | 24001 | 16825 | 343 |
2233940 | 2233940 | 2022-02-20 | Allegany | Maryland | 24001 | 16825 | 343 |
2230689 | 2230689 | 2022-02-19 | Allegany | Maryland | 24001 | 16815 | 343 |
2227438 | 2227438 | 2022-02-18 | Allegany | Maryland | 24001 | 16764 | 342 |
2224187 | 2224187 | 2022-02-17 | Allegany | Maryland | 24001 | 16727 | 342 |
2220936 | 2220936 | 2022-02-16 | Allegany | Maryland | 24001 | 16714 | 340 |
2217685 | 2217685 | 2022-02-15 | Allegany | Maryland | 24001 | 16148 | 340 |
2214434 | 2214434 | 2022-02-14 | Allegany | Maryland | 24001 | 16139 | 340 |
2211182 | 2211182 | 2022-02-13 | Allegany | Maryland | 24001 | 16106 | 340 |
2207929 | 2207929 | 2022-02-12 | Allegany | Maryland | 24001 | 16076 | 340 |
2204676 | 2204676 | 2022-02-11 | Allegany | Maryland | 24001 | 16056 | 339 |
2201423 | 2201423 | 2022-02-10 | Allegany | Maryland | 24001 | 16042 | 339 |
2198169 | 2198169 | 2022-02-09 | Allegany | Maryland | 24001 | 16007 | 336 |
2194915 | 2194915 | 2022-02-08 | Allegany | Maryland | 24001 | 15968 | 334 |
2191661 | 2191661 | 2022-02-07 | Allegany | Maryland | 24001 | 15956 | 333 |
2188408 | 2188408 | 2022-02-06 | Allegany | Maryland | 24001 | 15934 | 333 |
2185155 | 2185155 | 2022-02-05 | Allegany | Maryland | 24001 | 15881 | 333 |
2181903 | 2181903 | 2022-02-04 | Allegany | Maryland | 24001 | 15844 | 332 |
2178651 | 2178651 | 2022-02-03 | Allegany | Maryland | 24001 | 15765 | 332 |
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);