participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,458 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 |
---|---|---|---|---|---|
5470072 | 5470072 | 20241103052217_a6kRc | ES000M | 2024-11-04T14:17:45.101Z | 2024-11-08T14:21:14.473Z |
5468185 | 5468185 | 20241102234723_2qa5Z | ES000M | 2024-11-04T14:13:38.532Z | 2024-11-08T14:21:00.259Z |
5452833 | 5452833 | 20241101050014_NUHXL | ES000M | 2024-11-02T12:19:27.982Z | 2024-11-08T14:22:39.871Z |
5450958 | 5450958 | 20241031220334_XVzDx | ES000M | 2024-11-02T12:16:22.734Z | 2024-11-08T14:22:26.728Z |
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 |
3666948 | 3666948 | 20231216051208_Oq2cU | ES000M | 2024-01-06T00:05:33.925Z | 2024-01-06T00:05:33.925Z |
3666810 | 3666810 | 20231216045743_1q0KP | ES000M | 2024-01-06T00:05:33.909Z | 2024-01-06T00:05:33.909Z |
3666548 | 3666548 | 20231216043214_0s8cE | ES000M | 2024-01-06T00:05:33.877Z | 2024-01-06T00:05:33.877Z |
3666284 | 3666284 | 20231216040435_AIpo5 | ES000M | 2024-01-06T00:05:33.845Z | 2024-01-06T00:05:33.845Z |
3665788 | 3665788 | 20231216025848_uspqr | ES000M | 2024-01-06T00:05:33.780Z | 2024-01-06T00:05:33.780Z |
3665727 | 3665727 | 20231216024636_4cwlE | ES000M | 2024-01-06T00:05:33.770Z | 2024-01-06T00:05:33.770Z |
3665504 | 3665504 | 20231216021140_EfM3q | ES000M | 2024-01-06T00:05:33.739Z | 2024-01-06T00:05:33.739Z |
3665449 | 3665449 | 20231216020113_CI2e3 | ES000M | 2024-01-06T00:05:33.731Z | 2024-01-06T00:05:33.731Z |
3665376 | 3665376 | 20231216014803_dvY8i | ES000M | 2024-01-06T00:05:33.720Z | 2024-01-06T00:05:33.720Z |
3665353 | 3665353 | 20231216014257_dQr4V | ES000M | 2024-01-06T00:05:33.717Z | 2024-01-06T00:05:33.717Z |
3665234 | 3665234 | 20231216011807_MKWXn | ES000M | 2024-01-06T00:05:33.698Z | 2024-01-06T00:05:33.698Z |
3665097 | 3665097 | 20231216005232_fD43r | ES000M | 2024-01-06T00:05:33.678Z | 2024-01-06T00:05:33.678Z |
3664998 | 3664998 | 20231216003324_c1O43 | ES000M | 2024-01-06T00:05:33.664Z | 2024-01-06T00:05:33.664Z |
3664961 | 3664961 | 20231216002557_m03F5 | ES000M | 2024-01-06T00:05:33.659Z | 2024-01-06T00:05:33.659Z |
3664799 | 3664799 | 20231215234541_UrIUV | ES000M | 2024-01-06T00:05:33.634Z | 2024-01-06T00:05:33.634Z |
3664600 | 3664600 | 20231215230018_3ARNZ | ES000M | 2024-01-06T00:05:33.609Z | 2024-01-06T00:05:33.609Z |
3664604 | 3664604 | 20231215230112_QEJ3e | ES000M | 2024-01-06T00:05:33.609Z | 2024-01-06T00:05:33.609Z |
3663816 | 3663816 | 20231215202127_VixIt | ES000M | 2024-01-06T00:05:33.513Z | 2024-01-06T00:05:33.513Z |
3663583 | 3663583 | 20231215194031_wioiK | ES000M | 2024-01-06T00:05:33.493Z | 2024-01-06T00:05:33.493Z |
3654718 | 3654718 | 20231215060403_LftY0 | ES000M | 2024-01-06T00:05:30.977Z | 2024-01-06T00:05:30.977Z |
3654412 | 3654412 | 20231215055334_mJIND | ES000M | 2024-01-06T00:05:30.940Z | 2024-01-06T00:05:30.940Z |
3653893 | 3653893 | 20231215053103_wiz6E | ES000M | 2024-01-06T00:05:30.874Z | 2024-01-06T00:05:30.874Z |
3653780 | 3653780 | 20231215052708_WPx42 | ES000M | 2024-01-06T00:05:30.860Z | 2024-01-06T00:05:30.860Z |
3653678 | 3653678 | 20231215052412_q56Mv | ES000M | 2024-01-06T00:05:30.848Z | 2024-01-06T00:05:30.848Z |
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);