ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,338 rows where county = "Orange" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 8
- California 840
- New York 793
- Florida 792
- Vermont 789
- North Carolina 785
- Texas 780
- Virginia 780
- Indiana 779
county 1
- Orange · 6,338 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499791 | 2499791 | 2022-05-13 | Orange | California | 6059 | 600384 | 7023 |
2499945 | 2499945 | 2022-05-13 | Orange | Florida | 12095 | 383010 | 2835 |
2500338 | 2500338 | 2022-05-13 | Orange | Indiana | 18117 | 5051 | 96 |
2501461 | 2501461 | 2022-05-13 | Orange | New York | 36071 | 111228 | 954 |
2501553 | 2501553 | 2022-05-13 | Orange | North Carolina | 37135 | 28209 | 134 |
2502387 | 2502387 | 2022-05-13 | Orange | Texas | 48361 | 14968 | 355 |
2502500 | 2502500 | 2022-05-13 | Orange | Vermont | 50017 | 4420 | 14 |
2502600 | 2502600 | 2022-05-13 | Orange | Virginia | 51137 | 6928 | 86 |
2496533 | 2496533 | 2022-05-12 | Orange | California | 6059 | 598954 | 7019 |
2496687 | 2496687 | 2022-05-12 | Orange | Florida | 12095 | 383010 | 2835 |
2497080 | 2497080 | 2022-05-12 | Orange | Indiana | 18117 | 5051 | 96 |
2498203 | 2498203 | 2022-05-12 | Orange | New York | 36071 | 111228 | 953 |
2498295 | 2498295 | 2022-05-12 | Orange | North Carolina | 37135 | 28209 | 134 |
2499129 | 2499129 | 2022-05-12 | Orange | Texas | 48361 | 14968 | 355 |
2499242 | 2499242 | 2022-05-12 | Orange | Vermont | 50017 | 4410 | 14 |
2499342 | 2499342 | 2022-05-12 | Orange | Virginia | 51137 | 6915 | 86 |
2493275 | 2493275 | 2022-05-11 | Orange | California | 6059 | 598954 | 7019 |
2493429 | 2493429 | 2022-05-11 | Orange | Florida | 12095 | 383010 | 2835 |
2493822 | 2493822 | 2022-05-11 | Orange | Indiana | 18117 | 5051 | 96 |
2494945 | 2494945 | 2022-05-11 | Orange | New York | 36071 | 111001 | 953 |
2495037 | 2495037 | 2022-05-11 | Orange | North Carolina | 37135 | 28209 | 134 |
2495871 | 2495871 | 2022-05-11 | Orange | Texas | 48361 | 14968 | 355 |
2495984 | 2495984 | 2022-05-11 | Orange | Vermont | 50017 | 4388 | 14 |
2496084 | 2496084 | 2022-05-11 | Orange | Virginia | 51137 | 6904 | 86 |
2490017 | 2490017 | 2022-05-10 | Orange | California | 6059 | 598954 | 7019 |
2490171 | 2490171 | 2022-05-10 | Orange | Florida | 12095 | 383010 | 2831 |
2490564 | 2490564 | 2022-05-10 | Orange | Indiana | 18117 | 5048 | 96 |
2491687 | 2491687 | 2022-05-10 | Orange | New York | 36071 | 110754 | 953 |
2491779 | 2491779 | 2022-05-10 | Orange | North Carolina | 37135 | 27771 | 134 |
2492613 | 2492613 | 2022-05-10 | Orange | Texas | 48361 | 14965 | 355 |
2492726 | 2492726 | 2022-05-10 | Orange | Vermont | 50017 | 4376 | 14 |
2492826 | 2492826 | 2022-05-10 | Orange | Virginia | 51137 | 6896 | 86 |
2486760 | 2486760 | 2022-05-09 | Orange | California | 6059 | 597100 | 7011 |
2486914 | 2486914 | 2022-05-09 | Orange | Florida | 12095 | 383010 | 2831 |
2487307 | 2487307 | 2022-05-09 | Orange | Indiana | 18117 | 5048 | 96 |
2488429 | 2488429 | 2022-05-09 | Orange | New York | 36071 | 110607 | 953 |
2488521 | 2488521 | 2022-05-09 | Orange | North Carolina | 37135 | 27771 | 134 |
2489355 | 2489355 | 2022-05-09 | Orange | Texas | 48361 | 14964 | 355 |
2489468 | 2489468 | 2022-05-09 | Orange | Vermont | 50017 | 4370 | 13 |
2489568 | 2489568 | 2022-05-09 | Orange | Virginia | 51137 | 6888 | 86 |
2483502 | 2483502 | 2022-05-08 | Orange | California | 6059 | 597100 | 7011 |
2483656 | 2483656 | 2022-05-08 | Orange | Florida | 12095 | 383010 | 2831 |
2484049 | 2484049 | 2022-05-08 | Orange | Indiana | 18117 | 5049 | 96 |
2485172 | 2485172 | 2022-05-08 | Orange | New York | 36071 | 110498 | 953 |
2485264 | 2485264 | 2022-05-08 | Orange | North Carolina | 37135 | 27771 | 134 |
2486098 | 2486098 | 2022-05-08 | Orange | Texas | 48361 | 14963 | 355 |
2486210 | 2486210 | 2022-05-08 | Orange | Vermont | 50017 | 4339 | 13 |
2486311 | 2486311 | 2022-05-08 | Orange | Virginia | 51137 | 6863 | 86 |
2480244 | 2480244 | 2022-05-07 | Orange | California | 6059 | 597100 | 7011 |
2480398 | 2480398 | 2022-05-07 | Orange | Florida | 12095 | 383010 | 2831 |
2480791 | 2480791 | 2022-05-07 | Orange | Indiana | 18117 | 5049 | 96 |
2481914 | 2481914 | 2022-05-07 | Orange | New York | 36071 | 110336 | 953 |
2482006 | 2482006 | 2022-05-07 | Orange | North Carolina | 37135 | 27771 | 134 |
2482840 | 2482840 | 2022-05-07 | Orange | Texas | 48361 | 14962 | 355 |
2482952 | 2482952 | 2022-05-07 | Orange | Vermont | 50017 | 4339 | 13 |
2483053 | 2483053 | 2022-05-07 | Orange | Virginia | 51137 | 6863 | 86 |
2476986 | 2476986 | 2022-05-06 | Orange | California | 6059 | 597100 | 7011 |
2477140 | 2477140 | 2022-05-06 | Orange | Florida | 12095 | 383010 | 2831 |
2477533 | 2477533 | 2022-05-06 | Orange | Indiana | 18117 | 5049 | 96 |
2478656 | 2478656 | 2022-05-06 | Orange | New York | 36071 | 110120 | 953 |
2478748 | 2478748 | 2022-05-06 | Orange | North Carolina | 37135 | 27771 | 134 |
2479582 | 2479582 | 2022-05-06 | Orange | Texas | 48361 | 14961 | 355 |
2479694 | 2479694 | 2022-05-06 | Orange | Vermont | 50017 | 4339 | 13 |
2479795 | 2479795 | 2022-05-06 | Orange | Virginia | 51137 | 6863 | 86 |
2473728 | 2473728 | 2022-05-05 | Orange | California | 6059 | 595487 | 7009 |
2473882 | 2473882 | 2022-05-05 | Orange | Florida | 12095 | 378919 | 2831 |
2474275 | 2474275 | 2022-05-05 | Orange | Indiana | 18117 | 5049 | 96 |
2475398 | 2475398 | 2022-05-05 | Orange | New York | 36071 | 109911 | 953 |
2475490 | 2475490 | 2022-05-05 | Orange | North Carolina | 37135 | 27771 | 134 |
2476324 | 2476324 | 2022-05-05 | Orange | Texas | 48361 | 14960 | 355 |
2476436 | 2476436 | 2022-05-05 | Orange | Vermont | 50017 | 4324 | 13 |
2476537 | 2476537 | 2022-05-05 | Orange | Virginia | 51137 | 6857 | 86 |
2470471 | 2470471 | 2022-05-04 | Orange | California | 6059 | 595487 | 7009 |
2470625 | 2470625 | 2022-05-04 | Orange | Florida | 12095 | 378919 | 2831 |
2471018 | 2471018 | 2022-05-04 | Orange | Indiana | 18117 | 5049 | 96 |
2472141 | 2472141 | 2022-05-04 | Orange | New York | 36071 | 109690 | 953 |
2472233 | 2472233 | 2022-05-04 | Orange | North Carolina | 37135 | 27771 | 134 |
2473067 | 2473067 | 2022-05-04 | Orange | Texas | 48361 | 14958 | 355 |
2473179 | 2473179 | 2022-05-04 | Orange | Vermont | 50017 | 4306 | 13 |
2473279 | 2473279 | 2022-05-04 | Orange | Virginia | 51137 | 6847 | 86 |
2467215 | 2467215 | 2022-05-03 | Orange | California | 6059 | 595487 | 7009 |
2467369 | 2467369 | 2022-05-03 | Orange | Florida | 12095 | 378919 | 2826 |
2467762 | 2467762 | 2022-05-03 | Orange | Indiana | 18117 | 5047 | 96 |
2468885 | 2468885 | 2022-05-03 | Orange | New York | 36071 | 109534 | 953 |
2468977 | 2468977 | 2022-05-03 | Orange | North Carolina | 37135 | 27446 | 125 |
2469811 | 2469811 | 2022-05-03 | Orange | Texas | 48361 | 14958 | 355 |
2469923 | 2469923 | 2022-05-03 | Orange | Vermont | 50017 | 4284 | 13 |
2470023 | 2470023 | 2022-05-03 | Orange | Virginia | 51137 | 6830 | 86 |
2463960 | 2463960 | 2022-05-02 | Orange | California | 6059 | 594132 | 7007 |
2464114 | 2464114 | 2022-05-02 | Orange | Florida | 12095 | 378919 | 2826 |
2464507 | 2464507 | 2022-05-02 | Orange | Indiana | 18117 | 5047 | 96 |
2465629 | 2465629 | 2022-05-02 | Orange | New York | 36071 | 109423 | 953 |
2465721 | 2465721 | 2022-05-02 | Orange | North Carolina | 37135 | 27446 | 125 |
2466555 | 2466555 | 2022-05-02 | Orange | Texas | 48361 | 14958 | 355 |
2466667 | 2466667 | 2022-05-02 | Orange | Vermont | 50017 | 4277 | 13 |
2466767 | 2466767 | 2022-05-02 | Orange | Virginia | 51137 | 6827 | 86 |
2460704 | 2460704 | 2022-05-01 | Orange | California | 6059 | 594132 | 7007 |
2460858 | 2460858 | 2022-05-01 | Orange | Florida | 12095 | 378919 | 2826 |
2461251 | 2461251 | 2022-05-01 | Orange | Indiana | 18117 | 5045 | 96 |
2462374 | 2462374 | 2022-05-01 | Orange | New York | 36071 | 109333 | 953 |
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);