participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,615 rows where station_code = "ES0002" 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 |
---|---|---|---|---|---|
4955548 | 4955548 | 20240811052619_78lEq | ES0002 | 2024-09-03T12:19:18.287Z | 2024-09-06T12:29:47.299Z |
4955480 | 4955480 | 20240811051244_2T5U5 | ES0002 | 2024-09-03T12:19:15.613Z | 2024-09-06T12:29:43.647Z |
4955402 | 4955402 | 20240811045255_2B20N | ES0002 | 2024-09-03T12:19:11.752Z | 2024-09-06T12:29:38.635Z |
4955387 | 4955387 | 20240811044918_yq3nk | ES0002 | 2024-09-03T12:19:11.233Z | 2024-09-06T12:29:37.685Z |
4955256 | 4955256 | 20240811041032_IZJGF | ES0002 | 2024-09-03T12:19:01.420Z | 2024-09-06T12:29:28.517Z |
4955230 | 4955230 | 20240811040535_Njymj | ES0002 | 2024-09-03T12:18:58.673Z | 2024-09-06T12:29:26.967Z |
4955199 | 4955199 | 20240811040032_zdrvI | ES0002 | 2024-09-03T12:18:55.220Z | 2024-09-06T12:29:25.701Z |
4955189 | 4955189 | 20240811035815_Jlr3j | ES0002 | 2024-09-03T12:18:53.671Z | 2024-09-06T12:29:24.366Z |
4955181 | 4955181 | 20240811035545_Xdfr7 | ES0002 | 2024-09-03T12:18:52.192Z | 2024-09-06T12:29:23.165Z |
4955132 | 4955132 | 20240811034525_oc22k | ES0002 | 2024-09-03T12:18:47.605Z | 2024-09-06T12:29:20.502Z |
4955111 | 4955111 | 20240811034141_MTgT3 | ES0002 | 2024-09-03T12:18:44.740Z | 2024-09-06T12:29:19.608Z |
4955099 | 4955099 | 20240811034045_TMDiq | ES0002 | 2024-09-03T12:18:43.375Z | 2024-09-06T12:29:18.431Z |
4955097 | 4955097 | 20240811034035_4qWoO | ES0002 | 2024-09-03T12:18:43.266Z | 2024-09-06T12:29:18.367Z |
4955087 | 4955087 | 20240811033723_5ahyv | ES0002 | 2024-09-03T12:18:42.623Z | 2024-09-06T12:29:17.981Z |
4955085 | 4955085 | 20240811033656_utXec | ES0002 | 2024-09-03T12:18:42.583Z | 2024-09-06T12:29:17.961Z |
4955021 | 4955021 | 20240811032337_5ziNO | ES0002 | 2024-09-03T12:18:35.040Z | 2024-09-06T12:29:14.687Z |
4953917 | 4953917 | 20240811024813_6gPuc | ES0002 | 2024-09-03T12:18:03.942Z | 2024-09-06T12:28:42.274Z |
4953874 | 4953874 | 20240811024744_DThM3 | ES0002 | 2024-09-03T12:18:02.905Z | 2024-09-06T12:28:41.276Z |
4953591 | 4953591 | 20240811024133_ebQQF | ES0002 | 2024-09-03T12:17:49.955Z | 2024-09-06T12:28:31.938Z |
4953348 | 4953348 | 20240811023650_UlgXs | ES0002 | 2024-09-03T12:17:36.013Z | 2024-09-06T12:28:24.220Z |
4953316 | 4953316 | 20240811023614_anRv8 | ES0002 | 2024-09-03T12:17:33.735Z | 2024-09-06T12:28:23.354Z |
4953198 | 4953198 | 20240811023429_h1Ess | ES0002 | 2024-09-03T12:17:23.437Z | 2024-09-06T12:28:20.974Z |
4950625 | 4950625 | 20240811021004_kc21F | ES0002 | 2024-09-02T12:16:32.841Z | 2024-09-06T12:27:46.561Z |
4950360 | 4950360 | 20240811020603_C2VkI | ES0002 | 2024-09-02T12:16:25.988Z | 2024-09-06T12:27:43.809Z |
4949921 | 4949921 | 20240811015801_is6rS | ES0002 | 2024-09-02T12:16:00.189Z | 2024-09-06T12:27:38.944Z |
4949650 | 4949650 | 20240811015320_nZFLt | ES0002 | 2024-09-02T12:15:51.597Z | 2024-09-06T12:27:36.160Z |
4947777 | 4947777 | 20240811012440_P29U2 | ES0002 | 2024-09-02T12:14:47.370Z | 2024-09-06T12:27:01.830Z |
4947251 | 4947251 | 20240811011511_3UdDE | ES0002 | 2024-09-02T12:14:20.726Z | 2024-09-06T12:26:48.035Z |
4946838 | 4946838 | 20240811010809_Hp0xk | ES0002 | 2024-09-02T12:14:09.392Z | 2024-09-06T12:26:36.218Z |
4945795 | 4945795 | 20240811005137_fvZSO | ES0002 | 2024-09-02T12:13:25.963Z | 2024-09-06T12:26:05.675Z |
4945203 | 4945203 | 20240811004222_nGiBq | ES0002 | 2024-09-02T12:13:11.755Z | 2024-09-06T12:25:48.947Z |
4944854 | 4944854 | 20240811003736_bWnIo | ES0002 | 2024-09-02T12:12:50.233Z | 2024-09-06T12:25:40.188Z |
4942577 | 4942577 | 20240810235414_R155R | ES0002 | 2024-09-02T12:11:18.629Z | 2024-09-06T12:24:23.299Z |
4942441 | 4942441 | 20240810235213_TtosU | ES0002 | 2024-09-02T12:11:13.477Z | 2024-09-06T12:24:17.645Z |
4941326 | 4941326 | 20240810233103_KHtXc | ES0002 | 2024-09-02T12:10:25.844Z | 2024-09-06T12:23:46.377Z |
4938704 | 4938704 | 20240810222622_369Dx | ES0002 | 2024-09-01T12:09:16.950Z | 2024-09-06T12:23:00.699Z |
4929624 | 4929624 | 20240810051039_LShl3 | ES0002 | 2024-08-31T12:22:30.643Z | 2024-09-02T12:29:39.928Z |
4929616 | 4929616 | 20240810050522_jRzo7 | ES0002 | 2024-08-31T12:22:30.095Z | 2024-09-02T12:29:39.615Z |
4929614 | 4929614 | 20240810050331_0Idse | ES0002 | 2024-08-31T12:22:29.867Z | 2024-09-02T12:29:39.491Z |
4929599 | 4929599 | 20240810045913_Zbmaw | ES0002 | 2024-08-31T12:22:29.044Z | 2024-09-02T12:29:39.151Z |
4929597 | 4929597 | 20240810045907_D7fVl | ES0002 | 2024-08-31T12:22:28.769Z | 2024-09-02T12:29:39.035Z |
4929585 | 4929585 | 20240810045745_CPlyI | ES0002 | 2024-08-31T12:22:27.799Z | 2024-09-02T12:29:38.802Z |
4929558 | 4929558 | 20240810045032_FF5zE | ES0002 | 2024-08-31T12:22:24.868Z | 2024-09-02T12:29:37.867Z |
4929549 | 4929549 | 20240810044922_U90ZP | ES0002 | 2024-08-31T12:22:24.246Z | 2024-09-02T12:29:37.382Z |
4929539 | 4929539 | 20240810044703_MuSld | ES0002 | 2024-08-31T12:22:23.379Z | 2024-09-02T12:29:37.042Z |
4929535 | 4929535 | 20240810044514_avqCZ | ES0002 | 2024-08-31T12:22:23.034Z | 2024-09-02T12:29:36.936Z |
4929489 | 4929489 | 20240810043154_dZ4Vm | ES0002 | 2024-08-31T12:22:20.519Z | 2024-09-02T12:29:35.937Z |
4929481 | 4929481 | 20240810043006_iawxW | ES0002 | 2024-08-31T12:22:19.959Z | 2024-09-02T12:29:35.648Z |
4929453 | 4929453 | 20240810041643_Qcnol | ES0002 | 2024-08-31T12:22:17.980Z | 2024-09-02T12:29:34.989Z |
4929451 | 4929451 | 20240810041518_KN4ll | ES0002 | 2024-08-31T12:22:17.773Z | 2024-09-02T12:29:34.876Z |
4929412 | 4929412 | 20240810040348_xSrXg | ES0002 | 2024-08-31T12:22:14.004Z | 2024-09-02T12:29:33.810Z |
4929392 | 4929392 | 20240810035800_g8GH3 | ES0002 | 2024-08-31T12:22:12.418Z | 2024-09-02T12:29:33.269Z |
4929390 | 4929390 | 20240810035731_m35cr | ES0002 | 2024-08-31T12:22:12.197Z | 2024-09-02T12:29:33.226Z |
4929381 | 4929381 | 20240810035332_5ZwvN | ES0002 | 2024-08-31T12:22:10.101Z | 2024-09-02T12:29:32.872Z |
4929361 | 4929361 | 20240810034532_LeON7 | ES0002 | 2024-08-31T12:22:06.270Z | 2024-09-02T12:29:32.607Z |
4929354 | 4929354 | 20240810034458_CLx3F | ES0002 | 2024-08-31T12:22:05.045Z | 2024-09-02T12:29:32.441Z |
4929347 | 4929347 | 20240810034225_VmamK | ES0002 | 2024-08-31T12:22:02.495Z | 2024-09-02T12:29:32.215Z |
4929324 | 4929324 | 20240810033022_5RBx4 | ES0002 | 2024-08-31T12:22:00.663Z | 2024-09-02T12:29:31.622Z |
4929171 | 4929171 | 20240810030936_tfQVK | ES0002 | 2024-08-31T12:21:53.387Z | 2024-09-02T12:29:28.671Z |
4928872 | 4928872 | 20240810025427_nhZzH | ES0002 | 2024-08-31T12:21:42.721Z | 2024-09-02T12:29:21.306Z |
4928782 | 4928782 | 20240810024926_HDkj3 | ES0002 | 2024-08-31T12:21:39.073Z | 2024-09-02T12:29:18.186Z |
4928703 | 4928703 | 20240810024645_8mWru | ES0002 | 2024-08-31T12:21:36.464Z | 2024-09-02T12:29:15.150Z |
4928459 | 4928459 | 20240810024110_2Ay0B | ES0002 | 2024-08-31T12:21:22.578Z | 2024-09-02T12:29:10.409Z |
4927996 | 4927996 | 20240810022750_anvB8 | ES0002 | 2024-08-31T12:21:08.895Z | 2024-09-02T12:28:57.654Z |
4927251 | 4927251 | 20240810020810_apUa1 | ES0002 | 2024-08-31T12:20:24.273Z | 2024-09-02T12:28:26.989Z |
4927216 | 4927216 | 20240810020649_4h3Nl | ES0002 | 2024-08-31T12:20:22.011Z | 2024-09-02T12:28:24.804Z |
4923118 | 4923118 | 20240810013229_Lu6Gp | ES0002 | 2024-08-30T12:15:06.486Z | 2024-09-02T12:27:35.298Z |
4922742 | 4922742 | 20240810012302_WMMIr | ES0002 | 2024-08-30T12:14:56.631Z | 2024-09-02T12:27:30.549Z |
4921310 | 4921310 | 20240810005159_66QQx | ES0002 | 2024-08-30T12:14:04.496Z | 2024-09-02T12:26:55.789Z |
4921055 | 4921055 | 20240810004458_eX3CI | ES0002 | 2024-08-30T12:13:50.366Z | 2024-09-02T12:26:48.608Z |
4921016 | 4921016 | 20240810004318_evWIZ | ES0002 | 2024-08-30T12:13:47.852Z | 2024-09-02T12:26:46.300Z |
4920861 | 4920861 | 20240810004015_SdMYQ | ES0002 | 2024-08-30T12:13:42.495Z | 2024-09-02T12:26:41.178Z |
4920669 | 4920669 | 20240810003646_UaP3u | ES0002 | 2024-08-30T12:13:35.817Z | 2024-09-02T12:26:33.566Z |
4919791 | 4919791 | 20240810001918_o26zf | ES0002 | 2024-08-30T12:13:00.797Z | 2024-09-02T12:26:02.758Z |
4918736 | 4918736 | 20240809235728_fLjqa | ES0002 | 2024-08-30T12:12:12.803Z | 2024-09-02T12:25:35.569Z |
4918551 | 4918551 | 20240809235400_UAW2i | ES0002 | 2024-08-30T12:12:05.146Z | 2024-09-02T12:25:33.162Z |
4917386 | 4917386 | 20240809233242_dywc4 | ES0002 | 2024-08-30T12:11:23.232Z | 2024-09-02T12:25:01.022Z |
4916221 | 4916221 | 20240809230908_RAJoW | ES0002 | 2024-08-30T12:10:41.124Z | 2024-09-02T12:24:19.100Z |
4916162 | 4916162 | 20240809230809_Vzo28 | ES0002 | 2024-08-30T12:10:39.215Z | 2024-09-02T12:24:16.969Z |
4797311 | 4797311 | 20240802032031_by2np | ES0002 | 2024-08-11T12:16:24.344Z | 2024-08-11T12:16:24.344Z |
4797290 | 4797290 | 20240802031654_i0EZK | ES0002 | 2024-08-11T12:16:23.915Z | 2024-08-11T12:16:23.915Z |
4797256 | 4797256 | 20240802031209_pqjfh | ES0002 | 2024-08-11T12:16:23.246Z | 2024-08-11T12:16:23.246Z |
4797216 | 4797216 | 20240802030706_bogWi | ES0002 | 2024-08-11T12:16:22.219Z | 2024-08-11T12:16:22.219Z |
4796933 | 4796933 | 20240802024047_2JfhR | ES0002 | 2024-08-11T12:16:14.980Z | 2024-08-11T12:16:14.980Z |
4796082 | 4796082 | 20240802015513_dZG9P | ES0002 | 2024-08-11T12:15:56.885Z | 2024-08-11T12:15:56.885Z |
4795786 | 4795786 | 20240802014235_CYyky | ES0002 | 2024-08-11T12:15:49.047Z | 2024-08-11T12:15:49.047Z |
4795444 | 4795444 | 20240802012709_VEwXo | ES0002 | 2024-08-11T12:15:30.905Z | 2024-08-11T12:15:30.905Z |
4795373 | 4795373 | 20240802012322_xNCtG | ES0002 | 2024-08-11T12:15:25.778Z | 2024-08-11T12:15:25.778Z |
4795346 | 4795346 | 20240802012243_f203d | ES0002 | 2024-08-11T12:15:23.404Z | 2024-08-11T12:15:23.404Z |
4795328 | 4795328 | 20240802012206_om9Bh | ES0002 | 2024-08-11T12:15:22.905Z | 2024-08-11T12:15:22.905Z |
4795282 | 4795282 | 20240802011952_qyjLe | ES0002 | 2024-08-11T12:15:20.643Z | 2024-08-11T12:15:20.643Z |
4795198 | 4795198 | 20240802011511_0SrV3 | ES0002 | 2024-08-11T12:15:15.639Z | 2024-08-11T12:15:15.639Z |
4787209 | 4787209 | 20240802051818_DxqNt | ES0002 | 2024-08-11T12:01:18.704Z | 2024-08-13T12:15:21.819Z |
4787160 | 4787160 | 20240802050101_AmBWv | ES0002 | 2024-08-11T12:01:03.972Z | 2024-08-13T12:15:20.301Z |
4787146 | 4787146 | 20240802045554_5S2Bc | ES0002 | 2024-08-11T12:01:01.149Z | 2024-08-13T12:15:19.361Z |
4787144 | 4787144 | 20240802045503_n2xzX | ES0002 | 2024-08-11T12:01:00.737Z | 2024-08-13T12:15:19.290Z |
4787102 | 4787102 | 20240802043830_2Wzpq | ES0002 | 2024-08-11T12:00:54.043Z | 2024-08-13T12:15:18.239Z |
4787092 | 4787092 | 20240802043319_QtI03 | ES0002 | 2024-08-11T12:00:52.648Z | 2024-08-13T12:15:18.121Z |
4787085 | 4787085 | 20240802043129_AkKRI | ES0002 | 2024-08-11T12:00:51.538Z | 2024-08-13T12:15:17.832Z |
4787081 | 4787081 | 20240802043016_vulPF | ES0002 | 2024-08-11T12:00:50.739Z | 2024-08-13T12:15:17.617Z |
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);