participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,647 rows where station_code = "CA000E" 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 |
---|---|---|---|---|---|
5496972 | 5496972 | 20241107022054_vCwm1 | CA000E | 2024-11-08T14:13:01.486Z | 2024-11-08T14:14:35.227Z |
5496753 | 5496753 | 20241107013020_TrqHU | CA000E | 2024-11-08T14:12:49.589Z | 2024-11-08T14:14:35.174Z |
5496599 | 5496599 | 20241107005959_eUgeQ | CA000E | 2024-11-08T14:12:30.635Z | 2024-11-08T14:14:35.139Z |
5496168 | 5496168 | 20241106231415_tqJMc | CA000E | 2024-11-08T14:11:41.544Z | 2024-11-08T14:14:35.034Z |
5492951 | 5492951 | 20241107102340_NTQiH | CA000E | 2024-11-08T14:02:37.417Z | 2024-11-08T14:02:37.417Z |
5478479 | 5478479 | 20241104041636_QIUbV | CA000E | 2024-11-05T14:18:24.683Z | 2024-11-08T14:20:13.808Z |
5478328 | 5478328 | 20241104035330_gN2YS | CA000E | 2024-11-05T14:18:13.898Z | 2024-11-08T14:20:11.960Z |
5478155 | 5478155 | 20241104032856_hyx1I | CA000E | 2024-11-05T14:17:59.697Z | 2024-11-08T14:20:10.179Z |
5470311 | 5470311 | 20241104065119_bqb1t | CA000E | 2024-11-05T14:00:11.901Z | 2024-11-08T14:17:10.096Z |
5464954 | 5464954 | 20241103100449_GYJ0s | CA000E | 2024-11-04T14:02:17.750Z | 2024-11-08T14:19:02.569Z |
5464938 | 5464938 | 20241103095708_NPSl1 | CA000E | 2024-11-04T14:02:14.915Z | 2024-11-08T14:19:02.009Z |
5464772 | 5464772 | 20241103090936_rzXzp | CA000E | 2024-11-04T14:01:37.765Z | 2024-11-08T14:19:00.915Z |
5464591 | 5464591 | 20241103082729_pi8JF | CA000E | 2024-11-04T14:01:03.113Z | 2024-11-08T14:18:58.983Z |
5432682 | 5432682 | 20241029041615_QH7dc | CA000E | 2024-10-31T12:21:31.109Z | 2024-11-06T14:27:28.397Z |
5431945 | 5431945 | 20241029021955_n2EZE | CA000E | 2024-10-31T12:20:51.989Z | 2024-11-06T14:27:25.593Z |
5431487 | 5431487 | 20241029011945_J47nj | CA000E | 2024-10-31T12:20:13.304Z | 2024-11-06T14:27:23.912Z |
5431430 | 5431430 | 20241029011123_zPkyE | CA000E | 2024-10-31T12:20:07.930Z | 2024-11-06T14:27:23.722Z |
5431389 | 5431389 | 20241029010353_gHxMW | CA000E | 2024-10-31T12:20:04.430Z | 2024-11-06T14:27:23.399Z |
5431317 | 5431317 | 20241029005446_lCNDh | CA000E | 2024-10-31T12:19:54.496Z | 2024-11-06T14:27:23.276Z |
5431171 | 5431171 | 20241029003842_AkYn4 | CA000E | 2024-10-31T12:19:42.563Z | 2024-11-06T14:27:22.907Z |
5431066 | 5431066 | 20241029002219_9UE3z | CA000E | 2024-10-31T12:19:33.026Z | 2024-11-06T14:27:22.637Z |
5430828 | 5430828 | 20241028234635_3QmtF | CA000E | 2024-10-31T12:19:07.478Z | 2024-11-06T14:27:21.735Z |
5421486 | 5421486 | 20241028064416_T9urH | CA000E | 2024-10-30T12:19:58.901Z | 2024-11-05T14:27:18.823Z |
5421458 | 5421458 | 20241028064132_MnSxK | CA000E | 2024-10-30T12:19:57.013Z | 2024-11-05T14:27:18.758Z |
5421111 | 5421111 | 20241028043810_JIKVp | CA000E | 2024-10-30T12:19:36.240Z | 2024-11-05T14:27:17.351Z |
5421105 | 5421105 | 20241028043517_Dqq30 | CA000E | 2024-10-30T12:19:35.993Z | 2024-11-05T14:27:17.348Z |
5421097 | 5421097 | 20241028043043_aMoXd | CA000E | 2024-10-30T12:19:35.668Z | 2024-11-05T14:27:17.329Z |
5419969 | 5419969 | 20241028013754_Tn2qu | CA000E | 2024-10-30T12:18:10.606Z | 2024-11-05T14:27:14.252Z |
5419965 | 5419965 | 20241028013750_kz4QB | CA000E | 2024-10-30T12:18:10.148Z | 2024-11-05T14:27:14.240Z |
5419954 | 5419954 | 20241028013658_bDWVa | CA000E | 2024-10-30T12:18:09.239Z | 2024-11-05T14:27:14.197Z |
5419503 | 5419503 | 20241028001142_weP73 | CA000E | 2024-10-30T12:17:30.513Z | 2024-11-05T14:27:13.273Z |
5419379 | 5419379 | 20241027234611_RY2F3 | CA000E | 2024-10-30T12:17:23.793Z | 2024-11-05T14:27:12.977Z |
5413567 | 5413567 | 20241028102233_JSaiM | CA000E | 2024-10-30T12:03:30.459Z | 2024-11-06T14:27:06.594Z |
5413555 | 5413555 | 20241028102019_X2Umb | CA000E | 2024-10-30T12:03:28.618Z | 2024-11-06T14:27:06.490Z |
5413367 | 5413367 | 20241028094616_JL5rj | CA000E | 2024-10-30T12:02:50.816Z | 2024-11-06T14:27:05.441Z |
5413281 | 5413281 | 20241028092938_AqLJO | CA000E | 2024-10-30T12:02:32.292Z | 2024-11-06T14:27:05.157Z |
5413173 | 5413173 | 20241028090346_sTpfg | CA000E | 2024-10-30T12:02:09.781Z | 2024-11-06T14:27:04.570Z |
5413089 | 5413089 | 20241028084859_PWZ3h | CA000E | 2024-10-30T12:01:48.211Z | 2024-11-06T14:27:04.387Z |
5412971 | 5412971 | 20241028082749_GRQLV | CA000E | 2024-10-30T12:01:24.557Z | 2024-11-06T14:27:03.867Z |
5412779 | 5412779 | 20241028073138_HZJxt | CA000E | 2024-10-30T12:00:38.673Z | 2024-11-06T14:27:02.543Z |
5405969 | 5405969 | 20241027011119_Luh3d | CA000E | 2024-10-29T12:13:42.045Z | 2024-11-04T14:28:54.786Z |
5388911 | 5388911 | 20241025063128_7ko4D | CA000E | 2024-10-27T12:22:35.508Z | 2024-11-02T12:28:35.139Z |
5388710 | 5388710 | 20241025055754_G1jjz | CA000E | 2024-10-27T12:22:27.744Z | 2024-11-02T12:28:34.810Z |
5388679 | 5388679 | 20241025055217_NiWXA | CA000E | 2024-10-27T12:22:27.041Z | 2024-11-02T12:28:34.787Z |
5388330 | 5388330 | 20241025043106_y2RMV | CA000E | 2024-10-27T12:22:10.117Z | 2024-11-02T12:28:33.962Z |
5388282 | 5388282 | 20241025042442_PvxK0 | CA000E | 2024-10-27T12:22:07.944Z | 2024-11-02T12:28:33.909Z |
5386693 | 5386693 | 20241025011531_dx92q | CA000E | 2024-10-27T12:20:19.422Z | 2024-11-02T12:28:31.495Z |
5386649 | 5386649 | 20241025010830_l22fP | CA000E | 2024-10-27T12:20:13.710Z | 2024-11-02T12:28:31.411Z |
5386425 | 5386425 | 20241025003933_eiL44 | CA000E | 2024-10-27T12:20:04.264Z | 2024-11-02T12:28:31.246Z |
5386415 | 5386415 | 20241025003814_TRhKS | CA000E | 2024-10-27T12:20:03.965Z | 2024-11-02T12:28:31.209Z |
5379953 | 5379953 | 20241025094129_PXcjK | CA000E | 2024-10-27T12:04:36.309Z | 2024-11-03T14:27:09.194Z |
5379452 | 5379452 | 20241025083656_wW0xz | CA000E | 2024-10-27T12:03:03.164Z | 2024-11-03T14:27:07.655Z |
5379362 | 5379362 | 20241025082549_OJrYG | CA000E | 2024-10-27T12:02:50.001Z | 2024-11-03T14:27:06.834Z |
5379249 | 5379249 | 20241025081108_U8CvM | CA000E | 2024-10-27T12:02:28.798Z | 2024-11-03T14:27:06.614Z |
5379203 | 5379203 | 20241025080546_IET8A | CA000E | 2024-10-27T12:02:18.676Z | 2024-11-03T14:27:06.491Z |
5368703 | 5368703 | 20241024095945_gmja2 | CA000E | 2024-10-26T12:04:29.376Z | 2024-11-02T12:28:16.430Z |
5368663 | 5368663 | 20241024095509_3tUB6 | CA000E | 2024-10-26T12:04:20.362Z | 2024-11-02T12:28:16.273Z |
5368647 | 5368647 | 20241024095352_fKuLx | CA000E | 2024-10-26T12:04:16.795Z | 2024-11-02T12:28:16.207Z |
5368502 | 5368502 | 20241024093707_TY31M | CA000E | 2024-10-26T12:03:42.932Z | 2024-11-02T12:28:15.722Z |
5368379 | 5368379 | 20241024091500_0G1u3 | CA000E | 2024-10-26T12:03:24.070Z | 2024-11-02T12:28:15.489Z |
5368319 | 5368319 | 20241024090431_2LFd2 | CA000E | 2024-10-26T12:03:07.887Z | 2024-11-02T12:28:15.370Z |
5368293 | 5368293 | 20241024085950_yb45K | CA000E | 2024-10-26T12:03:01.861Z | 2024-11-02T12:28:15.344Z |
5368281 | 5368281 | 20241024085751_44FYl | CA000E | 2024-10-26T12:02:59.901Z | 2024-11-02T12:28:15.293Z |
5367994 | 5367994 | 20241024081258_hoQf2 | CA000E | 2024-10-26T12:02:13.618Z | 2024-11-02T12:28:14.856Z |
5367916 | 5367916 | 20241024080407_ikxAj | CA000E | 2024-10-26T12:02:01.978Z | 2024-11-02T12:28:14.778Z |
5367710 | 5367710 | 20241024072640_qCfgs | CA000E | 2024-10-26T12:01:20.600Z | 2024-11-02T12:28:14.367Z |
5367571 | 5367571 | 20241024070512_300yb | CA000E | 2024-10-26T12:00:50.427Z | 2024-11-02T12:28:14.122Z |
5367116 | 5367116 | 20241023052945_KFXkE | CA000E | 2024-10-25T12:21:46.251Z | 2024-10-31T12:30:11.223Z |
5366660 | 5366660 | 20241023032220_WeYap | CA000E | 2024-10-25T12:21:24.411Z | 2024-10-31T12:30:07.384Z |
5366650 | 5366650 | 20241023031807_7IZAY | CA000E | 2024-10-25T12:21:23.220Z | 2024-10-31T12:30:07.347Z |
5357665 | 5357665 | 20241023095725_teAVr | CA000E | 2024-10-25T12:04:12.740Z | 2024-11-01T12:26:40.931Z |
5357629 | 5357629 | 20241023095219_hOtbI | CA000E | 2024-10-25T12:04:08.447Z | 2024-11-01T12:26:40.826Z |
5357267 | 5357267 | 20241023090710_vFI44 | CA000E | 2024-10-25T12:03:05.613Z | 2024-11-01T12:26:39.380Z |
5357246 | 5357246 | 20241023090605_yeDPu | CA000E | 2024-10-25T12:03:02.636Z | 2024-11-01T12:26:39.341Z |
5356983 | 5356983 | 20241023082812_5RyGq | CA000E | 2024-10-25T12:02:13.017Z | 2024-11-01T12:26:38.029Z |
5356885 | 5356885 | 20241023081156_eZtDn | CA000E | 2024-10-25T12:01:58.118Z | 2024-11-01T12:26:37.680Z |
5356831 | 5356831 | 20241023080357_49UFS | CA000E | 2024-10-25T12:01:49.193Z | 2024-11-01T12:26:37.314Z |
5356686 | 5356686 | 20241023073919_Q4dp3 | CA000E | 2024-10-25T12:01:20.470Z | 2024-11-01T12:26:36.622Z |
5356476 | 5356476 | 20241023070019_ZrpSd | CA000E | 2024-10-25T12:00:40.525Z | 2024-11-01T12:26:35.805Z |
5356447 | 5356447 | 20241023065232_W9qhY | CA000E | 2024-10-25T12:00:35.216Z | 2024-11-01T12:26:35.771Z |
5345531 | 5345531 | 20241022061835_s1Nrd | CA000E | 2024-10-23T12:19:24.885Z | 2024-10-30T12:26:52.981Z |
5345486 | 5345486 | 20241022060417_tkXfK | CA000E | 2024-10-23T12:19:23.049Z | 2024-10-30T12:26:52.840Z |
5345418 | 5345418 | 20241022054827_1KdXV | CA000E | 2024-10-23T12:19:19.613Z | 2024-10-30T12:26:52.654Z |
5344961 | 5344961 | 20241022050301_MP753 | CA000E | 2024-10-23T12:18:59.804Z | 2024-10-30T12:26:52.027Z |
5344801 | 5344801 | 20241022044628_O11wv | CA000E | 2024-10-23T12:18:51.191Z | 2024-10-30T12:26:51.698Z |
5343489 | 5343489 | 20241022033146_XQ6qH | CA000E | 2024-10-23T12:17:48.064Z | 2024-10-30T12:26:50.100Z |
5343469 | 5343469 | 20241022033044_Exy5R | CA000E | 2024-10-23T12:17:47.463Z | 2024-10-30T12:26:50.047Z |
5343418 | 5343418 | 20241022032847_zukYI | CA000E | 2024-10-23T12:17:46.109Z | 2024-10-30T12:26:50.013Z |
5339650 | 5339650 | 20241021230116_l2Ce3 | CA000E | 2024-10-23T12:13:29.260Z | 2024-10-30T12:26:44.681Z |
5337201 | 5337201 | 20241022094214_o9TE2 | CA000E | 2024-10-23T12:04:31.178Z | 2024-10-31T12:29:43.809Z |
5336988 | 5336988 | 20241022091949_GU37l | CA000E | 2024-10-23T12:03:54.294Z | 2024-10-31T12:29:43.028Z |
5335732 | 5335732 | 20241022063630_ajT33 | CA000E | 2024-10-23T12:00:22.946Z | 2024-10-31T12:29:37.412Z |
5335627 | 5335627 | 20241021061054_yUl9x | CA000E | 2024-10-22T12:18:22.192Z | 2024-10-29T12:26:36.546Z |
5335380 | 5335380 | 20241021045128_7uXJm | CA000E | 2024-10-22T12:18:10.393Z | 2024-10-29T12:26:36.226Z |
5335094 | 5335094 | 20241021035408_ClJiP | CA000E | 2024-10-22T12:17:57.422Z | 2024-10-29T12:26:35.961Z |
5335085 | 5335085 | 20241021035335_wI3hN | CA000E | 2024-10-22T12:17:55.906Z | 2024-10-29T12:26:35.940Z |
5334814 | 5334814 | 20241021031825_64ax1 | CA000E | 2024-10-22T12:17:29.126Z | 2024-10-29T12:26:35.661Z |
5328678 | 5328678 | 20241021082802_hbxQs | CA000E | 2024-10-22T12:02:09.291Z | 2024-10-30T12:26:32.697Z |
5328648 | 5328648 | 20241021082346_9tGnU | CA000E | 2024-10-22T12:02:05.471Z | 2024-10-30T12:26:32.659Z |
5328366 | 5328366 | 20241021074215_26MKI | CA000E | 2024-10-22T12:01:13.465Z | 2024-10-30T12:26:32.026Z |
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);