participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,611 rows where station_code = "ES000L" 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 |
---|---|---|---|---|---|
5523624 | 5523624 | 20241111015809_0g16d | ES000L | 2024-11-12T14:16:04.398Z | 2024-11-12T14:18:08.278Z |
5523588 | 5523588 | 20241111015014_JqicR | ES000L | 2024-11-12T14:16:02.188Z | 2024-11-12T14:18:08.261Z |
5523444 | 5523444 | 20241111012627_b3KLf | ES000L | 2024-11-12T14:15:38.345Z | 2024-11-12T14:18:08.198Z |
5523406 | 5523406 | 20241111011941_22u5V | ES000L | 2024-11-12T14:15:33.221Z | 2024-11-12T14:18:08.182Z |
5523276 | 5523276 | 20241111005151_nyMbe | ES000L | 2024-11-12T14:15:13.616Z | 2024-11-12T14:18:08.122Z |
5523152 | 5523152 | 20241111001437_6yJ8B | ES000L | 2024-11-12T14:14:50.808Z | 2024-11-12T14:18:08.055Z |
5522915 | 5522915 | 20241110225327_uipyM | ES000L | 2024-11-12T14:14:29.342Z | 2024-11-12T14:18:07.954Z |
5522883 | 5522883 | 20241110223922_Pu20L | ES000L | 2024-11-12T14:14:26.613Z | 2024-11-12T14:18:07.939Z |
5515437 | 5515437 | 20241109212454_nNJ4z | ES000L | 2024-11-11T14:11:04.673Z | 2024-11-12T14:20:22.543Z |
5511202 | 5511202 | 20241109050319_E22mh | ES000L | 2024-11-10T14:16:29.399Z | 2024-11-12T14:23:46.307Z |
5510088 | 5510088 | 20241109014154_jWN7f | ES000L | 2024-11-10T14:14:34.281Z | 2024-11-12T14:23:30.131Z |
5509767 | 5509767 | 20241109003052_92YMu | ES000L | 2024-11-10T14:13:58.998Z | 2024-11-12T14:23:24.893Z |
5509694 | 5509694 | 20241109001356_zTlKN | ES000L | 2024-11-10T14:13:51.737Z | 2024-11-12T14:23:23.768Z |
5509599 | 5509599 | 20241108235256_N5Hje | ES000L | 2024-11-10T14:13:38.752Z | 2024-11-12T14:23:22.276Z |
5509507 | 5509507 | 20241108233436_5Qqs4 | ES000L | 2024-11-10T14:13:28.799Z | 2024-11-12T14:23:20.972Z |
5505424 | 5505424 | 20241108051510_0VIb2 | ES000L | 2024-11-09T14:16:16.935Z | 2024-11-12T14:25:17.363Z |
5505386 | 5505386 | 20241108050130_tSCUG | ES000L | 2024-11-09T14:16:15.209Z | 2024-11-12T14:25:16.693Z |
5505332 | 5505332 | 20241108044003_sBZeO | ES000L | 2024-11-09T14:16:10.579Z | 2024-11-12T14:25:15.686Z |
5505230 | 5505230 | 20241108041120_GDn7y | ES000L | 2024-11-09T14:15:57.183Z | 2024-11-12T14:25:13.974Z |
5505079 | 5505079 | 20241108034954_YT17Q | ES000L | 2024-11-09T14:15:42.146Z | 2024-11-12T14:25:11.844Z |
5504353 | 5504353 | 20241108014536_brBu7 | ES000L | 2024-11-09T14:14:28.589Z | 2024-11-12T14:25:01.728Z |
5504231 | 5504231 | 20241108011816_vXLKz | ES000L | 2024-11-09T14:14:15.552Z | 2024-11-12T14:25:00.087Z |
5504042 | 5504042 | 20241108004252_x4chA | ES000L | 2024-11-09T14:14:00.248Z | 2024-11-12T14:24:55.665Z |
5503990 | 5503990 | 20241108003537_B4heH | ES000L | 2024-11-09T14:13:57.063Z | 2024-11-12T14:24:55.266Z |
5503795 | 5503795 | 20241107234935_IZfze | ES000L | 2024-11-09T14:13:44.624Z | 2024-11-12T14:24:52.926Z |
5503584 | 5503584 | 20241107225732_nH2WF | ES000L | 2024-11-09T14:13:20.374Z | 2024-11-12T14:24:49.304Z |
5432315 | 5432315 | 20241029031330_Y3QoS | ES000L | 2024-10-31T12:21:17.658Z | 2024-11-06T14:27:26.649Z |
5431611 | 5431611 | 20241029013737_Nf83k | ES000L | 2024-10-31T12:20:25.280Z | 2024-11-06T14:27:24.181Z |
5431526 | 5431526 | 20241029012621_orQkr | ES000L | 2024-10-31T12:20:18.471Z | 2024-11-06T14:27:23.999Z |
5404096 | 5404096 | 20241026225724_TmdsC | ES000L | 2024-10-29T12:10:53.277Z | 2024-11-04T14:28:50.329Z |
5404032 | 5404032 | 20241026225413_yy4Mu | ES000L | 2024-10-29T12:10:49.264Z | 2024-11-04T14:28:50.257Z |
5403713 | 5403713 | 20241026222431_3Y3JQ | ES000L | 2024-10-29T12:10:09.119Z | 2024-11-04T14:28:49.515Z |
5386376 | 5386376 | 20241025003155_urEWb | ES000L | 2024-10-27T12:20:02.269Z | 2024-11-02T12:28:31.170Z |
5386092 | 5386092 | 20241025000259_i2Hdg | ES000L | 2024-10-27T12:19:49.855Z | 2024-11-02T12:28:30.684Z |
5385916 | 5385916 | 20241024234352_qPtcx | ES000L | 2024-10-27T12:19:36.743Z | 2024-11-02T12:28:30.474Z |
5385879 | 5385879 | 20241024233940_oTUun | ES000L | 2024-10-27T12:19:33.628Z | 2024-11-02T12:28:30.409Z |
5385435 | 5385435 | 20241024224515_dzQ2o | ES000L | 2024-10-27T12:18:55.228Z | 2024-11-02T12:28:29.827Z |
5385433 | 5385433 | 20241024224423_eLfrJ | ES000L | 2024-10-27T12:18:55.129Z | 2024-11-02T12:28:29.826Z |
5366053 | 5366053 | 20241024000235_RueNb | ES000L | 2024-10-25T12:18:15.228Z | 2024-11-01T12:26:56.555Z |
5364952 | 5364952 | 20241023230552_5UHwA | ES000L | 2024-10-25T12:17:41.745Z | 2024-11-01T12:26:55.799Z |
5364918 | 5364918 | 20241023230205_WmQhM | ES000L | 2024-10-25T12:17:40.171Z | 2024-11-01T12:26:55.754Z |
5364759 | 5364759 | 20241023225148_2R91S | ES000L | 2024-10-25T12:17:32.858Z | 2024-11-01T12:26:55.611Z |
5335420 | 5335420 | 20241021050352_ThXe3 | ES000L | 2024-10-22T12:18:12.011Z | 2024-10-29T12:26:36.258Z |
5335418 | 5335418 | 20241021050331_O3IAG | ES000L | 2024-10-22T12:18:11.976Z | 2024-10-29T12:26:36.256Z |
5335251 | 5335251 | 20241021041451_YlepF | ES000L | 2024-10-22T12:18:05.134Z | 2024-10-29T12:26:36.102Z |
5334995 | 5334995 | 20241021034142_OHoRf | ES000L | 2024-10-22T12:17:44.850Z | 2024-10-29T12:26:35.803Z |
5323448 | 5323448 | 20241019025640_1Vg3O | ES000L | 2024-10-20T12:06:14.882Z | 2024-10-27T12:28:50.756Z |
5323416 | 5323416 | 20241019023850_xgdDc | ES000L | 2024-10-20T12:06:10.480Z | 2024-10-27T12:28:50.691Z |
5323287 | 5323287 | 20241019001552_7JQtV | ES000L | 2024-10-20T12:05:37.854Z | 2024-10-27T12:28:50.148Z |
3995182 | 3995182 | 20240221021155_XDKpI | ES000L | 2024-02-22T14:06:04.372Z | 2024-02-29T14:14:42.353Z |
3995168 | 3995168 | 20240221012721_uscdO | ES000L | 2024-02-22T14:06:02.059Z | 2024-02-29T14:14:41.063Z |
3992328 | 3992328 | 20240219233502_Iu5y8 | ES000L | 2024-02-21T14:06:01.534Z | 2024-02-28T14:14:27.538Z |
3985937 | 3985937 | 20240218032513_wn246 | ES000L | 2024-02-19T14:06:58.841Z | 2024-02-26T14:17:04.633Z |
3985930 | 3985930 | 20240218032301_UEMJU | ES000L | 2024-02-19T14:06:56.943Z | 2024-02-26T14:17:04.003Z |
3985797 | 3985797 | 20240218013236_B8umJ | ES000L | 2024-02-19T14:06:34.015Z | 2024-02-26T14:16:53.586Z |
3985690 | 3985690 | 20240217231431_AjXK6 | ES000L | 2024-02-19T14:06:07.351Z | 2024-02-26T14:16:45.944Z |
3985667 | 3985667 | 20240217220846_n09aX | ES000L | 2024-02-19T14:06:03.565Z | 2024-02-26T14:16:44.253Z |
3966208 | 3966208 | 20240214054436_EVIET | ES000L | 2024-02-15T14:08:42.025Z | 2024-02-22T14:24:20.516Z |
3965937 | 3965937 | 20240214034143_X3hBW | ES000L | 2024-02-15T14:08:03.613Z | 2024-02-22T14:24:09.337Z |
3965929 | 3965929 | 20240214033735_d9xhD | ES000L | 2024-02-15T14:08:02.922Z | 2024-02-22T14:24:08.974Z |
3965727 | 3965727 | 20240214021646_4A25s | ES000L | 2024-02-15T14:07:25.198Z | 2024-02-22T14:23:57.839Z |
3965380 | 3965380 | 20240213233901_WKv6s | ES000L | 2024-02-15T14:06:28.755Z | 2024-02-22T14:23:44.512Z |
3965373 | 3965373 | 20240213233842_2XN8p | ES000L | 2024-02-15T14:06:28.197Z | 2024-02-22T14:23:44.229Z |
3965182 | 3965182 | 20240213210209_QKoyh | ES000L | 2024-02-15T14:05:57.398Z | 2024-02-22T14:23:35.000Z |
3964813 | 3964813 | 20240213191831_v1HV1 | ES000L | 2024-02-15T14:05:13.664Z | 2024-02-22T14:23:25.527Z |
3954278 | 3954278 | 20240212051924_b83n0 | ES000L | 2024-02-13T14:08:48.719Z | 2024-02-20T14:26:05.783Z |
3947706 | 3947706 | 20240211054709_NHo7w | ES000L | 2024-02-12T14:07:02.450Z | 2024-02-19T14:19:13.876Z |
3947696 | 3947696 | 20240211053446_mPDLb | ES000L | 2024-02-12T14:07:00.772Z | 2024-02-19T14:19:13.812Z |
3947677 | 3947677 | 20240211044723_xFuOu | ES000L | 2024-02-12T14:06:55.466Z | 2024-02-19T14:19:13.707Z |
3947645 | 3947645 | 20240211041814_n55gS | ES000L | 2024-02-12T14:06:47.665Z | 2024-02-19T14:19:13.461Z |
3880772 | 3880772 | 20240123055158_TyE2H | ES000L | 2024-01-25T14:03:05.520Z | 2024-01-31T14:18:14.843Z |
3880714 | 3880714 | 20240123051055_Mbrmh | ES000L | 2024-01-25T14:02:53.201Z | 2024-01-31T14:18:12.856Z |
3880629 | 3880629 | 20240123042856_tSnAJ | ES000L | 2024-01-25T14:02:32.223Z | 2024-01-31T14:18:10.701Z |
3880563 | 3880563 | 20240123041238_eyrEl | ES000L | 2024-01-25T14:02:24.971Z | 2024-01-31T14:18:08.619Z |
3880514 | 3880514 | 20240123035810_TqSPU | ES000L | 2024-01-25T14:02:16.707Z | 2024-01-31T14:18:06.919Z |
3880498 | 3880498 | 20240123034846_ASuAR | ES000L | 2024-01-25T14:02:13.736Z | 2024-01-31T14:18:06.410Z |
3880496 | 3880496 | 20240123034707_u6Ec0 | ES000L | 2024-01-25T14:02:12.900Z | 2024-01-31T14:18:06.197Z |
3880320 | 3880320 | 20240123023816_GrtXH | ES000L | 2024-01-25T14:01:43.286Z | 2024-01-31T14:18:01.630Z |
3880289 | 3880289 | 20240123023300_ZkMA1 | ES000L | 2024-01-25T14:01:38.623Z | 2024-01-31T14:18:00.927Z |
3877580 | 3877580 | 20240122000608_wZfTW | ES000L | 2024-01-24T14:00:30.348Z | 2024-01-30T14:18:17.065Z |
3861032 | 3861032 | 20240118221942_7xw3F | ES000L | 2024-01-21T14:18:57.668Z | 2024-01-26T14:23:01.825Z |
3856525 | 3856525 | 20240118054302_tqNKm | ES000L | 2024-01-21T14:09:09.289Z | 2024-01-26T14:21:24.691Z |
3856139 | 3856139 | 20240118052053_BNheI | ES000L | 2024-01-21T14:08:20.850Z | 2024-01-26T14:21:21.094Z |
3855998 | 3855998 | 20240118051647_zUllY | ES000L | 2024-01-21T14:07:57.901Z | 2024-01-26T14:21:20.240Z |
3855941 | 3855941 | 20240118051335_BjmZh | ES000L | 2024-01-21T14:07:49.439Z | 2024-01-26T14:21:19.765Z |
3854872 | 3854872 | 20240118041610_3at33 | ES000L | 2024-01-21T14:04:26.370Z | 2024-01-26T14:21:11.038Z |
3847401 | 3847401 | 20240118020435_oRNRO | ES000L | 2024-01-20T14:03:12.394Z | 2024-01-26T14:20:52.673Z |
3846110 | 3846110 | 20240118001310_5Hccd | ES000L | 2024-01-20T14:01:03.200Z | 2024-01-26T14:20:28.166Z |
3839858 | 3839858 | 20240116060111_eSBQU | ES000L | 2024-01-19T14:03:56.227Z | 2024-01-25T14:21:25.898Z |
3814299 | 3814299 | 20240112233148_LpuVH | ES000L | 2024-01-15T14:13:48.450Z | 2024-01-21T14:27:57.305Z |
3710953 | 3710953 | 20231223054457_DtXl4 | ES000L | 2024-01-06T00:05:53.893Z | 2024-01-06T00:05:53.893Z |
3710673 | 3710673 | 20231223030056_s7L27 | ES000L | 2024-01-06T00:05:53.849Z | 2024-01-06T00:05:53.849Z |
3710634 | 3710634 | 20231223023527_XHI5l | ES000L | 2024-01-06T00:05:53.843Z | 2024-01-06T00:05:53.843Z |
3710349 | 3710349 | 20231222214037_jkYGm | ES000L | 2024-01-06T00:05:53.800Z | 2024-01-06T00:05:53.800Z |
3705258 | 3705258 | 20231222044027_wjh0o | ES000L | 2024-01-06T00:05:52.102Z | 2024-01-06T00:05:52.102Z |
3701322 | 3701322 | 20231221060840_x129D | ES000L | 2024-01-06T00:05:49.715Z | 2024-01-06T00:05:49.715Z |
3701294 | 3701294 | 20231221055527_fj8TS | ES000L | 2024-01-06T00:05:49.706Z | 2024-01-06T00:05:49.706Z |
3701271 | 3701271 | 20231221054055_EJlld | ES000L | 2024-01-06T00:05:49.693Z | 2024-01-06T00:05:49.693Z |
3701093 | 3701093 | 20231221042656_pjS8X | ES000L | 2024-01-06T00:05:49.586Z | 2024-01-06T00:05:49.586Z |
3700729 | 3700729 | 20231221014013_uUEcd | ES000L | 2024-01-06T00:05:49.407Z | 2024-01-06T00:05:49.407Z |
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);