participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
272 rows where station_code = "ES000P" 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 |
---|---|---|---|---|---|
4275967 | 4275967 | 20240503051500_3U3kt | ES000P | 2024-05-05T12:12:08.711Z | 2024-05-11T12:28:29.887Z |
4275932 | 4275932 | 20240503045222_KYllf | ES000P | 2024-05-05T12:12:06.007Z | 2024-05-11T12:28:28.179Z |
4275858 | 4275858 | 20240503032434_zQJoP | ES000P | 2024-05-05T12:11:59.713Z | 2024-05-11T12:28:23.467Z |
4275748 | 4275748 | 20240503011813_xlfxQ | ES000P | 2024-05-05T12:11:42.432Z | 2024-05-11T12:28:16.302Z |
4275694 | 4275694 | 20240503002606_oQ4bi | ES000P | 2024-05-05T12:11:29.893Z | 2024-05-11T12:28:13.565Z |
4256281 | 4256281 | 20240430003638_NJP36 | ES000P | 2024-05-01T12:09:19.559Z | 2024-05-08T12:24:59.883Z |
4240232 | 4240232 | 20240424225433_1WSMO | ES000P | 2024-04-27T12:10:18.696Z | 2024-05-03T12:19:29.925Z |
4191169 | 4191169 | 20240415041145_sVY29 | ES000P | 2024-04-16T12:05:42.837Z | 2024-04-23T12:24:56.101Z |
4186302 | 4186302 | 20240414040712_s2oPs | ES000P | 2024-04-15T12:06:26.194Z | 2024-04-22T12:22:29.090Z |
4157461 | 4157461 | 20240408010206_IKKUp | ES000P | 2024-04-09T12:04:44.914Z | 2024-04-16T12:20:16.590Z |
4154679 | 4154679 | 20240407023854_eICyY | ES000P | 2024-04-08T12:06:59.878Z | 2024-04-15T12:19:16.729Z |
4154199 | 4154199 | 20240407011610_lb4bz | ES000P | 2024-04-08T12:06:14.604Z | 2024-04-15T12:19:14.536Z |
4146867 | 4146867 | 20240405020440_TaNH3 | ES000P | 2024-04-06T12:04:50.322Z | 2024-04-13T12:21:24.195Z |
4146643 | 4146643 | 20240404220526_6g3LD | ES000P | 2024-04-06T12:03:58.034Z | 2024-04-13T12:21:19.300Z |
4142785 | 4142785 | 20240404015740_Y7L98 | ES000P | 2024-04-05T12:03:21.488Z | 2024-04-12T12:19:45.637Z |
4139216 | 4139216 | 20240403030221_fKBiP | ES000P | 2024-04-04T12:06:39.826Z | 2024-04-11T12:23:46.115Z |
4136125 | 4136125 | 20240402033028_3hZGL | ES000P | 2024-04-03T12:06:39.164Z | 2024-04-10T12:18:00.546Z |
4133114 | 4133114 | 20240401023358_pnpna | ES000P | 2024-04-02T12:04:15.534Z | 2024-04-09T12:21:14.675Z |
4132925 | 4132925 | 20240401010943_Co4Ax | ES000P | 2024-04-02T12:03:49.905Z | 2024-04-09T12:21:12.679Z |
4114449 | 4114449 | 20240327004817_DcQbC | ES000P | 2024-03-28T12:03:01.787Z | 2024-04-04T12:17:10.928Z |
4091074 | 4091074 | 20240319030414_J92o3 | ES000P | 2024-03-20T12:07:00.097Z | 2024-03-27T12:19:17.370Z |
4086933 | 4086933 | 20240318054835_1JBb4 | ES000P | 2024-03-19T12:09:14.446Z | 2024-03-26T12:21:12.429Z |
4070934 | 4070934 | 20240314203205_5KDQu | ES000P | 2024-03-16T12:05:42.341Z | 2024-03-23T12:25:38.882Z |
4051742 | 4051742 | 20240309020806_tEk1P | ES000P | 2024-03-10T12:09:25.933Z | 2024-03-17T12:18:23.875Z |
4041029 | 4041029 | 20240307021242_1E6gt | ES000P | 2024-03-08T14:08:30.039Z | 2024-03-15T12:19:26.451Z |
4040245 | 4040245 | 20240306231225_Yz574 | ES000P | 2024-03-08T14:07:32.967Z | 2024-03-15T12:19:16.980Z |
4039705 | 4039705 | 20240306203421_wyyiO | ES000P | 2024-03-08T14:06:45.264Z | 2024-03-15T12:19:10.947Z |
3995397 | 3995397 | 20240221063309_gRISk | ES000P | 2024-02-22T14:06:46.996Z | 2024-02-29T14:14:55.278Z |
3995333 | 3995333 | 20240221052523_03gYd | ES000P | 2024-02-22T14:06:37.287Z | 2024-02-29T14:14:52.813Z |
3976048 | 3976048 | 20240216030200_o6H2e | ES000P | 2024-02-17T14:06:48.819Z | 2024-02-24T14:23:40.627Z |
3976034 | 3976034 | 20240216025921_aSiIA | ES000P | 2024-02-17T14:06:46.385Z | 2024-02-24T14:23:39.105Z |
3958868 | 3958868 | 20240213030349_J3hmk | ES000P | 2024-02-14T14:08:32.301Z | 2024-02-21T14:20:37.436Z |
3958476 | 3958476 | 20240213011844_SRk7G | ES000P | 2024-02-14T14:07:47.605Z | 2024-02-21T14:20:34.004Z |
3953959 | 3953959 | 20240212044359_YC25J | ES000P | 2024-02-13T14:08:24.016Z | 2024-02-20T14:26:03.604Z |
3947731 | 3947731 | 20240211061845_OOhR3 | ES000P | 2024-02-12T14:07:07.451Z | 2024-02-19T14:19:14.102Z |
3947695 | 3947695 | 20240211053107_eVDJt | ES000P | 2024-02-12T14:07:00.420Z | 2024-02-19T14:19:13.793Z |
3947644 | 3947644 | 20240211041530_DVo5H | ES000P | 2024-02-12T14:06:47.164Z | 2024-02-19T14:19:13.452Z |
3947640 | 3947640 | 20240211040602_uzBXz | ES000P | 2024-02-12T14:06:46.443Z | 2024-02-19T14:19:13.419Z |
3947623 | 3947623 | 20240211034907_nfRQB | ES000P | 2024-02-12T14:06:41.309Z | 2024-02-19T14:19:13.325Z |
3947514 | 3947514 | 20240211010108_tdK2G | ES000P | 2024-02-12T14:06:14.343Z | 2024-02-19T14:19:12.333Z |
3931615 | 3931615 | 20240207050819_vULzR | ES000P | 2024-02-08T14:05:13.445Z | 2024-02-15T14:18:38.402Z |
3931589 | 3931589 | 20240207045914_66Sac | ES000P | 2024-02-08T14:05:09.274Z | 2024-02-15T14:18:38.230Z |
3931242 | 3931242 | 20240207003754_c2aqG | ES000P | 2024-02-08T14:03:58.492Z | 2024-02-15T14:18:34.520Z |
3926886 | 3926886 | 20240206045749_5j3Ee | ES000P | 2024-02-07T14:05:37.276Z | 2024-02-14T14:19:49.223Z |
3926740 | 3926740 | 20240206025916_S6ZZt | ES000P | 2024-02-07T14:05:04.341Z | 2024-02-14T14:19:46.890Z |
3926717 | 3926717 | 20240206024019_z6gSI | ES000P | 2024-02-07T14:04:57.037Z | 2024-02-14T14:19:46.667Z |
3873982 | 3873982 | 20240120040530_xix8T | ES000P | 2024-01-23T14:09:36.650Z | 2024-01-28T14:19:44.958Z |
3850115 | 3850115 | 20240117040935_3hgyv | ES000P | 2024-01-20T14:08:05.761Z | 2024-01-21T14:19:44.174Z |
3823355 | 3823355 | 20240115022829_ZzZJX | ES000P | 2024-01-17T14:01:51.699Z | 2024-01-24T14:18:12.392Z |
3794626 | 3794626 | 20240110053016_iNEQJ | ES000P | 2024-01-13T14:05:50.647Z | 2024-01-19T14:26:59.119Z |
3794156 | 3794156 | 20240110045737_laB8U | ES000P | 2024-01-13T14:04:56.635Z | 2024-01-19T14:26:53.720Z |
3793991 | 3793991 | 20240110044532_t5hRZ | ES000P | 2024-01-13T14:04:38.302Z | 2024-01-19T14:26:51.892Z |
3793639 | 3793639 | 20240110042621_z3OmJ | ES000P | 2024-01-13T14:03:51.274Z | 2024-01-19T14:26:48.340Z |
3784812 | 3784812 | 20240109050215_LVOOK | ES000P | 2024-01-11T14:14:33.011Z | 2024-01-18T14:25:13.432Z |
3778497 | 3778497 | 20240108015256_7t2W3 | ES000P | 2024-01-10T14:14:26.188Z | 2024-01-16T14:27:35.523Z |
3769851 | 3769851 | 20240107030523_3tca5 | ES000P | 2024-01-09T14:14:15.445Z | 2024-01-15T14:24:30.334Z |
3768973 | 3768973 | 20240107004956_o7FuQ | ES000P | 2024-01-09T14:12:49.459Z | 2024-01-15T14:24:25.617Z |
3764006 | 3764006 | 20240106041210_joPTy | ES000P | 2024-01-08T14:15:48.139Z | 2024-01-14T14:23:26.576Z |
3756487 | 3756487 | 20240106055315_sTfD0 | ES000P | 2024-01-08T14:01:30.788Z | 2024-01-15T14:23:44.209Z |
3749092 | 3749092 | 20240104052111_9TLie | ES000P | 2024-01-06T14:10:19.445Z | 2024-01-12T14:25:36.304Z |
3744777 | 3744777 | 20240104060848_wnslH | ES000P | 2024-01-06T14:01:51.494Z | 2024-01-13T14:25:46.532Z |
3740748 | 3740748 | 20240104011313_xtm2O | ES000P | 2024-01-06T00:06:14.228Z | 2024-01-12T14:25:27.493Z |
3740540 | 3740540 | 20240104003445_KvzZQ | ES000P | 2024-01-06T00:06:14.205Z | 2024-01-12T14:25:26.715Z |
3740322 | 3740322 | 20240103234603_QSYn9 | ES000P | 2024-01-06T00:06:14.179Z | 2024-01-12T14:25:24.954Z |
3734430 | 3734430 | 20240103043911_oP4Iq | ES000P | 2024-01-06T00:06:12.337Z | 2024-01-11T14:38:51.780Z |
3733994 | 3733994 | 20240103025310_l08tD | ES000P | 2024-01-06T00:06:12.297Z | 2024-01-11T14:38:39.816Z |
3731242 | 3731242 | 20240102045920_Dr3SW | ES000P | 2024-01-06T00:06:10.804Z | 2024-01-10T14:31:49.282Z |
3724866 | 3724866 | 20231231020148_OrdNy | ES000P | 2024-01-06T00:06:07.376Z | 2024-01-08T14:25:29.527Z |
3724855 | 3724855 | 20231231014252_Zui2T | ES000P | 2024-01-06T00:06:07.374Z | 2024-01-08T14:25:29.232Z |
3723701 | 3723701 | 20231230034619_W16xB | ES000P | 2024-01-06T00:06:05.866Z | 2024-01-07T14:24:32.103Z |
3723626 | 3723626 | 20231230030817_XGlFo | ES000P | 2024-01-06T00:06:05.857Z | 2024-01-07T14:24:29.233Z |
3723316 | 3723316 | 20231230004154_FYSyJ | ES000P | 2024-01-06T00:06:05.821Z | 2024-01-07T14:24:19.846Z |
3720453 | 3720453 | 20231229030637_C3H7E | ES000P | 2024-01-06T00:06:04.223Z | 2024-01-06T14:21:00.564Z |
3720271 | 3720271 | 20231228235110_9fFmd | ES000P | 2024-01-06T00:06:04.201Z | 2024-01-06T14:20:50.998Z |
3719287 | 3719287 | 20231228014429_A4sS2 | ES000P | 2024-01-06T00:06:02.808Z | 2024-01-06T01:01:35.443Z |
3701250 | 3701250 | 20231221052620_gPrxP | ES000P | 2024-01-06T00:05:49.687Z | 2024-01-06T00:05:49.687Z |
3688600 | 3688600 | 20231219045638_pEONm | ES000P | 2024-01-06T00:05:41.148Z | 2024-01-06T00:05:41.148Z |
3688583 | 3688583 | 20231219045320_GYabZ | ES000P | 2024-01-06T00:05:41.142Z | 2024-01-06T00:05:41.142Z |
3682136 | 3682136 | 20231218001149_MqtOL | ES000P | 2024-01-06T00:05:38.247Z | 2024-01-06T00:05:38.247Z |
3578294 | 3578294 | 20231212035830_6P4qZ | ES000P | 2024-01-06T00:05:15.230Z | 2024-01-06T00:05:15.230Z |
3561349 | 3561349 | 20231210051636_tHQSf | ES000P | 2024-01-06T00:05:10.598Z | 2024-01-06T00:05:10.598Z |
3556385 | 3556385 | 20231209223217_8y2PC | ES000P | 2024-01-06T00:05:10.196Z | 2024-01-06T00:05:10.196Z |
3549990 | 3549990 | 20231209054218_PHwLZ | ES000P | 2024-01-06T00:05:08.180Z | 2024-01-06T00:05:08.180Z |
3549452 | 3549452 | 20231209033631_NE8xl | ES000P | 2024-01-06T00:05:08.121Z | 2024-01-06T00:05:08.121Z |
3549454 | 3549454 | 20231209033632_we4IT | ES000P | 2024-01-06T00:05:08.121Z | 2024-01-06T00:05:08.121Z |
3549170 | 3549170 | 20231209021615_vOzGy | ES000P | 2024-01-06T00:05:08.086Z | 2024-01-06T00:05:08.086Z |
3548911 | 3548911 | 20231209004912_UXbOp | ES000P | 2024-01-06T00:05:08.053Z | 2024-01-06T00:05:08.053Z |
3548667 | 3548667 | 20231208234623_Iq8Tc | ES000P | 2024-01-06T00:05:08.028Z | 2024-01-06T00:05:08.028Z |
3548502 | 3548502 | 20231208232416_kzuXH | ES000P | 2024-01-06T00:05:08.012Z | 2024-01-06T00:05:08.012Z |
3540729 | 3540729 | 20231208050253_J864G | ES000P | 2024-01-06T00:05:05.754Z | 2024-01-06T00:05:05.754Z |
3539940 | 3539940 | 20231208035640_Z4Ghf | ES000P | 2024-01-06T00:05:05.691Z | 2024-01-06T00:05:05.691Z |
3538440 | 3538440 | 20231208005806_QnL4L | ES000P | 2024-01-06T00:05:05.527Z | 2024-01-06T00:05:05.527Z |
3538371 | 3538371 | 20231208004327_WX5oG | ES000P | 2024-01-06T00:05:05.518Z | 2024-01-06T00:05:05.518Z |
3532590 | 3532590 | 20231207044421_jl3hY | ES000P | 2024-01-06T00:05:03.506Z | 2024-01-06T00:05:03.506Z |
3532567 | 3532567 | 20231207042913_X0fQ5 | ES000P | 2024-01-06T00:05:03.503Z | 2024-01-06T00:05:03.503Z |
3532559 | 3532559 | 20231207042740_1z0Ql | ES000P | 2024-01-06T00:05:03.502Z | 2024-01-06T00:05:03.502Z |
3532482 | 3532482 | 20231207040614_Ym6Em | ES000P | 2024-01-06T00:05:03.492Z | 2024-01-06T00:05:03.492Z |
3532452 | 3532452 | 20231207035727_HWUMM | ES000P | 2024-01-06T00:05:03.489Z | 2024-01-06T00:05:03.489Z |
3532351 | 3532351 | 20231207031729_51niF | ES000P | 2024-01-06T00:05:03.476Z | 2024-01-06T00:05:03.476Z |
3524458 | 3524458 | 20231206050023_FfpTT | ES000P | 2024-01-06T00:05:01.379Z | 2024-01-06T00:05:01.379Z |
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);