participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,850 rows where station_code = "ES0005" 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 |
---|---|---|---|---|---|
5133924 | 5133924 | 20240916041831_sbJ1D | ES0005 | 2024-09-19T12:17:13.201Z | 2024-09-19T12:17:13.201Z |
5133855 | 5133855 | 20240916041137_vfmWB | ES0005 | 2024-09-19T12:17:10.587Z | 2024-09-19T12:17:10.587Z |
5133316 | 5133316 | 20240916032119_1rvmu | ES0005 | 2024-09-19T12:16:54.311Z | 2024-09-19T12:16:54.311Z |
5128280 | 5128280 | 20240917011930_E6GJO | ES0005 | 2024-09-19T12:10:24.613Z | 2024-09-19T12:10:24.613Z |
5128242 | 5128242 | 20240917010850_goJvt | ES0005 | 2024-09-19T12:10:21.418Z | 2024-09-19T12:10:21.418Z |
5127621 | 5127621 | 20240916223652_Ezcjn | ES0005 | 2024-09-19T12:09:26.826Z | 2024-09-19T12:09:26.826Z |
5120224 | 5120224 | 20240914030801_jpaz2 | ES0005 | 2024-09-18T12:10:35.324Z | 2024-09-19T12:19:59.709Z |
5119652 | 5119652 | 20240914024257_hQ7GS | ES0005 | 2024-09-18T12:10:22.994Z | 2024-09-19T12:19:58.651Z |
5119164 | 5119164 | 20240914021448_dm9Vv | ES0005 | 2024-09-18T12:10:17.522Z | 2024-09-19T12:19:57.319Z |
5114972 | 5114972 | 20240915021230_JveNH | ES0005 | 2024-09-18T12:05:47.907Z | 2024-09-19T12:19:00.919Z |
5111956 | 5111956 | 20240914214656_ZmUnR | ES0005 | 2024-09-18T12:02:32.634Z | 2024-09-19T12:18:35.616Z |
5110950 | 5110950 | 20240914193111_AIhHW | ES0005 | 2024-09-18T12:01:13.636Z | 2024-09-19T12:18:24.894Z |
5107569 | 5107569 | 20240913040140_zvpI3 | ES0005 | 2024-09-17T12:13:17.160Z | 2024-09-19T12:20:47.254Z |
5103888 | 5103888 | 20240913014300_WkH9P | ES0005 | 2024-09-17T12:11:15.346Z | 2024-09-19T12:20:40.653Z |
5103119 | 5103119 | 20240914020110_fBHXO | ES0005 | 2024-09-17T12:07:52.391Z | 2024-09-19T12:19:56.636Z |
5101904 | 5101904 | 20240914005502_SuIji | ES0005 | 2024-09-17T12:06:22.838Z | 2024-09-19T12:19:51.855Z |
5098784 | 5098784 | 20240913192757_lVTK4 | ES0005 | 2024-09-17T12:01:35.573Z | 2024-09-19T12:19:41.068Z |
5098043 | 5098043 | 20240913011432_rb32E | ES0005 | 2024-09-16T12:17:18.960Z | 2024-09-19T12:20:39.555Z |
5086491 | 5086491 | 20240912223708_7VpW5 | ES0005 | 2024-09-16T12:05:48.688Z | 2024-09-19T12:20:31.313Z |
5080012 | 5080012 | 20240911032629_Axg31 | ES0005 | 2024-09-15T12:16:45.202Z | 2024-09-19T12:21:42.988Z |
5077022 | 5077022 | 20240911002205_wau3H | ES0005 | 2024-09-15T12:14:18.200Z | 2024-09-19T12:21:37.966Z |
5065062 | 5065062 | 20240910025942_xXUzI | ES0005 | 2024-09-14T12:16:21.372Z | 2024-09-18T12:15:18.286Z |
5064913 | 5064913 | 20240910022905_vNR2o | ES0005 | 2024-09-14T12:16:09.665Z | 2024-09-18T12:15:17.764Z |
5064840 | 5064840 | 20240910021411_ytOqC | ES0005 | 2024-09-14T12:16:05.704Z | 2024-09-18T12:15:17.499Z |
5064549 | 5064549 | 20240910013106_JsNoy | ES0005 | 2024-09-14T12:15:38.391Z | 2024-09-18T12:15:16.827Z |
5064205 | 5064205 | 20240910002256_IC2F1 | ES0005 | 2024-09-14T12:15:03.993Z | 2024-09-18T12:15:15.786Z |
5064176 | 5064176 | 20240910001651_Doe6G | ES0005 | 2024-09-14T12:15:02.377Z | 2024-09-18T12:15:15.745Z |
5047382 | 5047382 | 20240909034628_F7Evt | ES0005 | 2024-09-13T12:08:54.444Z | 2024-09-17T12:19:02.243Z |
5047339 | 5047339 | 20240909033130_23JUB | ES0005 | 2024-09-13T12:08:49.420Z | 2024-09-17T12:19:02.078Z |
5047312 | 5047312 | 20240909032706_Lzvcb | ES0005 | 2024-09-13T12:08:46.764Z | 2024-09-17T12:19:01.982Z |
5047282 | 5047282 | 20240909032254_32MbM | ES0005 | 2024-09-13T12:08:44.596Z | 2024-09-17T12:19:01.913Z |
5047091 | 5047091 | 20240909023636_wx3Ry | ES0005 | 2024-09-13T12:08:16.369Z | 2024-09-17T12:19:01.080Z |
5046803 | 5046803 | 20240909012453_yoxXa | ES0005 | 2024-09-13T12:07:33.392Z | 2024-09-17T12:19:00.383Z |
5046793 | 5046793 | 20240909012316_Vbg5T | ES0005 | 2024-09-13T12:07:32.005Z | 2024-09-17T12:19:00.326Z |
5046747 | 5046747 | 20240909011058_gpIPh | ES0005 | 2024-09-13T12:07:26.132Z | 2024-09-17T12:19:00.225Z |
5046620 | 5046620 | 20240909002645_BIgqT | ES0005 | 2024-09-13T12:07:08.865Z | 2024-09-17T12:18:59.622Z |
5046453 | 5046453 | 20240908233810_JVqFk | ES0005 | 2024-09-13T12:06:43.485Z | 2024-09-17T12:18:59.369Z |
5032443 | 5032443 | 20240907010256_RrzhI | ES0005 | 2024-09-12T12:07:18.738Z | 2024-09-15T12:21:26.464Z |
5026244 | 5026244 | 20240905024704_IycH3 | ES0005 | 2024-09-11T12:12:07.524Z | 2024-09-13T12:19:57.266Z |
5020690 | 5020690 | 20240905024704_qgvs2 | ES0005 | 2024-09-10T12:14:56.591Z | 2024-09-10T12:16:55.216Z |
5006945 | 5006945 | 20240903193323_EG0Lt | ES0005 | 2024-09-09T12:05:14.727Z | 2024-09-12T12:19:10.939Z |
5001298 | 5001298 | 20240902041732_UV4Iv | ES0005 | 2024-09-08T12:16:18.526Z | 2024-09-10T12:19:32.761Z |
5001265 | 5001265 | 20240902040619_a3CEF | ES0005 | 2024-09-08T12:16:17.344Z | 2024-09-10T12:19:32.641Z |
5001245 | 5001245 | 20240902035848_ufmi2 | ES0005 | 2024-09-08T12:16:16.353Z | 2024-09-10T12:19:32.508Z |
5001239 | 5001239 | 20240902035717_xu38p | ES0005 | 2024-09-08T12:16:16.007Z | 2024-09-10T12:19:32.493Z |
5001138 | 5001138 | 20240902033653_66J65 | ES0005 | 2024-09-08T12:16:11.457Z | 2024-09-10T12:19:32.036Z |
5001088 | 5001088 | 20240902033043_saP9l | ES0005 | 2024-09-08T12:16:09.483Z | 2024-09-10T12:19:31.654Z |
5000845 | 5000845 | 20240902025446_0ai5z | ES0005 | 2024-09-08T12:15:55.802Z | 2024-09-10T12:19:30.008Z |
5000709 | 5000709 | 20240902024140_x64ib | ES0005 | 2024-09-08T12:15:37.435Z | 2024-09-10T12:19:29.517Z |
4999636 | 4999636 | 20240902004314_fx7mI | ES0005 | 2024-09-08T12:14:38.708Z | 2024-09-10T12:19:21.379Z |
4979360 | 4979360 | 20240812000120_C1DpV | ES0005 | 2024-09-06T12:13:11.575Z | 2024-09-06T12:13:11.575Z |
4978912 | 4978912 | 20240811235634_fXG8C | ES0005 | 2024-09-06T12:12:44.985Z | 2024-09-06T12:12:44.985Z |
4969617 | 4969617 | 20240811221344_8pGhM | ES0005 | 2024-09-05T12:08:49.664Z | 2024-09-06T12:07:55.730Z |
4969394 | 4969394 | 20240811221126_fUyZF | ES0005 | 2024-09-05T12:08:44.143Z | 2024-09-06T12:07:51.223Z |
4967813 | 4967813 | 20240811215006_pcTmN | ES0005 | 2024-09-05T12:07:49.499Z | 2024-09-06T12:07:09.261Z |
4966599 | 4966599 | 20240811213133_B5MA3 | ES0005 | 2024-09-04T12:07:30.612Z | 2024-09-06T12:06:36.517Z |
4955003 | 4955003 | 20240811032219_rGzM9 | ES0005 | 2024-09-03T12:18:34.025Z | 2024-09-06T12:29:14.512Z |
4954024 | 4954024 | 20240811024938_fyDRG | ES0005 | 2024-09-03T12:18:05.989Z | 2024-09-06T12:28:47.186Z |
4953656 | 4953656 | 20240811024236_Q0xy0 | ES0005 | 2024-09-03T12:17:53.184Z | 2024-09-06T12:28:34.264Z |
4953396 | 4953396 | 20240811023746_MGf5C | ES0005 | 2024-09-03T12:17:39.775Z | 2024-09-06T12:28:25.812Z |
4938285 | 4938285 | 20240810221532_CuG2g | ES0005 | 2024-09-01T12:09:02.573Z | 2024-09-06T12:22:49.183Z |
4936157 | 4936157 | 20240810210302_onWOK | ES0005 | 2024-09-01T12:07:11.575Z | 2024-09-06T12:21:17.918Z |
4929101 | 4929101 | 20240810030456_8ezqu | ES0005 | 2024-08-31T12:21:51.629Z | 2024-09-02T12:29:27.119Z |
4927105 | 4927105 | 20240810020402_jZEmb | ES0005 | 2024-08-31T12:20:16.306Z | 2024-09-02T12:28:17.966Z |
4926692 | 4926692 | 20240810015504_DVvdJ | ES0005 | 2024-08-31T12:19:50.496Z | 2024-09-02T12:28:01.165Z |
4926245 | 4926245 | 20240810014447_Yzn9B | ES0005 | 2024-08-31T12:19:33.193Z | 2024-09-02T12:27:43.854Z |
4919393 | 4919393 | 20240810001119_N3Ps8 | ES0005 | 2024-08-30T12:12:42.991Z | 2024-09-02T12:25:51.515Z |
4918569 | 4918569 | 20240809235420_t3nKT | ES0005 | 2024-08-30T12:12:06.090Z | 2024-09-02T12:25:33.532Z |
4915601 | 4915601 | 20240809225307_2tby1 | ES0005 | 2024-08-30T12:10:05.836Z | 2024-09-02T12:23:58.471Z |
4903698 | 4903698 | 20240808031026_P4zmR | ES0005 | 2024-08-28T12:19:47.412Z | 2024-08-28T12:19:47.412Z |
4903132 | 4903132 | 20240808024256_RE4lj | ES0005 | 2024-08-28T12:19:30.457Z | 2024-08-28T12:19:30.457Z |
4902427 | 4902427 | 20240808021157_ceZNr | ES0005 | 2024-08-28T12:19:17.319Z | 2024-08-28T12:19:17.319Z |
4901891 | 4901891 | 20240808015054_Z42rd | ES0005 | 2024-08-28T12:18:56.224Z | 2024-08-28T12:18:56.224Z |
4901507 | 4901507 | 20240808013430_EO4zS | ES0005 | 2024-08-28T12:18:45.581Z | 2024-08-28T12:18:45.581Z |
4900342 | 4900342 | 20240808001819_DJBGY | ES0005 | 2024-08-28T12:18:01.445Z | 2024-08-28T12:18:01.445Z |
4900319 | 4900319 | 20240808001655_zvyNn | ES0005 | 2024-08-28T12:18:00.802Z | 2024-08-28T12:18:00.802Z |
4900055 | 4900055 | 20240807234803_OBoT8 | ES0005 | 2024-08-28T12:17:44.120Z | 2024-08-28T12:17:44.120Z |
4900050 | 4900050 | 20240807234614_0U2bb | ES0005 | 2024-08-28T12:17:43.303Z | 2024-08-28T12:17:43.303Z |
4899697 | 4899697 | 20240807231433_822qj | ES0005 | 2024-08-28T12:17:25.985Z | 2024-08-28T12:17:25.985Z |
4891713 | 4891713 | 20240809013147_AQDYf | ES0005 | 2024-08-28T12:09:18.510Z | 2024-08-30T12:21:22.803Z |
4891431 | 4891431 | 20240809005828_cteAk | ES0005 | 2024-08-28T12:09:02.867Z | 2024-08-30T12:21:13.430Z |
4890964 | 4890964 | 20240809001112_6hHBU | ES0005 | 2024-08-28T12:08:23.093Z | 2024-08-30T12:20:44.248Z |
4890933 | 4890933 | 20240809000743_K2HmD | ES0005 | 2024-08-28T12:08:21.195Z | 2024-08-30T12:20:41.581Z |
4884084 | 4884084 | 20240807030003_AI2Sv | ES0005 | 2024-08-20T12:15:22.917Z | 2024-08-27T12:16:04.649Z |
4857875 | 4857875 | 20240806033405_U1h83 | ES0005 | 2024-08-17T12:23:12.467Z | 2024-08-19T12:28:25.264Z |
4857807 | 4857807 | 20240806031428_Ax3h2 | ES0005 | 2024-08-17T12:23:05.986Z | 2024-08-19T12:28:23.631Z |
4857643 | 4857643 | 20240806024420_QWEjJ | ES0005 | 2024-08-17T12:22:47.672Z | 2024-08-19T12:28:20.059Z |
4857069 | 4857069 | 20240806020414_o6Q43 | ES0005 | 2024-08-17T12:22:06.219Z | 2024-08-19T12:27:55.298Z |
4857039 | 4857039 | 20240806020314_hx2lB | ES0005 | 2024-08-17T12:22:02.206Z | 2024-08-19T12:27:53.218Z |
4856426 | 4856426 | 20240806013132_B8DBk | ES0005 | 2024-08-17T12:21:14.544Z | 2024-08-19T12:27:25.810Z |
4855922 | 4855922 | 20240806010553_cf5BB | ES0005 | 2024-08-17T12:20:40.885Z | 2024-08-19T12:27:02.725Z |
4853239 | 4853239 | 20240805224422_2UJ33 | ES0005 | 2024-08-17T12:17:10.782Z | 2024-08-19T12:24:50.009Z |
4852047 | 4852047 | 20240805214110_OEh0E | ES0005 | 2024-08-17T12:15:40.313Z | 2024-08-19T12:24:15.459Z |
4851201 | 4851201 | 20240805204805_5YBDH | ES0005 | 2024-08-17T12:14:24.177Z | 2024-08-19T12:23:49.346Z |
4847375 | 4847375 | 20240805032143_uc8Cl | ES0005 | 2024-08-16T12:20:43.020Z | 2024-08-17T12:32:58.670Z |
4847344 | 4847344 | 20240805031439_FCRmy | ES0005 | 2024-08-16T12:20:40.286Z | 2024-08-17T12:32:57.812Z |
4847340 | 4847340 | 20240805031413_jnP2o | ES0005 | 2024-08-16T12:20:39.591Z | 2024-08-17T12:32:57.513Z |
4847304 | 4847304 | 20240805030331_GrcUw | ES0005 | 2024-08-16T12:20:35.365Z | 2024-08-17T12:32:56.660Z |
4837064 | 4837064 | 20240805024545_dPhoK | ES0005 | 2024-08-15T12:16:41.391Z | 2024-08-17T12:32:51.949Z |
4832620 | 4832620 | 20240804234315_3jKwH | ES0005 | 2024-08-15T12:13:06.301Z | 2024-08-17T12:31:11.047Z |
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);