participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,845 rows where station_code = "US001P" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
4738394 | 4738394 | 20240729110014_WyLiF | US001P | 2024-08-03T12:08:18.454Z | 2024-08-06T12:15:09.376Z |
4738361 | 4738361 | 20240729105250_Vh3Uj | US001P | 2024-08-03T12:08:14.847Z | 2024-08-06T12:15:09.282Z |
4738310 | 4738310 | 20240729103947_MEzNm | US001P | 2024-08-03T12:08:10.212Z | 2024-08-06T12:15:09.082Z |
4738299 | 4738299 | 20240729103733_M37Cs | US001P | 2024-08-03T12:08:07.624Z | 2024-08-06T12:15:08.961Z |
4738268 | 4738268 | 20240729102747_1gSlB | US001P | 2024-08-03T12:08:04.471Z | 2024-08-06T12:15:08.856Z |
4738253 | 4738253 | 20240729102056_Lh2wY | US001P | 2024-08-03T12:08:02.067Z | 2024-08-06T12:15:08.772Z |
4738195 | 4738195 | 20240729100214_GDkeE | US001P | 2024-08-03T12:07:49.686Z | 2024-08-06T12:15:08.560Z |
4738114 | 4738114 | 20240729092804_DeThW | US001P | 2024-08-03T12:07:37.160Z | 2024-08-06T12:15:07.992Z |
4738081 | 4738081 | 20240729090932_Gba1Q | US001P | 2024-08-03T12:07:31.887Z | 2024-08-06T12:15:07.682Z |
4738053 | 4738053 | 20240729090149_nWEcO | US001P | 2024-08-03T12:07:27.304Z | 2024-08-06T12:15:07.088Z |
4738012 | 4738012 | 20240729084615_e61Pk | US001P | 2024-08-03T12:07:20.699Z | 2024-08-06T12:15:06.837Z |
4737966 | 4737966 | 20240729083756_cyymX | US001P | 2024-08-03T12:07:14.428Z | 2024-08-06T12:15:06.664Z |
4737862 | 4737862 | 20240729080335_HDibu | US001P | 2024-08-03T12:07:02.953Z | 2024-08-06T12:15:06.208Z |
4737842 | 4737842 | 20240729080046_XS3No | US001P | 2024-08-03T12:07:00.444Z | 2024-08-06T12:15:06.125Z |
4737816 | 4737816 | 20240729075304_At9ss | US001P | 2024-08-03T12:06:57.878Z | 2024-08-06T12:15:05.570Z |
4737733 | 4737733 | 20240729073601_vhrzk | US001P | 2024-08-03T12:06:46.459Z | 2024-08-06T12:15:04.982Z |
4737675 | 4737675 | 20240729072213_5aIKF | US001P | 2024-08-03T12:06:30.472Z | 2024-08-06T12:15:04.176Z |
4737673 | 4737673 | 20240729072146_3MM8m | US001P | 2024-08-03T12:06:29.659Z | 2024-08-06T12:15:04.166Z |
4737654 | 4737654 | 20240729071702_Og3or | US001P | 2024-08-03T12:06:27.267Z | 2024-08-06T12:15:04.037Z |
4737630 | 4737630 | 20240729071003_Ndfwm | US001P | 2024-08-03T12:06:24.295Z | 2024-08-06T12:15:03.759Z |
4737528 | 4737528 | 20240729064010_T3uRw | US001P | 2024-08-03T12:06:03.960Z | 2024-08-06T12:15:03.141Z |
4737526 | 4737526 | 20240729063725_8NDsP | US001P | 2024-08-03T12:06:03.375Z | 2024-08-06T12:15:03.092Z |
4737439 | 4737439 | 20240729061000_sy56w | US001P | 2024-08-03T12:05:48.396Z | 2024-08-06T12:15:02.249Z |
4737431 | 4737431 | 20240729060622_CtWs3 | US001P | 2024-08-03T12:05:47.387Z | 2024-08-06T12:15:02.204Z |
4737419 | 4737419 | 20240729060535_MKlgT | US001P | 2024-08-03T12:05:45.299Z | 2024-08-06T12:15:02.186Z |
4737409 | 4737409 | 20240729060423_l9SIk | US001P | 2024-08-03T12:05:43.697Z | 2024-08-06T12:15:02.168Z |
4737378 | 4737378 | 20240729055448_v3CGK | US001P | 2024-08-03T12:05:36.112Z | 2024-08-06T12:15:01.684Z |
4737373 | 4737373 | 20240729055303_mdrIh | US001P | 2024-08-03T12:05:35.160Z | 2024-08-06T12:15:01.548Z |
4737305 | 4737305 | 20240729052509_AzyUe | US001P | 2024-08-03T12:05:18.631Z | 2024-08-06T12:15:00.049Z |
4737191 | 4737191 | 20240729042239_012jR | US001P | 2024-08-03T12:04:50.836Z | 2024-08-06T12:14:57.535Z |
4724440 | 4724440 | 20240728104601_VGxGB | US001P | 2024-07-31T12:10:35.283Z | 2024-08-05T12:20:17.572Z |
4724418 | 4724418 | 20240728104313_srVOT | US001P | 2024-07-31T12:10:34.109Z | 2024-08-05T12:20:17.442Z |
4724042 | 4724042 | 20240728100535_chW2Y | US001P | 2024-07-31T12:10:06.299Z | 2024-08-05T12:20:16.143Z |
4723937 | 4723937 | 20240728095430_PFLGa | US001P | 2024-07-31T12:09:58.004Z | 2024-08-05T12:20:15.522Z |
4723851 | 4723851 | 20240728094530_3roKP | US001P | 2024-07-31T12:09:51.198Z | 2024-08-05T12:20:15.146Z |
4723741 | 4723741 | 20240728093819_PR14V | US001P | 2024-07-31T12:09:44.616Z | 2024-08-05T12:20:14.863Z |
4723633 | 4723633 | 20240728092235_yVqQr | US001P | 2024-07-31T12:09:33.816Z | 2024-08-05T12:20:14.469Z |
4723567 | 4723567 | 20240728091437_MNrMf | US001P | 2024-07-31T12:09:28.647Z | 2024-08-05T12:20:14.140Z |
4722983 | 4722983 | 20240728080918_v24FE | US001P | 2024-07-31T12:09:03.351Z | 2024-08-05T12:20:10.590Z |
4722968 | 4722968 | 20240728080621_t2KHr | US001P | 2024-07-31T12:09:02.815Z | 2024-08-05T12:20:10.493Z |
4722920 | 4722920 | 20240728080012_f0SZl | US001P | 2024-07-31T12:09:00.776Z | 2024-08-05T12:20:10.224Z |
4722455 | 4722455 | 20240728070613_vq4oj | US001P | 2024-07-31T12:08:22.562Z | 2024-08-05T12:20:06.345Z |
4722324 | 4722324 | 20240728064845_a2fX8 | US001P | 2024-07-31T12:08:11.647Z | 2024-08-05T12:20:05.336Z |
4722261 | 4722261 | 20240728064033_DZeHM | US001P | 2024-07-31T12:08:02.628Z | 2024-08-05T12:20:04.570Z |
4722239 | 4722239 | 20240728063844_Zos0g | US001P | 2024-07-31T12:08:00.590Z | 2024-08-05T12:20:04.440Z |
4722235 | 4722235 | 20240728063718_Nt4wN | US001P | 2024-07-31T12:07:59.846Z | 2024-08-05T12:20:04.255Z |
4722207 | 4722207 | 20240728063417_pgyjJ | US001P | 2024-07-31T12:07:57.458Z | 2024-08-05T12:20:04.088Z |
4722172 | 4722172 | 20240728062903_PepCQ | US001P | 2024-07-31T12:07:53.740Z | 2024-08-05T12:20:03.737Z |
4722092 | 4722092 | 20240728061618_8orn6 | US001P | 2024-07-31T12:07:45.092Z | 2024-08-05T12:20:03.226Z |
4722064 | 4722064 | 20240728061017_lOisJ | US001P | 2024-07-31T12:07:41.966Z | 2024-08-05T12:20:03.123Z |
4721856 | 4721856 | 20240728052355_jAuam | US001P | 2024-07-31T12:07:20.915Z | 2024-08-05T12:20:02.272Z |
4721801 | 4721801 | 20240728051051_10lDZ | US001P | 2024-07-31T12:07:16.123Z | 2024-08-05T12:20:02.021Z |
4721756 | 4721756 | 20240728045234_9p0rG | US001P | 2024-07-31T12:07:11.544Z | 2024-08-05T12:20:01.686Z |
4721681 | 4721681 | 20240728042916_0sRv0 | US001P | 2024-07-31T12:06:59.418Z | 2024-08-05T12:20:00.649Z |
4721670 | 4721670 | 20240728042619_yMeTn | US001P | 2024-07-31T12:06:58.581Z | 2024-08-05T12:20:00.405Z |
4721626 | 4721626 | 20240728041909_gaWjQ | US001P | 2024-07-31T12:06:54.704Z | 2024-08-05T12:20:00.137Z |
4721505 | 4721505 | 20240728034322_LI1Pv | US001P | 2024-07-31T12:06:46.370Z | 2024-08-05T12:19:57.409Z |
4665277 | 4665277 | 20240717100949_Tca2k | US001P | 2024-07-19T12:09:38.959Z | 2024-07-25T12:14:15.628Z |
4665270 | 4665270 | 20240717100323_qG0gD | US001P | 2024-07-19T12:09:38.706Z | 2024-07-25T12:14:15.466Z |
4665254 | 4665254 | 20240717094551_chWTT | US001P | 2024-07-19T12:09:38.021Z | 2024-07-25T12:14:15.298Z |
4665170 | 4665170 | 20240717083754_3j8rR | US001P | 2024-07-19T12:09:32.738Z | 2024-07-25T12:14:14.399Z |
4665155 | 4665155 | 20240717082108_CsjZ6 | US001P | 2024-07-19T12:09:31.032Z | 2024-07-25T12:14:13.401Z |
4659857 | 4659857 | 20240717103023_e7vzz | US001P | 2024-07-19T12:00:57.712Z | 2024-07-26T12:17:16.137Z |
4659222 | 4659222 | 20240716085014_bwUdu | US001P | 2024-07-18T12:10:36.937Z | 2024-07-24T12:17:32.011Z |
4651816 | 4651816 | 20240716103503_HeOZz | US001P | 2024-07-18T12:00:42.131Z | 2024-07-25T12:13:36.496Z |
4651814 | 4651814 | 20240716103441_G7hyY | US001P | 2024-07-18T12:00:41.919Z | 2024-07-25T12:13:36.302Z |
4651792 | 4651792 | 20240716102942_9DOQB | US001P | 2024-07-18T12:00:40.009Z | 2024-07-25T12:13:35.832Z |
4651778 | 4651778 | 20240716102650_fLWP2 | US001P | 2024-07-18T12:00:37.144Z | 2024-07-25T12:13:35.401Z |
4651493 | 4651493 | 20240716092741_2I3lF | US001P | 2024-07-18T12:00:12.476Z | 2024-07-25T12:13:31.357Z |
4643833 | 4643833 | 20240715101359_m7Tx8 | US001P | 2024-07-17T12:00:38.013Z | 2024-07-24T12:16:34.541Z |
4643820 | 4643820 | 20240715100746_DLfUZ | US001P | 2024-07-17T12:00:36.845Z | 2024-07-24T12:16:34.213Z |
4643696 | 4643696 | 20240715092427_1snlf | US001P | 2024-07-17T12:00:22.843Z | 2024-07-24T12:16:30.923Z |
4636474 | 4636474 | 20240714103252_381KE | US001P | 2024-07-16T12:01:31.855Z | 2024-07-23T12:08:34.389Z |
4636445 | 4636445 | 20240714102224_hsGYE | US001P | 2024-07-16T12:01:29.468Z | 2024-07-23T12:08:34.301Z |
4636431 | 4636431 | 20240714101915_gO1Fm | US001P | 2024-07-16T12:01:28.516Z | 2024-07-23T12:08:34.245Z |
4636222 | 4636222 | 20240714092905_u3njN | US001P | 2024-07-16T12:01:10.915Z | 2024-07-23T12:08:33.442Z |
4636184 | 4636184 | 20240714092146_uBBQF | US001P | 2024-07-16T12:01:07.956Z | 2024-07-23T12:08:33.257Z |
4636105 | 4636105 | 20240714090317_PglSX | US001P | 2024-07-16T12:01:00.847Z | 2024-07-23T12:08:32.868Z |
4636091 | 4636091 | 20240714090011_O3dri | US001P | 2024-07-16T12:00:59.446Z | 2024-07-23T12:08:32.785Z |
4636048 | 4636048 | 20240714084434_OYWV4 | US001P | 2024-07-16T12:00:55.249Z | 2024-07-23T12:08:32.606Z |
4635989 | 4635989 | 20240714082739_EngRR | US001P | 2024-07-16T12:00:50.964Z | 2024-07-23T12:08:32.357Z |
4635972 | 4635972 | 20240714082111_BiMsD | US001P | 2024-07-16T12:00:49.173Z | 2024-07-23T12:08:32.283Z |
4635531 | 4635531 | 20240713051333_5vo4g | US001P | 2024-07-15T12:07:40.238Z | 2024-07-21T12:13:34.024Z |
4635512 | 4635512 | 20240713044652_h0VN1 | US001P | 2024-07-15T12:07:39.310Z | 2024-07-21T12:13:33.866Z |
4629212 | 4629212 | 20240713105647_y1UUQ | US001P | 2024-07-15T12:01:46.434Z | 2024-07-22T12:09:57.859Z |
4629094 | 4629094 | 20240713104150_2MsEg | US001P | 2024-07-15T12:01:38.969Z | 2024-07-22T12:09:57.429Z |
4628979 | 4628979 | 20240713102844_9PLo1 | US001P | 2024-07-15T12:01:29.092Z | 2024-07-22T12:09:56.945Z |
4628974 | 4628974 | 20240713102813_WWwkd | US001P | 2024-07-15T12:01:28.486Z | 2024-07-22T12:09:56.905Z |
4628753 | 4628753 | 20240713095111_Zqre6 | US001P | 2024-07-15T12:01:09.690Z | 2024-07-22T12:09:56.093Z |
4628696 | 4628696 | 20240713094157_JtTZd | US001P | 2024-07-15T12:01:05.299Z | 2024-07-22T12:09:55.855Z |
4628682 | 4628682 | 20240713093715_UKFRd | US001P | 2024-07-15T12:01:03.865Z | 2024-07-22T12:09:55.755Z |
4628638 | 4628638 | 20240713092206_CsxT0 | US001P | 2024-07-15T12:00:59.307Z | 2024-07-22T12:09:55.526Z |
4628530 | 4628530 | 20240713084331_Ki3s3 | US001P | 2024-07-15T12:00:48.218Z | 2024-07-22T12:09:54.956Z |
4628399 | 4628399 | 20240713080825_u8ekV | US001P | 2024-07-15T12:00:37.280Z | 2024-07-22T12:09:54.321Z |
4628354 | 4628354 | 20240713075612_KwqbN | US001P | 2024-07-15T12:00:32.864Z | 2024-07-22T12:09:54.063Z |
4628324 | 4628324 | 20240713074532_6hSrj | US001P | 2024-07-15T12:00:30.327Z | 2024-07-22T12:09:53.931Z |
4628231 | 4628231 | 20240713071724_WTnCH | US001P | 2024-07-15T12:00:20.449Z | 2024-07-22T12:09:53.365Z |
4628141 | 4628141 | 20240713062330_Mhs6p | US001P | 2024-07-15T12:00:10.033Z | 2024-07-22T12:09:52.654Z |
4623723 | 4623723 | 20240711104205_LEvjp | US001P | 2024-07-14T12:04:51.868Z | 2024-07-20T12:13:08.307Z |
4623714 | 4623714 | 20240711103926_tNE30 | US001P | 2024-07-14T12:04:51.181Z | 2024-07-20T12:13:08.261Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);