participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,696 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 |
---|---|---|---|---|---|
5583959 | 5583959 | 20241117090258_7hWOR | CA000E | 2024-11-23T14:25:15.578Z | 2024-11-23T14:25:15.578Z |
5562470 | 5562470 | 20241119234237_55osE | CA000E | 2024-11-21T14:14:55.933Z | 2024-11-23T14:24:30.118Z |
5562255 | 5562255 | 20241119231727_qFn4T | CA000E | 2024-11-21T14:14:37.931Z | 2024-11-23T14:24:29.091Z |
5554592 | 5554592 | 20241119094352_Fapdw | CA000E | 2024-11-20T14:02:34.134Z | 2024-11-23T14:24:06.098Z |
5554416 | 5554416 | 20241119085104_rZ9sE | CA000E | 2024-11-20T14:01:58.968Z | 2024-11-23T14:24:03.202Z |
5554374 | 5554374 | 20241119083707_kq1wo | CA000E | 2024-11-20T14:01:48.227Z | 2024-11-23T14:24:02.668Z |
5554267 | 5554267 | 20241119073716_Rt3Rl | CA000E | 2024-11-20T14:01:20.683Z | 2024-11-23T14:24:00.913Z |
5546423 | 5546423 | 20241117105227_F4T2Y | CA000E | 2024-11-18T14:03:04.849Z | 2024-11-23T14:25:17.536Z |
5546085 | 5546085 | 20241117090647_jc0I6 | CA000E | 2024-11-18T14:01:58.889Z | 2024-11-23T14:25:15.675Z |
5545898 | 5545898 | 20241117074320_V3GOb | CA000E | 2024-11-18T14:01:20.265Z | 2024-11-23T14:25:14.783Z |
5545896 | 5545896 | 20241117074302_UIU5V | CA000E | 2024-11-18T14:01:19.906Z | 2024-11-23T14:25:14.752Z |
5545798 | 5545798 | 20241117070300_X24vB | CA000E | 2024-11-18T14:00:59.240Z | 2024-11-23T14:25:13.852Z |
5545774 | 5545774 | 20241117065028_3hHIN | CA000E | 2024-11-18T14:00:55.701Z | 2024-11-23T14:25:13.597Z |
5545741 | 5545741 | 20241117063530_hnYMO | CA000E | 2024-11-18T14:00:50.089Z | 2024-11-23T14:25:13.360Z |
5543889 | 5543889 | 20241115041333_R99iE | CA000E | 2024-11-16T14:07:36.744Z | 2024-11-23T14:26:21.906Z |
5543772 | 5543772 | 20241115032710_V0Lw3 | CA000E | 2024-11-16T14:07:12.217Z | 2024-11-23T14:26:21.144Z |
5543603 | 5543603 | 20241115022542_0bsXM | CA000E | 2024-11-16T14:06:54.894Z | 2024-11-23T14:26:20.013Z |
5543525 | 5543525 | 20241115015638_4yKE0 | CA000E | 2024-11-16T14:06:35.093Z | 2024-11-23T14:26:19.472Z |
5542491 | 5542491 | 20241115101229_KdADB | CA000E | 2024-11-16T14:01:30.310Z | 2024-11-23T14:25:48.624Z |
5542434 | 5542434 | 20241115094036_21zYF | CA000E | 2024-11-16T14:01:16.235Z | 2024-11-23T14:25:48.124Z |
5542402 | 5542402 | 20241115091422_l1VUZ | CA000E | 2024-11-16T14:01:09.858Z | 2024-11-23T14:25:47.858Z |
5541310 | 5541310 | 20241114001031_mGhV2 | CA000E | 2024-11-15T14:07:25.632Z | 2024-11-22T14:24:18.009Z |
5541265 | 5541265 | 20241113225932_3o2Yh | CA000E | 2024-11-15T14:07:17.438Z | 2024-11-22T14:24:17.620Z |
5540244 | 5540244 | 20241114102805_i2zdc | CA000E | 2024-11-15T14:03:10.820Z | 2024-11-23T14:26:10.269Z |
5539788 | 5539788 | 20241114090012_bAS3N | CA000E | 2024-11-15T14:01:59.342Z | 2024-11-23T14:26:06.762Z |
5539677 | 5539677 | 20241114083441_JEAIX | CA000E | 2024-11-15T14:01:40.261Z | 2024-11-23T14:26:05.619Z |
5539675 | 5539675 | 20241114083432_f2Oip | CA000E | 2024-11-15T14:01:39.968Z | 2024-11-23T14:26:05.605Z |
5539569 | 5539569 | 20241114075646_uyd2F | CA000E | 2024-11-15T14:01:26.731Z | 2024-11-23T14:26:04.685Z |
5539472 | 5539472 | 20241114071756_pyWRZ | CA000E | 2024-11-15T14:01:05.486Z | 2024-11-23T14:26:03.698Z |
5539432 | 5539432 | 20241114070615_LdnkS | CA000E | 2024-11-15T14:00:59.777Z | 2024-11-23T14:26:03.386Z |
5533728 | 5533728 | 20241113095649_1Egpq | CA000E | 2024-11-14T14:02:43.053Z | 2024-11-22T14:24:10.983Z |
5533552 | 5533552 | 20241113092029_QY36i | CA000E | 2024-11-14T14:02:23.505Z | 2024-11-22T14:24:10.092Z |
5533465 | 5533465 | 20241113090522_DhvBy | CA000E | 2024-11-14T14:02:03.971Z | 2024-11-22T14:24:09.482Z |
5533255 | 5533255 | 20241113080855_5iGYn | CA000E | 2024-11-14T14:01:36.696Z | 2024-11-22T14:24:07.805Z |
5533045 | 5533045 | 20241113065541_jICI1 | CA000E | 2024-11-14T14:00:59.953Z | 2024-11-22T14:24:06.828Z |
5532782 | 5532782 | 20241113055121_i4fh4 | CA000E | 2024-11-14T14:00:12.462Z | 2024-11-22T14:24:05.003Z |
5518092 | 5518092 | 20241110055856_9oNSP | CA000E | 2024-11-11T14:15:12.589Z | 2024-11-18T14:26:39.509Z |
5518055 | 5518055 | 20241110054901_6QeOp | CA000E | 2024-11-11T14:15:10.866Z | 2024-11-18T14:26:39.395Z |
5517812 | 5517812 | 20241110045126_jA2jd | CA000E | 2024-11-11T14:14:53.737Z | 2024-11-18T14:26:38.399Z |
5517579 | 5517579 | 20241110040345_AyCgN | CA000E | 2024-11-11T14:14:37.476Z | 2024-11-18T14:26:37.219Z |
5517293 | 5517293 | 20241110031939_1zsmK | CA000E | 2024-11-11T14:14:12.485Z | 2024-11-18T14:26:35.793Z |
5517284 | 5517284 | 20241110031901_9haDn | CA000E | 2024-11-11T14:14:12.118Z | 2024-11-18T14:26:35.783Z |
5517261 | 5517261 | 20241110031528_gnU5Q | CA000E | 2024-11-11T14:14:10.653Z | 2024-11-18T14:26:35.683Z |
5517188 | 5517188 | 20241110030028_277lT | CA000E | 2024-11-11T14:14:02.980Z | 2024-11-18T14:26:35.217Z |
5517016 | 5517016 | 20241110023426_bi8Rg | CA000E | 2024-11-11T14:13:43.669Z | 2024-11-18T14:26:34.212Z |
5516334 | 5516334 | 20241110004121_IcRLx | CA000E | 2024-11-11T14:12:47.129Z | 2024-11-18T14:26:30.711Z |
5516309 | 5516309 | 20241110003718_HUSst | CA000E | 2024-11-11T14:12:42.975Z | 2024-11-18T14:26:30.599Z |
5511680 | 5511680 | 20241110063733_v7Otb | CA000E | 2024-11-11T14:00:29.175Z | 2024-11-19T14:21:15.209Z |
5503933 | 5503933 | 20241108001755_0Mr3d | CA000E | 2024-11-09T14:13:52.149Z | 2024-11-16T14:28:13.899Z |
5496972 | 5496972 | 20241107022054_vCwm1 | CA000E | 2024-11-08T14:13:01.486Z | 2024-11-15T14:25:01.095Z |
5496753 | 5496753 | 20241107013020_TrqHU | CA000E | 2024-11-08T14:12:49.589Z | 2024-11-15T14:24:59.800Z |
5496599 | 5496599 | 20241107005959_eUgeQ | CA000E | 2024-11-08T14:12:30.635Z | 2024-11-15T14:24:58.739Z |
5496168 | 5496168 | 20241106231415_tqJMc | CA000E | 2024-11-08T14:11:41.544Z | 2024-11-15T14:24:55.802Z |
5492951 | 5492951 | 20241107102340_NTQiH | CA000E | 2024-11-08T14:02:37.417Z | 2024-11-16T14:27:31.136Z |
5478479 | 5478479 | 20241104041636_QIUbV | CA000E | 2024-11-05T14:18:24.683Z | 2024-11-12T14:28:15.562Z |
5478328 | 5478328 | 20241104035330_gN2YS | CA000E | 2024-11-05T14:18:13.898Z | 2024-11-12T14:28:14.965Z |
5478155 | 5478155 | 20241104032856_hyx1I | CA000E | 2024-11-05T14:17:59.697Z | 2024-11-12T14:28:14.462Z |
5470311 | 5470311 | 20241104065119_bqb1t | CA000E | 2024-11-05T14:00:11.901Z | 2024-11-13T14:27:21.686Z |
5464954 | 5464954 | 20241103100449_GYJ0s | CA000E | 2024-11-04T14:02:17.750Z | 2024-11-12T14:27:43.934Z |
5464938 | 5464938 | 20241103095708_NPSl1 | CA000E | 2024-11-04T14:02:14.915Z | 2024-11-12T14:27:43.908Z |
5464772 | 5464772 | 20241103090936_rzXzp | CA000E | 2024-11-04T14:01:37.765Z | 2024-11-12T14:27:43.189Z |
5464591 | 5464591 | 20241103082729_pi8JF | CA000E | 2024-11-04T14:01:03.113Z | 2024-11-12T14:27:42.630Z |
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 |
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);