participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "BE000C" 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 |
---|---|---|---|---|---|
5569952 | 5569952 | 20241120180628_mQ6lV | BE000C | 2024-11-22T14:14:39.670Z | 2024-11-22T14:19:21.835Z |
5569735 | 5569735 | 20241120170920_TmeXw | BE000C | 2024-11-22T14:14:01.620Z | 2024-11-22T14:19:21.794Z |
5569732 | 5569732 | 20241120170607_x2iED | BE000C | 2024-11-22T14:14:00.471Z | 2024-11-22T14:19:21.791Z |
5565055 | 5565055 | 20241120034720_N99NV | BE000C | 2024-11-21T14:18:25.307Z | 2024-11-22T14:21:40.674Z |
5558275 | 5558275 | 20241120055138_bj3zo | BE000C | 2024-11-21T14:02:54.728Z | 2024-11-22T14:19:21.203Z |
5557995 | 5557995 | 20241120052921_Yxt3h | BE000C | 2024-11-21T14:02:13.958Z | 2024-11-22T14:19:21.158Z |
5557973 | 5557973 | 20241120052732_9bYbM | BE000C | 2024-11-21T14:02:11.257Z | 2024-11-22T14:19:21.155Z |
5557609 | 5557609 | 20241120050139_J7bKk | BE000C | 2024-11-21T14:01:22.000Z | 2024-11-22T14:19:21.100Z |
5557537 | 5557537 | 20241120045406_5jqaA | BE000C | 2024-11-21T14:01:07.127Z | 2024-11-22T14:19:21.087Z |
5552592 | 5552592 | 20241117190635_yR1z8 | BE000C | 2024-11-19T14:08:43.504Z | 2024-11-22T14:22:42.591Z |
5527837 | 5527837 | 20241111184135_5NI7A | BE000C | 2024-11-13T14:09:24.855Z | 2024-11-20T14:25:21.957Z |
5527824 | 5527824 | 20241111184001_t34L2 | BE000C | 2024-11-13T14:09:20.455Z | 2024-11-20T14:25:21.662Z |
5489548 | 5489548 | 20241105191500_JpUDT | BE000C | 2024-11-07T14:12:11.366Z | 2024-11-14T14:23:13.727Z |
5489283 | 5489283 | 20241105182644_2nHPj | BE000C | 2024-11-07T14:11:50.021Z | 2024-11-14T14:23:11.750Z |
5489274 | 5489274 | 20241105182002_WaKFT | BE000C | 2024-11-07T14:11:48.069Z | 2024-11-14T14:23:11.634Z |
5489212 | 5489212 | 20241105180822_CQFcz | BE000C | 2024-11-07T14:11:29.091Z | 2024-11-14T14:23:10.999Z |
5489063 | 5489063 | 20241105174259_wQoaX | BE000C | 2024-11-07T14:11:14.873Z | 2024-11-14T14:23:09.791Z |
5489028 | 5489028 | 20241105173805_uckJt | BE000C | 2024-11-07T14:11:12.473Z | 2024-11-14T14:23:09.616Z |
5489026 | 5489026 | 20241105173746_3xorw | BE000C | 2024-11-07T14:11:12.310Z | 2024-11-14T14:23:09.491Z |
5489000 | 5489000 | 20241105173156_iMgT2 | BE000C | 2024-11-07T14:11:09.599Z | 2024-11-14T14:23:09.334Z |
5483514 | 5483514 | 20241105004957_gXB4j | BE000C | 2024-11-06T14:15:26.028Z | 2024-11-13T14:27:36.347Z |
5483492 | 5483492 | 20241105004513_WWZab | BE000C | 2024-11-06T14:15:25.285Z | 2024-11-13T14:27:36.333Z |
5483482 | 5483482 | 20241105004451_08TzB | BE000C | 2024-11-06T14:15:24.644Z | 2024-11-13T14:27:36.329Z |
5483250 | 5483250 | 20241105001903_f7CsY | BE000C | 2024-11-06T14:14:49.639Z | 2024-11-13T14:27:35.919Z |
5483211 | 5483211 | 20241105001325_z5tiU | BE000C | 2024-11-06T14:14:47.817Z | 2024-11-13T14:27:35.857Z |
5483128 | 5483128 | 20241105000105_Awj1h | BE000C | 2024-11-06T14:14:41.218Z | 2024-11-13T14:27:35.751Z |
5483079 | 5483079 | 20241104235524_uUlq0 | BE000C | 2024-11-06T14:14:38.762Z | 2024-11-13T14:27:35.680Z |
5482839 | 5482839 | 20241104232114_8zJrd | BE000C | 2024-11-06T14:14:09.525Z | 2024-11-13T14:27:35.250Z |
5482832 | 5482832 | 20241104232021_FTLwo | BE000C | 2024-11-06T14:14:08.588Z | 2024-11-13T14:27:35.239Z |
5482809 | 5482809 | 20241104231619_Hdno2 | BE000C | 2024-11-06T14:14:04.503Z | 2024-11-13T14:27:35.202Z |
5482744 | 5482744 | 20241104230951_CRzrh | BE000C | 2024-11-06T14:13:49.412Z | 2024-11-13T14:27:35.077Z |
5482725 | 5482725 | 20241104230823_ra6Z2 | BE000C | 2024-11-06T14:13:43.550Z | 2024-11-13T14:27:35.060Z |
5482678 | 5482678 | 20241104230021_WyZSe | BE000C | 2024-11-06T14:13:35.665Z | 2024-11-13T14:27:35.014Z |
5482641 | 5482641 | 20241104225308_Aqox0 | BE000C | 2024-11-06T14:13:29.526Z | 2024-11-13T14:27:34.950Z |
5482589 | 5482589 | 20241104224625_t72Az | BE000C | 2024-11-06T14:13:25.006Z | 2024-11-13T14:27:34.884Z |
5482407 | 5482407 | 20241104220807_KSP8v | BE000C | 2024-11-06T14:13:08.289Z | 2024-11-13T14:27:34.489Z |
5482341 | 5482341 | 20241104215230_c3ve2 | BE000C | 2024-11-06T14:13:03.510Z | 2024-11-13T14:27:34.377Z |
5482311 | 5482311 | 20241104214727_OCClX | BE000C | 2024-11-06T14:12:56.633Z | 2024-11-13T14:27:34.327Z |
5482293 | 5482293 | 20241104214531_Js4P2 | BE000C | 2024-11-06T14:12:50.983Z | 2024-11-13T14:27:34.304Z |
5482193 | 5482193 | 20241104212344_w5wNO | BE000C | 2024-11-06T14:12:34.628Z | 2024-11-13T14:27:34.098Z |
5482178 | 5482178 | 20241104212143_K8tgB | BE000C | 2024-11-06T14:12:31.943Z | 2024-11-13T14:27:34.087Z |
5482120 | 5482120 | 20241104211004_ZWS7P | BE000C | 2024-11-06T14:12:25.453Z | 2024-11-13T14:27:33.925Z |
5482070 | 5482070 | 20241104210011_2Xztm | BE000C | 2024-11-06T14:12:20.377Z | 2024-11-13T14:27:33.838Z |
5482030 | 5482030 | 20241104205242_uCZve | BE000C | 2024-11-06T14:12:16.006Z | 2024-11-13T14:27:33.735Z |
5482020 | 5482020 | 20241104205029_4AeLn | BE000C | 2024-11-06T14:12:15.275Z | 2024-11-13T14:27:33.725Z |
5481949 | 5481949 | 20241104202744_50x2D | BE000C | 2024-11-06T14:11:59.116Z | 2024-11-13T14:27:33.564Z |
5481928 | 5481928 | 20241104202311_VMbyf | BE000C | 2024-11-06T14:11:52.895Z | 2024-11-13T14:27:33.471Z |
5481891 | 5481891 | 20241104201113_AODmP | BE000C | 2024-11-06T14:11:48.031Z | 2024-11-13T14:27:33.409Z |
5481796 | 5481796 | 20241104194521_UEDCN | BE000C | 2024-11-06T14:11:35.812Z | 2024-11-13T14:27:32.792Z |
5481619 | 5481619 | 20241104185132_GqnVc | BE000C | 2024-11-06T14:10:58.684Z | 2024-11-13T14:27:31.033Z |
5481613 | 5481613 | 20241104185025_ekmQd | BE000C | 2024-11-06T14:10:56.537Z | 2024-11-13T14:27:30.961Z |
5481593 | 5481593 | 20241104184301_ZWqJZ | BE000C | 2024-11-06T14:10:53.957Z | 2024-11-13T14:27:30.826Z |
5481582 | 5481582 | 20241104183935_WeMef | BE000C | 2024-11-06T14:10:52.847Z | 2024-11-13T14:27:30.596Z |
5477915 | 5477915 | 20241104025307_ajpOl | BE000C | 2024-11-05T14:17:36.344Z | 2024-11-12T14:28:13.234Z |
5477749 | 5477749 | 20241104023216_iC1JP | BE000C | 2024-11-05T14:17:22.212Z | 2024-11-12T14:28:12.683Z |
5477740 | 5477740 | 20241104023037_3QkFm | BE000C | 2024-11-05T14:17:20.956Z | 2024-11-12T14:28:12.565Z |
5477718 | 5477718 | 20241104022543_EYIMu | BE000C | 2024-11-05T14:17:19.055Z | 2024-11-12T14:28:12.515Z |
5477652 | 5477652 | 20241104021719_Rm3K1 | BE000C | 2024-11-05T14:17:12.879Z | 2024-11-12T14:28:12.239Z |
5477608 | 5477608 | 20241104021301_KRc8J | BE000C | 2024-11-05T14:17:08.995Z | 2024-11-12T14:28:12.140Z |
5477600 | 5477600 | 20241104021219_X9mGv | BE000C | 2024-11-05T14:17:08.166Z | 2024-11-12T14:28:12.125Z |
5477578 | 5477578 | 20241104021028_dGBzE | BE000C | 2024-11-05T14:17:04.877Z | 2024-11-12T14:28:12.084Z |
5477562 | 5477562 | 20241104020832_1VYLC | BE000C | 2024-11-05T14:17:03.575Z | 2024-11-12T14:28:11.994Z |
5477460 | 5477460 | 20241104015841_KKt7V | BE000C | 2024-11-05T14:16:54.953Z | 2024-11-12T14:28:11.810Z |
5477453 | 5477453 | 20241104015634_gi8mE | BE000C | 2024-11-05T14:16:54.486Z | 2024-11-12T14:28:11.792Z |
5477390 | 5477390 | 20241104014709_Ke5o1 | BE000C | 2024-11-05T14:16:49.374Z | 2024-11-12T14:28:11.183Z |
5477364 | 5477364 | 20241104014212_5lL5o | BE000C | 2024-11-05T14:16:46.807Z | 2024-11-12T14:28:11.004Z |
5477230 | 5477230 | 20241104012226_x8i27 | BE000C | 2024-11-05T14:16:33.751Z | 2024-11-12T14:28:10.421Z |
5477167 | 5477167 | 20241104011031_ddap2 | BE000C | 2024-11-05T14:16:28.447Z | 2024-11-12T14:28:09.928Z |
5477159 | 5477159 | 20241104010937_1LLI3 | BE000C | 2024-11-05T14:16:28.070Z | 2024-11-12T14:28:09.911Z |
5476216 | 5476216 | 20241103224625_F62k3 | BE000C | 2024-11-05T14:14:53.452Z | 2024-11-12T14:28:03.863Z |
5476211 | 5476211 | 20241103224451_D6Ma2 | BE000C | 2024-11-05T14:14:52.305Z | 2024-11-12T14:28:03.858Z |
5476199 | 5476199 | 20241103224101_9OhFd | BE000C | 2024-11-05T14:14:51.291Z | 2024-11-12T14:28:03.800Z |
5476106 | 5476106 | 20241103222628_8pt3B | BE000C | 2024-11-05T14:14:45.654Z | 2024-11-12T14:28:02.992Z |
5475887 | 5475887 | 20241103214538_MTpD2 | BE000C | 2024-11-05T14:14:30.552Z | 2024-11-12T14:28:01.733Z |
5475834 | 5475834 | 20241103213150_gpsVI | BE000C | 2024-11-05T14:14:20.511Z | 2024-11-12T14:28:01.280Z |
5475729 | 5475729 | 20241103211034_jP5df | BE000C | 2024-11-05T14:14:03.740Z | 2024-11-12T14:28:00.749Z |
5475718 | 5475718 | 20241103210920_hvWY0 | BE000C | 2024-11-05T14:14:03.246Z | 2024-11-12T14:28:00.728Z |
5475653 | 5475653 | 20241103205517_gfGvM | BE000C | 2024-11-05T14:13:55.990Z | 2024-11-12T14:28:00.165Z |
5475542 | 5475542 | 20241103203157_3mjyV | BE000C | 2024-11-05T14:13:47.273Z | 2024-11-12T14:27:59.653Z |
5475170 | 5475170 | 20241103192245_Xz2UN | BE000C | 2024-11-05T14:12:38.702Z | 2024-11-12T14:27:57.406Z |
5475087 | 5475087 | 20241103190354_mhAD3 | BE000C | 2024-11-05T14:12:30.509Z | 2024-11-12T14:27:57.055Z |
5475016 | 5475016 | 20241103185147_Ku26U | BE000C | 2024-11-05T14:12:24.715Z | 2024-11-12T14:27:56.351Z |
5474911 | 5474911 | 20241103183618_bxQO0 | BE000C | 2024-11-05T14:12:15.871Z | 2024-11-12T14:27:55.444Z |
5474824 | 5474824 | 20241103182208_FYqrp | BE000C | 2024-11-05T14:12:08.019Z | 2024-11-12T14:27:54.941Z |
5474779 | 5474779 | 20241103181443_x0b8b | BE000C | 2024-11-05T14:11:57.412Z | 2024-11-12T14:27:54.631Z |
5474714 | 5474714 | 20241103180339_vgNNt | BE000C | 2024-11-05T14:11:41.798Z | 2024-11-12T14:27:54.019Z |
5454761 | 5454761 | 20241031050944_ye9yZ | BE000C | 2024-11-02T12:23:20.901Z | 2024-11-08T14:23:25.515Z |
5454682 | 5454682 | 20241031045500_xYOHl | BE000C | 2024-11-02T12:23:16.810Z | 2024-11-08T14:23:24.750Z |
5454276 | 5454276 | 20241031040431_UTlbo | BE000C | 2024-11-02T12:22:57.469Z | 2024-11-08T14:23:21.973Z |
5454239 | 5454239 | 20241031040121_2I4ki | BE000C | 2024-11-02T12:22:55.679Z | 2024-11-08T14:23:21.664Z |
5454218 | 5454218 | 20241031035810_VnTEh | BE000C | 2024-11-02T12:22:55.180Z | 2024-11-08T14:23:21.430Z |
5454097 | 5454097 | 20241031034128_9oMbh | BE000C | 2024-11-02T12:22:50.723Z | 2024-11-08T14:23:20.446Z |
5454034 | 5454034 | 20241031033322_6hDXA | BE000C | 2024-11-02T12:22:49.071Z | 2024-11-08T14:23:20.073Z |
5453961 | 5453961 | 20241031032311_R0woz | BE000C | 2024-11-02T12:22:46.235Z | 2024-11-08T14:23:19.791Z |
5453957 | 5453957 | 20241031032153_KGWVC | BE000C | 2024-11-02T12:22:45.833Z | 2024-11-08T14:23:19.727Z |
5453881 | 5453881 | 20241031031223_wuOG1 | BE000C | 2024-11-02T12:22:44.211Z | 2024-11-08T14:23:19.602Z |
5453752 | 5453752 | 20241031025621_ePIm1 | BE000C | 2024-11-02T12:22:41.918Z | 2024-11-08T14:23:18.980Z |
5453600 | 5453600 | 20241031022901_IoM9T | BE000C | 2024-11-02T12:22:36.831Z | 2024-11-08T14:23:18.174Z |
5453543 | 5453543 | 20241031022201_S2hxf | BE000C | 2024-11-02T12:22:35.742Z | 2024-11-08T14:23:18.030Z |
5453470 | 5453470 | 20241031021454_QtYYM | BE000C | 2024-11-02T12:22:34.317Z | 2024-11-08T14:23:17.566Z |
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);