participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,482 rows where station_code = "ES000M" 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 |
---|---|---|---|---|---|
5573107 | 5573107 | 20241121035151_ZgMFo | ES000M | 2024-11-22T14:19:09.995Z | 2024-11-22T14:19:22.450Z |
5571786 | 5571786 | 20241121004729_4blY2 | ES000M | 2024-11-22T14:17:39.758Z | 2024-11-22T14:19:22.195Z |
5556729 | 5556729 | 20241119013224_WPK2P | ES000M | 2024-11-20T14:11:23.143Z | 2024-11-22T14:22:19.552Z |
5549141 | 5549141 | 20241117032343_LoYn3 | ES000M | 2024-11-18T14:11:05.672Z | 2024-11-22T14:23:18.889Z |
5523770 | 5523770 | 20241111022046_g1N0P | ES000M | 2024-11-12T14:16:12.128Z | 2024-11-19T14:22:14.846Z |
5523598 | 5523598 | 20241111015251_rclge | ES000M | 2024-11-12T14:16:02.898Z | 2024-11-19T14:22:13.663Z |
5523475 | 5523475 | 20241111013042_N0b5B | ES000M | 2024-11-12T14:15:44.970Z | 2024-11-19T14:22:12.830Z |
5523082 | 5523082 | 20241110235840_VBxYh | ES000M | 2024-11-12T14:14:44.625Z | 2024-11-19T14:22:09.868Z |
5510508 | 5510508 | 20241109025103_QCqJa | ES000M | 2024-11-10T14:15:23.755Z | 2024-11-17T14:23:58.505Z |
5509296 | 5509296 | 20241108224830_VbqyI | ES000M | 2024-11-10T14:13:10.105Z | 2024-11-17T14:23:42.811Z |
5505388 | 5505388 | 20241108050311_RI55H | ES000M | 2024-11-09T14:16:15.392Z | 2024-11-16T14:28:31.261Z |
5505333 | 5505333 | 20241108044003_sBZeO | ES000M | 2024-11-09T14:16:10.579Z | 2024-11-16T14:28:30.172Z |
5505190 | 5505190 | 20241108040450_GcVEI | ES000M | 2024-11-09T14:15:54.185Z | 2024-11-16T14:28:28.425Z |
5504922 | 5504922 | 20241108031938_A4UqZ | ES000M | 2024-11-09T14:15:23.947Z | 2024-11-16T14:28:24.959Z |
5504527 | 5504527 | 20241108021225_nlxKC | ES000M | 2024-11-09T14:14:48.830Z | 2024-11-16T14:28:21.173Z |
5504449 | 5504449 | 20241108015919_lZjGL | ES000M | 2024-11-09T14:14:40.013Z | 2024-11-16T14:28:20.055Z |
5504354 | 5504354 | 20241108014536_brBu7 | ES000M | 2024-11-09T14:14:28.589Z | 2024-11-16T14:28:19.330Z |
5504167 | 5504167 | 20241108010922_RYHS2 | ES000M | 2024-11-09T14:14:10.543Z | 2024-11-16T14:28:16.755Z |
5504155 | 5504155 | 20241108010717_jx34c | ES000M | 2024-11-09T14:14:09.622Z | 2024-11-16T14:28:16.714Z |
5503953 | 5503953 | 20241108002513_N6rsd | ES000M | 2024-11-09T14:13:54.660Z | 2024-11-16T14:28:14.185Z |
5503790 | 5503790 | 20241107234855_VGNg0 | ES000M | 2024-11-09T14:13:44.425Z | 2024-11-16T14:28:12.601Z |
5503771 | 5503771 | 20241107234727_1QZjB | ES000M | 2024-11-09T14:13:43.688Z | 2024-11-16T14:28:12.464Z |
5503401 | 5503401 | 20241107220641_CVfL6 | ES000M | 2024-11-09T14:12:59.936Z | 2024-11-16T14:28:07.006Z |
5502996 | 5502996 | 20241107202622_dF7c6 | ES000M | 2024-11-09T14:12:18.053Z | 2024-11-16T14:28:01.790Z |
5470072 | 5470072 | 20241103052217_a6kRc | ES000M | 2024-11-04T14:17:45.101Z | 2024-11-11T14:23:04.074Z |
5468185 | 5468185 | 20241102234723_2qa5Z | ES000M | 2024-11-04T14:13:38.532Z | 2024-11-11T14:22:51.969Z |
5452833 | 5452833 | 20241101050014_NUHXL | ES000M | 2024-11-02T12:19:27.982Z | 2024-11-09T14:24:34.477Z |
5450958 | 5450958 | 20241031220334_XVzDx | ES000M | 2024-11-02T12:16:22.734Z | 2024-11-09T14:24:20.313Z |
5432675 | 5432675 | 20241029041324_Brx4j | ES000M | 2024-10-31T12:21:30.903Z | 2024-11-06T14:27:28.363Z |
5431794 | 5431794 | 20241029015909_W3JgM | ES000M | 2024-10-31T12:20:40.275Z | 2024-11-06T14:27:24.855Z |
5431753 | 5431753 | 20241029015445_SZS3a | ES000M | 2024-10-31T12:20:36.204Z | 2024-11-06T14:27:24.671Z |
5431713 | 5431713 | 20241029015107_eXsZm | ES000M | 2024-10-31T12:20:34.188Z | 2024-11-06T14:27:24.605Z |
5431626 | 5431626 | 20241029013833_16qp1 | ES000M | 2024-10-31T12:20:26.561Z | 2024-11-06T14:27:24.248Z |
5409125 | 5409125 | 20241027040141_KyVHH | ES000M | 2024-10-29T12:17:07.764Z | 2024-11-04T14:29:01.206Z |
5335430 | 5335430 | 20241021050510_6fcnw | ES000M | 2024-10-22T12:18:12.476Z | 2024-10-29T12:26:36.289Z |
5335264 | 5335264 | 20241021042116_5auX9 | ES000M | 2024-10-22T12:18:05.540Z | 2024-10-29T12:26:36.111Z |
5335070 | 5335070 | 20241021035156_9IwxK | ES000M | 2024-10-22T12:17:53.169Z | 2024-10-29T12:26:35.899Z |
5335038 | 5335038 | 20241021034656_mHdrf | ES000M | 2024-10-22T12:17:49.503Z | 2024-10-29T12:26:35.836Z |
5335016 | 5335016 | 20241021034303_a9iZn | ES000M | 2024-10-22T12:17:47.026Z | 2024-10-29T12:26:35.814Z |
5334711 | 5334711 | 20241021030511_fXKvF | ES000M | 2024-10-22T12:17:19.412Z | 2024-10-29T12:26:35.471Z |
5334245 | 5334245 | 20241021021139_vlVJR | ES000M | 2024-10-22T12:16:30.542Z | 2024-10-29T12:26:34.990Z |
5334119 | 5334119 | 20241021015809_ODVzk | ES000M | 2024-10-22T12:16:22.033Z | 2024-10-29T12:26:34.831Z |
5334000 | 5334000 | 20241021014909_ul2Ma | ES000M | 2024-10-22T12:16:16.030Z | 2024-10-29T12:26:34.759Z |
5333813 | 5333813 | 20241021012747_OwnI3 | ES000M | 2024-10-22T12:16:07.803Z | 2024-10-29T12:26:34.628Z |
5326453 | 5326453 | 20241019183358_gE1lE | ES000M | 2024-10-21T12:09:27.175Z | 2024-10-28T12:26:41.701Z |
3814373 | 3814373 | 20240113010259_TyTdk | ES000M | 2024-01-15T14:13:53.771Z | 2024-01-21T14:27:58.469Z |
3808054 | 3808054 | 20240112021758_eGmI6 | ES000M | 2024-01-15T14:02:20.662Z | 2024-01-21T14:27:28.102Z |
3785670 | 3785670 | 20240108032802_Uevqt | ES000M | 2024-01-11T14:20:24.050Z | 2024-01-16T14:27:38.192Z |
3785639 | 3785639 | 20240107215320_xICfe | ES000M | 2024-01-11T14:19:33.196Z | 2024-01-16T14:27:29.388Z |
3780569 | 3780569 | 20240108045424_1kbmZ | ES000M | 2024-01-11T14:03:27.258Z | 2024-01-17T14:23:17.052Z |
3780567 | 3780567 | 20240108044642_wt7kF | ES000M | 2024-01-11T14:03:24.928Z | 2024-01-17T14:23:16.930Z |
3780565 | 3780565 | 20240108044240_2gGq1 | ES000M | 2024-01-11T14:03:23.133Z | 2024-01-17T14:23:16.832Z |
3770965 | 3770965 | 20240107054742_FwGCP | ES000M | 2024-01-09T14:19:39.662Z | 2024-01-16T14:27:03.400Z |
3770679 | 3770679 | 20240107051253_CTYzF | ES000M | 2024-01-09T14:19:21.903Z | 2024-01-16T14:27:01.889Z |
3770532 | 3770532 | 20240107044248_aBQml | ES000M | 2024-01-09T14:19:06.694Z | 2024-01-16T14:27:01.240Z |
3769796 | 3769796 | 20240107025726_rOWl0 | ES000M | 2024-01-09T14:14:11.571Z | 2024-01-15T14:24:30.180Z |
3769792 | 3769792 | 20240107025725_7n9sx | ES000M | 2024-01-09T14:14:11.397Z | 2024-01-15T14:24:30.156Z |
3768739 | 3768739 | 20240106235649_dJydG | ES000M | 2024-01-09T14:12:26.090Z | 2024-01-15T14:24:24.669Z |
3756635 | 3756635 | 20240106061028_c3Xgi | ES000M | 2024-01-08T14:01:55.261Z | 2024-01-15T14:23:45.195Z |
3756389 | 3756389 | 20240106054218_p82OU | ES000M | 2024-01-08T14:01:19.622Z | 2024-01-15T14:23:43.393Z |
3730675 | 3730675 | 20240101183541_XpXp2 | ES000M | 2024-01-06T00:06:10.728Z | 2024-01-10T14:31:34.991Z |
3712504 | 3712504 | 20231224041122_tcy6a | ES000M | 2024-01-06T00:05:55.230Z | 2024-01-06T00:05:55.230Z |
3712361 | 3712361 | 20231224012001_uSGOW | ES000M | 2024-01-06T00:05:55.208Z | 2024-01-06T00:05:55.208Z |
3712366 | 3712366 | 20231224013026_zfv3X | ES000M | 2024-01-06T00:05:55.208Z | 2024-01-06T00:05:55.208Z |
3712343 | 3712343 | 20231224001702_ZbPik | ES000M | 2024-01-06T00:05:55.205Z | 2024-01-06T00:05:55.205Z |
3710942 | 3710942 | 20231223054304_cWjq9 | ES000M | 2024-01-06T00:05:53.892Z | 2024-01-06T00:05:53.892Z |
3710874 | 3710874 | 20231223045449_rHqge | ES000M | 2024-01-06T00:05:53.881Z | 2024-01-06T00:05:53.881Z |
3710857 | 3710857 | 20231223044433_B1CBW | ES000M | 2024-01-06T00:05:53.878Z | 2024-01-06T00:05:53.878Z |
3710767 | 3710767 | 20231223035658_kwLY2 | ES000M | 2024-01-06T00:05:53.863Z | 2024-01-06T00:05:53.863Z |
3710694 | 3710694 | 20231223031319_f26NX | ES000M | 2024-01-06T00:05:53.852Z | 2024-01-06T00:05:53.852Z |
3710683 | 3710683 | 20231223030207_MsK9z | ES000M | 2024-01-06T00:05:53.850Z | 2024-01-06T00:05:53.850Z |
3710674 | 3710674 | 20231223030056_s7L27 | ES000M | 2024-01-06T00:05:53.849Z | 2024-01-06T00:05:53.849Z |
3710491 | 3710491 | 20231223000144_GKNGO | ES000M | 2024-01-06T00:05:53.821Z | 2024-01-06T00:05:53.821Z |
3710442 | 3710442 | 20231222230949_E6i36 | ES000M | 2024-01-06T00:05:53.813Z | 2024-01-06T00:05:53.813Z |
3708618 | 3708618 | 20231222182317_ziD4e | ES000M | 2024-01-06T00:05:53.650Z | 2024-01-06T00:05:53.650Z |
3705437 | 3705437 | 20231222052248_S2WxU | ES000M | 2024-01-06T00:05:52.131Z | 2024-01-06T00:05:52.131Z |
3705321 | 3705321 | 20231222045254_9JXDc | ES000M | 2024-01-06T00:05:52.111Z | 2024-01-06T00:05:52.111Z |
3705290 | 3705290 | 20231222044731_379PN | ES000M | 2024-01-06T00:05:52.108Z | 2024-01-06T00:05:52.108Z |
3705209 | 3705209 | 20231222042204_GUakh | ES000M | 2024-01-06T00:05:52.095Z | 2024-01-06T00:05:52.095Z |
3705103 | 3705103 | 20231222033337_FLY5y | ES000M | 2024-01-06T00:05:52.077Z | 2024-01-06T00:05:52.077Z |
3705014 | 3705014 | 20231222030458_0Neti | ES000M | 2024-01-06T00:05:52.064Z | 2024-01-06T00:05:52.064Z |
3704992 | 3704992 | 20231222025239_eFm02 | ES000M | 2024-01-06T00:05:52.059Z | 2024-01-06T00:05:52.059Z |
3704750 | 3704750 | 20231221231356_bjgMS | ES000M | 2024-01-06T00:05:52.015Z | 2024-01-06T00:05:52.015Z |
3701319 | 3701319 | 20231221060627_Oft2N | ES000M | 2024-01-06T00:05:49.715Z | 2024-01-06T00:05:49.715Z |
3701288 | 3701288 | 20231221055404_vJoq3 | ES000M | 2024-01-06T00:05:49.705Z | 2024-01-06T00:05:49.705Z |
3701269 | 3701269 | 20231221054006_Nrx6S | ES000M | 2024-01-06T00:05:49.692Z | 2024-01-06T00:05:49.692Z |
3701168 | 3701168 | 20231221044806_q0pmZ | ES000M | 2024-01-06T00:05:49.626Z | 2024-01-06T00:05:49.626Z |
3701085 | 3701085 | 20231221042353_B6TiB | ES000M | 2024-01-06T00:05:49.584Z | 2024-01-06T00:05:49.584Z |
3701031 | 3701031 | 20231221040300_xSf3F | ES000M | 2024-01-06T00:05:49.551Z | 2024-01-06T00:05:49.551Z |
3700963 | 3700963 | 20231221032850_ujxiW | ES000M | 2024-01-06T00:05:49.499Z | 2024-01-06T00:05:49.499Z |
3700839 | 3700839 | 20231221023103_7dTYc | ES000M | 2024-01-06T00:05:49.448Z | 2024-01-06T00:05:49.448Z |
3700710 | 3700710 | 20231221013336_cI2ui | ES000M | 2024-01-06T00:05:49.402Z | 2024-01-06T00:05:49.402Z |
3700697 | 3700697 | 20231221012318_QRRO5 | ES000M | 2024-01-06T00:05:49.398Z | 2024-01-06T00:05:49.398Z |
3700584 | 3700584 | 20231220235639_qHOjK | ES000M | 2024-01-06T00:05:49.329Z | 2024-01-06T00:05:49.329Z |
3700486 | 3700486 | 20231220220041_pLOKR | ES000M | 2024-01-06T00:05:49.279Z | 2024-01-06T00:05:49.279Z |
3700344 | 3700344 | 20231220211122_t13fw | ES000M | 2024-01-06T00:05:49.241Z | 2024-01-06T00:05:49.241Z |
3681130 | 3681130 | 20231217205319_kY28j | ES000M | 2024-01-06T00:05:38.101Z | 2024-01-06T00:05:38.101Z |
3675072 | 3675072 | 20231217044407_3aMEF | ES000M | 2024-01-06T00:05:36.096Z | 2024-01-06T00:05:36.096Z |
3667213 | 3667213 | 20231216053413_Tfgcz | ES000M | 2024-01-06T00:05:33.954Z | 2024-01-06T00:05:33.954Z |
3667152 | 3667152 | 20231216053052_gcAT5 | ES000M | 2024-01-06T00:05:33.948Z | 2024-01-06T00:05:33.948Z |
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);