participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,543 rows where station_code = "ES000V" 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 |
---|---|---|---|---|---|
5505273 | 5505273 | 20241108042223_ugia4 | ES000V | 2024-11-09T14:16:03.079Z | 2024-11-09T14:16:28.741Z |
5505080 | 5505080 | 20241108034954_YT17Q | ES000V | 2024-11-09T14:15:42.146Z | 2024-11-09T14:16:28.697Z |
5505013 | 5505013 | 20241108033411_1zDjC | ES000V | 2024-11-09T14:15:34.711Z | 2024-11-09T14:16:28.680Z |
5504725 | 5504725 | 20241108024704_YZ7bX | ES000V | 2024-11-09T14:15:06.970Z | 2024-11-09T14:16:28.610Z |
5504522 | 5504522 | 20241108021048_3BcOv | ES000V | 2024-11-09T14:14:47.924Z | 2024-11-09T14:16:28.560Z |
5504465 | 5504465 | 20241108020152_bv1Eu | ES000V | 2024-11-09T14:14:41.115Z | 2024-11-09T14:16:28.544Z |
5504450 | 5504450 | 20241108015919_lZjGL | ES000V | 2024-11-09T14:14:40.013Z | 2024-11-09T14:16:28.541Z |
5504355 | 5504355 | 20241108014536_brBu7 | ES000V | 2024-11-09T14:14:28.589Z | 2024-11-09T14:16:28.515Z |
5504259 | 5504259 | 20241108012159_oHlMM | ES000V | 2024-11-09T14:14:17.949Z | 2024-11-09T14:16:28.488Z |
5504216 | 5504216 | 20241108011726_mEfw9 | ES000V | 2024-11-09T14:14:14.548Z | 2024-11-09T14:16:28.478Z |
5503819 | 5503819 | 20241107235413_z3F6W | ES000V | 2024-11-09T14:13:46.080Z | 2024-11-09T14:16:28.355Z |
5503743 | 5503743 | 20241107234207_jNOiV | ES000V | 2024-11-09T14:13:41.979Z | 2024-11-09T14:16:28.336Z |
5503640 | 5503640 | 20241107230853_bP3yO | ES000V | 2024-11-09T14:13:28.134Z | 2024-11-09T14:16:28.309Z |
5503585 | 5503585 | 20241107225732_nH2WF | ES000V | 2024-11-09T14:13:20.374Z | 2024-11-09T14:16:28.295Z |
5491790 | 5491790 | 20241106051012_NO3Jd | ES000V | 2024-11-07T14:16:59.930Z | 2024-11-09T14:20:14.690Z |
5491129 | 5491129 | 20241106020433_TWiia | ES000V | 2024-11-07T14:15:21.369Z | 2024-11-09T14:20:04.282Z |
5491119 | 5491119 | 20241106020257_yIwWh | ES000V | 2024-11-07T14:15:19.726Z | 2024-11-09T14:20:04.123Z |
5491105 | 5491105 | 20241106020034_2aaxc | ES000V | 2024-11-07T14:15:19.183Z | 2024-11-09T14:20:04.008Z |
5490980 | 5490980 | 20241106012852_QT5IX | ES000V | 2024-11-07T14:15:09.720Z | 2024-11-09T14:20:02.588Z |
5490857 | 5490857 | 20241106005624_Ah533 | ES000V | 2024-11-07T14:15:00.283Z | 2024-11-09T14:20:00.458Z |
5490789 | 5490789 | 20241106003859_277Si | ES000V | 2024-11-07T14:14:55.886Z | 2024-11-09T14:19:59.571Z |
5470046 | 5470046 | 20241103051412_3psQ9 | ES000V | 2024-11-04T14:17:38.737Z | 2024-11-09T14:23:04.888Z |
5469958 | 5469958 | 20241103045030_SGJy5 | ES000V | 2024-11-04T14:17:26.704Z | 2024-11-09T14:23:04.422Z |
5469907 | 5469907 | 20241103044125_knqpD | ES000V | 2024-11-04T14:17:17.465Z | 2024-11-09T14:23:04.259Z |
5469642 | 5469642 | 20241103035449_wPPKr | ES000V | 2024-11-04T14:16:42.633Z | 2024-11-09T14:23:03.286Z |
5469572 | 5469572 | 20241103034522_F5XmT | ES000V | 2024-11-04T14:16:36.786Z | 2024-11-09T14:23:03.084Z |
5469447 | 5469447 | 20241103032847_u0y8k | ES000V | 2024-11-04T14:16:28.741Z | 2024-11-09T14:23:02.620Z |
5469368 | 5469368 | 20241103031817_Io9fp | ES000V | 2024-11-04T14:16:22.133Z | 2024-11-09T14:23:02.279Z |
5469255 | 5469255 | 20241103025635_2c2TW | ES000V | 2024-11-04T14:16:06.280Z | 2024-11-09T14:23:01.799Z |
5468900 | 5468900 | 20241103020643_4xLX5 | ES000V | 2024-11-04T14:15:12.377Z | 2024-11-09T14:23:00.261Z |
5468323 | 5468323 | 20241103001127_BHgq6 | ES000V | 2024-11-04T14:13:57.229Z | 2024-11-09T14:22:57.993Z |
5463556 | 5463556 | 20241102035951_7rHYa | ES000V | 2024-11-03T14:18:57.231Z | 2024-11-09T14:23:41.975Z |
5462831 | 5462831 | 20241102014153_HKpI4 | ES000V | 2024-11-03T14:18:06.832Z | 2024-11-09T14:23:36.450Z |
5462760 | 5462760 | 20241102012230_NJBJW | ES000V | 2024-11-03T14:18:03.578Z | 2024-11-09T14:23:36.045Z |
5462639 | 5462639 | 20241102005854_rb4hS | ES000V | 2024-11-03T14:17:49.832Z | 2024-11-09T14:23:34.918Z |
5462066 | 5462066 | 20241101225503_8fNZ3 | ES000V | 2024-11-03T14:16:55.329Z | 2024-11-09T14:23:32.336Z |
5454123 | 5454123 | 20241031034427_Q2qcU | ES000V | 2024-11-02T12:22:51.487Z | 2024-11-08T14:23:20.626Z |
5452872 | 5452872 | 20241101050915_yq3b9 | ES000V | 2024-11-02T12:19:30.834Z | 2024-11-09T14:24:35.163Z |
5452853 | 5452853 | 20241101050437_2LUEC | ES000V | 2024-11-02T12:19:29.871Z | 2024-11-09T14:24:34.874Z |
5452122 | 5452122 | 20241101020402_LBciF | ES000V | 2024-11-02T12:18:17.730Z | 2024-11-09T14:24:28.337Z |
5452036 | 5452036 | 20241101014802_mmebC | ES000V | 2024-11-02T12:18:12.972Z | 2024-11-09T14:24:27.666Z |
5452018 | 5452018 | 20241101014543_ztxPb | ES000V | 2024-11-02T12:18:11.969Z | 2024-11-09T14:24:27.632Z |
5452004 | 5452004 | 20241101014304_H7aOP | ES000V | 2024-11-02T12:18:10.495Z | 2024-11-09T14:24:27.555Z |
5451983 | 5451983 | 20241101014030_O0T3M | ES000V | 2024-11-02T12:18:09.541Z | 2024-11-09T14:24:27.485Z |
5451973 | 5451973 | 20241101013751_3WKnB | ES000V | 2024-11-02T12:18:09.103Z | 2024-11-09T14:24:27.250Z |
5451759 | 5451759 | 20241101005905_l3BWG | ES000V | 2024-11-02T12:17:55.701Z | 2024-11-09T14:24:25.309Z |
5451752 | 5451752 | 20241101005820_C0khJ | ES000V | 2024-11-02T12:17:55.360Z | 2024-11-09T14:24:25.296Z |
5451746 | 5451746 | 20241101005650_Osjy1 | ES000V | 2024-11-02T12:17:54.856Z | 2024-11-09T14:24:25.278Z |
5451717 | 5451717 | 20241101005241_RumJJ | ES000V | 2024-11-02T12:17:53.666Z | 2024-11-09T14:24:25.181Z |
5451664 | 5451664 | 20241101004118_tREHO | ES000V | 2024-11-02T12:17:46.643Z | 2024-11-09T14:24:24.913Z |
5451616 | 5451616 | 20241101003259_l00DZ | ES000V | 2024-11-02T12:17:40.838Z | 2024-11-09T14:24:24.472Z |
5451589 | 5451589 | 20241101002513_5GMKb | ES000V | 2024-11-02T12:17:38.385Z | 2024-11-09T14:24:24.294Z |
5451506 | 5451506 | 20241101000601_VazB2 | ES000V | 2024-11-02T12:17:21.514Z | 2024-11-09T14:24:23.953Z |
5451465 | 5451465 | 20241031235946_gMjKk | ES000V | 2024-11-02T12:17:13.208Z | 2024-11-09T14:24:23.727Z |
5451452 | 5451452 | 20241031235727_EPZsS | ES000V | 2024-11-02T12:17:11.431Z | 2024-11-09T14:24:23.682Z |
5451346 | 5451346 | 20241031233956_PYC3D | ES000V | 2024-11-02T12:16:56.986Z | 2024-11-09T14:24:23.112Z |
5439767 | 5439767 | 20241030202910_ET0IU | ES000V | 2024-11-01T12:14:26.494Z | 2024-11-08T14:23:05.553Z |
5439225 | 5439225 | 20241030192705_yyG7R | ES000V | 2024-11-01T12:13:19.213Z | 2024-11-08T14:23:02.723Z |
5432677 | 5432677 | 20241029041324_Brx4j | ES000V | 2024-10-31T12:21:30.903Z | 2024-11-06T14:27:28.363Z |
5432443 | 5432443 | 20241029033601_VhhP2 | ES000V | 2024-10-31T12:21:22.673Z | 2024-11-06T14:27:27.378Z |
5432317 | 5432317 | 20241029031330_Y3QoS | ES000V | 2024-10-31T12:21:17.658Z | 2024-11-06T14:27:26.649Z |
5432248 | 5432248 | 20241029030133_3Z6D7 | ES000V | 2024-10-31T12:21:15.122Z | 2024-11-06T14:27:26.362Z |
5432054 | 5432054 | 20241029023635_VC8X2 | ES000V | 2024-10-31T12:20:59.009Z | 2024-11-06T14:27:25.825Z |
5432013 | 5432013 | 20241029023012_QBV5H | ES000V | 2024-10-31T12:20:56.435Z | 2024-11-06T14:27:25.699Z |
5432000 | 5432000 | 20241029022857_TYAhS | ES000V | 2024-10-31T12:20:55.848Z | 2024-11-06T14:27:25.683Z |
5431755 | 5431755 | 20241029015445_SZS3a | ES000V | 2024-10-31T12:20:36.204Z | 2024-11-06T14:27:24.671Z |
5431714 | 5431714 | 20241029015107_eXsZm | ES000V | 2024-10-31T12:20:34.188Z | 2024-11-06T14:27:24.605Z |
5431612 | 5431612 | 20241029013737_Nf83k | ES000V | 2024-10-31T12:20:25.280Z | 2024-11-06T14:27:24.181Z |
5431545 | 5431545 | 20241029012815_hgMWa | ES000V | 2024-10-31T12:20:21.083Z | 2024-11-06T14:27:24.027Z |
5431312 | 5431312 | 20241029005412_3RpiY | ES000V | 2024-10-31T12:19:53.732Z | 2024-11-06T14:27:23.253Z |
5430934 | 5430934 | 20241029000531_Lqk3e | ES000V | 2024-10-31T12:19:19.442Z | 2024-11-06T14:27:22.282Z |
5418994 | 5418994 | 20241027224129_bsZ5X | ES000V | 2024-10-30T12:16:49.985Z | 2024-11-05T14:27:11.959Z |
5409126 | 5409126 | 20241027040141_KyVHH | ES000V | 2024-10-29T12:17:07.771Z | 2024-11-04T14:29:01.206Z |
5404098 | 5404098 | 20241026225724_TmdsC | ES000V | 2024-10-29T12:10:53.278Z | 2024-11-04T14:28:50.329Z |
5404033 | 5404033 | 20241026225413_yy4Mu | ES000V | 2024-10-29T12:10:49.264Z | 2024-11-04T14:28:50.258Z |
5247686 | 5247686 | 20241007030700_sq83F | ES000V | 2024-10-08T12:00:24.363Z | 2024-10-16T12:20:56.182Z |
5194943 | 5194943 | 20240930033722_wrNpm | ES000V | 2024-10-01T12:02:52.264Z | 2024-10-09T12:29:01.553Z |
5194893 | 5194893 | 20240930032341_BYELi | ES000V | 2024-10-01T12:02:31.334Z | 2024-10-09T12:29:01.359Z |
5194836 | 5194836 | 20240930030814_3OQvo | ES000V | 2024-10-01T12:02:21.094Z | 2024-10-09T12:29:01.106Z |
5194785 | 5194785 | 20240930025528_PHFHe | ES000V | 2024-10-01T12:02:13.205Z | 2024-10-09T12:29:00.960Z |
5194780 | 5194780 | 20240930025450_c3l3p | ES000V | 2024-10-01T12:02:12.557Z | 2024-10-09T12:29:00.950Z |
5194693 | 5194693 | 20240930023454_FySor | ES000V | 2024-10-01T12:01:44.906Z | 2024-10-09T12:29:00.674Z |
5194627 | 5194627 | 20240930020535_igB8s | ES000V | 2024-10-01T12:01:32.950Z | 2024-10-09T12:29:00.423Z |
5186448 | 5186448 | 20240929040719_f2ffR | ES000V | 2024-09-30T12:06:52.876Z | 2024-10-07T12:21:20.618Z |
5186021 | 5186021 | 20240929031604_9pSky | ES000V | 2024-09-30T12:05:48.816Z | 2024-10-07T12:21:19.486Z |
5185930 | 5185930 | 20240929030851_IHTvT | ES000V | 2024-09-30T12:05:34.526Z | 2024-10-07T12:21:19.289Z |
5185712 | 5185712 | 20240929024620_p25Lv | ES000V | 2024-09-30T12:04:56.532Z | 2024-10-07T12:21:18.693Z |
4394267 | 4394267 | 20240530014332_dYztL | ES000V | 2024-05-31T12:09:47.318Z | 2024-06-07T12:16:06.458Z |
4357719 | 4357719 | 20240511032135_E97aC | ES000V | 2024-05-22T12:12:10.178Z | 2024-05-22T12:12:10.178Z |
4357710 | 4357710 | 20240511031252_3YEyz | ES000V | 2024-05-22T12:12:09.660Z | 2024-05-22T12:12:09.660Z |
4351511 | 4351511 | 20240511024735_ny3LZ | ES000V | 2024-05-21T12:05:53.570Z | 2024-05-22T12:12:07.602Z |
4351213 | 4351213 | 20240511015456_ADrWV | ES000V | 2024-05-21T12:05:31.678Z | 2024-05-22T12:12:02.213Z |
4351178 | 4351178 | 20240511015122_8UXOj | ES000V | 2024-05-21T12:05:27.305Z | 2024-05-22T12:12:01.656Z |
4351127 | 4351127 | 20240511014326_rmuFy | ES000V | 2024-05-21T12:05:25.341Z | 2024-05-22T12:12:00.590Z |
4350221 | 4350221 | 20240510223540_642Zz | ES000V | 2024-05-21T12:04:09.396Z | 2024-05-22T12:11:22.556Z |
4348254 | 4348254 | 20240510032838_kEOz1 | ES000V | 2024-05-20T12:11:37.491Z | 2024-05-21T12:11:30.744Z |
4348126 | 4348126 | 20240510024535_0PyrT | ES000V | 2024-05-20T12:11:21.489Z | 2024-05-21T12:11:25.079Z |
4341717 | 4341717 | 20240509231353_tp2OH | ES000V | 2024-05-19T12:09:52.944Z | 2024-05-21T12:10:20.869Z |
4219830 | 4219830 | 20240420025110_5gtDX | ES000V | 2024-04-21T12:02:27.637Z | 2024-04-28T12:21:22.767Z |
4219347 | 4219347 | 20240420014759_DsWLw | ES000V | 2024-04-21T12:01:37.161Z | 2024-04-28T12:21:13.935Z |
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);