participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
997 rows where station_code = "ES000X" 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 |
---|---|---|---|---|---|
5129779 | 5129779 | 20240917042649_pbP43 | ES000X | 2024-09-19T12:12:03.708Z | 2024-09-19T12:12:03.708Z |
5120416 | 5120416 | 20240914032015_lrYn4 | ES000X | 2024-09-18T12:10:39.700Z | 2024-09-19T12:20:00.188Z |
5120414 | 5120414 | 20240914032014_Y1Knp | ES000X | 2024-09-18T12:10:39.430Z | 2024-09-19T12:20:00.187Z |
5120331 | 5120331 | 20240914031553_sNrSK | ES000X | 2024-09-18T12:10:37.437Z | 2024-09-19T12:19:59.911Z |
5102106 | 5102106 | 20240914010623_O1rMH | ES000X | 2024-09-17T12:06:49.132Z | 2024-09-19T12:19:52.496Z |
5101820 | 5101820 | 20240914004806_Z9Jns | ES000X | 2024-09-17T12:06:14.330Z | 2024-09-19T12:19:51.593Z |
5092842 | 5092842 | 20240912025947_TiRUY | ES000X | 2024-09-16T12:14:05.373Z | 2024-09-19T12:21:14.614Z |
5065297 | 5065297 | 20240910033814_ipun0 | ES000X | 2024-09-14T12:16:55.902Z | 2024-09-18T12:15:18.959Z |
5064504 | 5064504 | 20240910012557_xU9RT | ES000X | 2024-09-14T12:15:34.356Z | 2024-09-18T12:15:16.785Z |
5047476 | 5047476 | 20240909042424_mt9Be | ES000X | 2024-09-13T12:09:08.438Z | 2024-09-17T12:19:02.789Z |
5047413 | 5047413 | 20240909035331_4aopk | ES000X | 2024-09-13T12:08:58.426Z | 2024-09-17T12:19:02.493Z |
5047271 | 5047271 | 20240909032033_Aj2HS | ES000X | 2024-09-13T12:08:44.209Z | 2024-09-17T12:19:01.898Z |
5047148 | 5047148 | 20240909024811_3QTrc | ES000X | 2024-09-13T12:08:23.281Z | 2024-09-17T12:19:01.325Z |
5046560 | 5046560 | 20240909001244_V0J4q | ES000X | 2024-09-13T12:06:56.488Z | 2024-09-17T12:18:59.500Z |
5046353 | 5046353 | 20240908225418_Gs0QT | ES000X | 2024-09-13T12:06:32.418Z | 2024-09-17T12:18:59.131Z |
5045810 | 5045810 | 20240908193055_9fRyS | ES000X | 2024-09-13T12:05:01.515Z | 2024-09-17T12:18:57.413Z |
5040532 | 5040532 | 20240906043816_mASVB | ES000X | 2024-09-12T12:16:15.390Z | 2024-09-14T12:23:09.871Z |
5026613 | 5026613 | 20240905043217_3gmC3 | ES000X | 2024-09-11T12:12:49.168Z | 2024-09-13T12:19:59.072Z |
5026507 | 5026507 | 20240905034632_RRE9Q | ES000X | 2024-09-11T12:12:38.655Z | 2024-09-13T12:19:58.511Z |
5021071 | 5021071 | 20240905043217_OlMY3 | ES000X | 2024-09-10T12:15:13.765Z | 2024-09-10T12:16:55.304Z |
5020967 | 5020967 | 20240905034632_LOyGr | ES000X | 2024-09-10T12:15:09.349Z | 2024-09-10T12:16:55.282Z |
4983020 | 4983020 | 20240812004033_Xf373 | ES000X | 2024-09-06T12:15:12.045Z | 2024-09-06T12:15:12.045Z |
4982922 | 4982922 | 20240812003922_7zgfD | ES000X | 2024-09-06T12:15:07.441Z | 2024-09-06T12:15:07.441Z |
4976306 | 4976306 | 20240811232837_u3sYw | ES000X | 2024-09-06T12:11:24.021Z | 2024-09-06T12:11:24.021Z |
4974496 | 4974496 | 20240811230742_ZDgLo | ES000X | 2024-09-05T12:11:25.617Z | 2024-09-06T12:10:27.452Z |
4967154 | 4967154 | 20240811214020_PFNie | ES000X | 2024-09-05T12:07:32.618Z | 2024-09-06T12:06:54.809Z |
4955152 | 4955152 | 20240811034946_rtd2Q | ES000X | 2024-09-03T12:18:49.991Z | 2024-09-06T12:29:21.554Z |
4955121 | 4955121 | 20240811034313_Z8hg3 | ES000X | 2024-09-03T12:18:45.847Z | 2024-09-06T12:29:19.870Z |
4954921 | 4954921 | 20240811031630_ncDCb | ES000X | 2024-09-03T12:18:26.028Z | 2024-09-06T12:29:11.687Z |
4954136 | 4954136 | 20240811025247_LXpeH | ES000X | 2024-09-03T12:18:08.185Z | 2024-09-06T12:28:50.956Z |
4948795 | 4948795 | 20240811014025_zb5I3 | ES000X | 2024-09-02T12:15:18.704Z | 2024-09-06T12:27:26.991Z |
4947571 | 4947571 | 20240811012048_HtScU | ES000X | 2024-09-02T12:14:37.718Z | 2024-09-06T12:26:54.782Z |
4946467 | 4946467 | 20240811010134_AeD5J | ES000X | 2024-09-02T12:13:56.377Z | 2024-09-06T12:26:23.365Z |
4945682 | 4945682 | 20240811005017_tdK8r | ES000X | 2024-09-02T12:13:23.178Z | 2024-09-06T12:26:02.344Z |
4941322 | 4941322 | 20240810233038_SDnho | ES000X | 2024-09-02T12:10:25.477Z | 2024-09-06T12:23:46.141Z |
4937597 | 4937597 | 20240810215526_glhVL | ES000X | 2024-09-01T12:08:29.573Z | 2024-09-06T12:22:22.403Z |
4937108 | 4937108 | 20240810214007_oheo1 | ES000X | 2024-09-01T12:08:03.145Z | 2024-09-06T12:21:59.548Z |
4929363 | 4929363 | 20240810034603_ZopYM | ES000X | 2024-08-31T12:22:07.585Z | 2024-09-02T12:29:32.627Z |
4926570 | 4926570 | 20240810015234_XDkgL | ES000X | 2024-08-31T12:19:44.420Z | 2024-09-02T12:27:55.728Z |
4921554 | 4921554 | 20240810005800_Cpaih | ES000X | 2024-08-30T12:14:14.571Z | 2024-09-02T12:27:05.550Z |
4921307 | 4921307 | 20240810005143_wTjtz | ES000X | 2024-08-30T12:14:03.984Z | 2024-09-02T12:26:55.640Z |
4920840 | 4920840 | 20240810003939_ZpqqH | ES000X | 2024-08-30T12:13:41.046Z | 2024-09-02T12:26:40.717Z |
4919379 | 4919379 | 20240810001114_B4WRI | ES000X | 2024-08-30T12:12:42.063Z | 2024-09-02T12:25:51.252Z |
4919208 | 4919208 | 20240810000627_Uh5R0 | ES000X | 2024-08-30T12:12:34.331Z | 2024-09-02T12:25:42.734Z |
4902531 | 4902531 | 20240808021637_5Rt2t | ES000X | 2024-08-28T12:19:20.080Z | 2024-08-28T12:19:20.080Z |
4901578 | 4901578 | 20240808013810_vYhxC | ES000X | 2024-08-28T12:18:47.173Z | 2024-08-28T12:18:47.173Z |
4901054 | 4901054 | 20240808010240_j6soi | ES000X | 2024-08-28T12:18:32.231Z | 2024-08-28T12:18:32.231Z |
4900435 | 4900435 | 20240808002412_gUOia | ES000X | 2024-08-28T12:18:03.858Z | 2024-08-28T12:18:03.858Z |
4900138 | 4900138 | 20240807235347_Ugrqh | ES000X | 2024-08-28T12:17:50.607Z | 2024-08-28T12:17:50.607Z |
4892603 | 4892603 | 20240809040027_1XqUO | ES000X | 2024-08-28T12:10:24.310Z | 2024-08-30T12:22:19.607Z |
4891710 | 4891710 | 20240809013050_9vgX1 | ES000X | 2024-08-28T12:09:18.322Z | 2024-08-30T12:21:22.722Z |
4891670 | 4891670 | 20240809012616_32iOr | ES000X | 2024-08-28T12:09:16.099Z | 2024-08-30T12:21:21.425Z |
4891047 | 4891047 | 20240809002023_JAxQK | ES000X | 2024-08-28T12:08:32.005Z | 2024-08-30T12:20:52.100Z |
4889781 | 4889781 | 20240808214808_T9h9W | ES000X | 2024-08-28T12:06:44.707Z | 2024-08-30T12:19:38.279Z |
4889775 | 4889775 | 20240808214711_jtvkk | ES000X | 2024-08-28T12:06:44.165Z | 2024-08-30T12:19:37.433Z |
4884586 | 4884586 | 20240807034925_xOTN8 | ES000X | 2024-08-20T12:15:45.159Z | 2024-08-27T12:16:23.250Z |
4876563 | 4876563 | 20240806234140_Ylzr2 | ES000X | 2024-08-19T12:12:55.944Z | 2024-08-27T12:12:45.053Z |
4871584 | 4871584 | 20240806205001_ZlwuA | ES000X | 2024-08-19T12:09:15.605Z | 2024-08-27T12:09:53.367Z |
4833156 | 4833156 | 20240805000639_yy17c | ES000X | 2024-08-15T12:13:41.146Z | 2024-08-17T12:31:25.303Z |
4826471 | 4826471 | 20240804033455_Rezjb | ES000X | 2024-08-14T12:21:08.047Z | 2024-08-15T12:26:19.798Z |
4825521 | 4825521 | 20240804012021_F4gBK | ES000X | 2024-08-14T12:20:11.972Z | 2024-08-15T12:25:54.264Z |
4825351 | 4825351 | 20240804010611_n1tSK | ES000X | 2024-08-14T12:20:03.778Z | 2024-08-15T12:25:49.875Z |
4797184 | 4797184 | 20240802030202_NPXyn | ES000X | 2024-08-11T12:16:21.170Z | 2024-08-11T12:16:21.170Z |
4786312 | 4786312 | 20240802005641_eX6gP | ES000X | 2024-08-10T12:16:52.287Z | 2024-08-11T12:15:02.317Z |
4785502 | 4785502 | 20240802002019_ovsZM | ES000X | 2024-08-10T12:16:05.449Z | 2024-08-11T12:14:48.220Z |
4780074 | 4780074 | 20240801014355_m1HWj | ES000X | 2024-08-07T12:14:48.285Z | 2024-08-10T12:21:45.908Z |
4778507 | 4778507 | 20240731230509_woFPn | ES000X | 2024-08-07T12:13:47.484Z | 2024-08-10T12:21:06.941Z |
4778334 | 4778334 | 20240731224324_CrRnd | ES000X | 2024-08-07T12:13:41.781Z | 2024-08-10T12:21:04.154Z |
4769430 | 4769430 | 20240731203532_1T4YA | ES000X | 2024-08-06T12:10:52.711Z | 2024-08-10T12:20:35.458Z |
4762318 | 4762318 | 20240731015935_DB8m6 | ES000X | 2024-08-06T12:02:16.980Z | 2024-08-10T12:17:42.310Z |
4760129 | 4760129 | 20240730232609_IoZ90 | ES000X | 2024-08-05T12:15:49.014Z | 2024-08-08T12:24:26.843Z |
4758873 | 4758873 | 20240730222414_UEmK3 | ES000X | 2024-08-05T12:14:44.971Z | 2024-08-08T12:23:44.604Z |
4717357 | 4717357 | 20240728015727_Xe0PT | ES000X | 2024-07-30T12:08:25.707Z | 2024-08-05T12:19:51.773Z |
4695638 | 4695638 | 20240726220900_9eAOK | ES000X | 2024-07-28T12:01:30.373Z | 2024-08-04T12:19:07.463Z |
4689707 | 4689707 | 20240725221016_4P73n | ES000X | 2024-07-27T12:01:29.372Z | 2024-08-03T12:21:03.362Z |
4680212 | 4680212 | 20240723202653_E4ado | ES000X | 2024-07-25T12:01:25.896Z | 2024-08-01T12:12:01.175Z |
4658567 | 4658567 | 20240716024143_6Yi0f | ES000X | 2024-07-18T12:10:04.294Z | 2024-07-24T12:17:23.637Z |
4658565 | 4658565 | 20240716024101_0jRCI | ES000X | 2024-07-18T12:10:04.182Z | 2024-07-24T12:17:23.598Z |
4658443 | 4658443 | 20240716015756_vQhG1 | ES000X | 2024-07-18T12:09:59.640Z | 2024-07-24T12:17:22.128Z |
4654301 | 4654301 | 20240716222731_JlMnW | ES000X | 2024-07-18T12:04:21.288Z | 2024-07-25T12:13:51.143Z |
4628048 | 4628048 | 20240712033806_qiA2K | ES000X | 2024-07-14T12:09:09.766Z | 2024-07-20T12:13:18.087Z |
4627959 | 4627959 | 20240712015247_zCmAW | ES000X | 2024-07-14T12:09:03.589Z | 2024-07-20T12:13:17.458Z |
4627477 | 4627477 | 20240711232452_rQ7wy | ES000X | 2024-07-14T12:08:20.894Z | 2024-07-20T12:13:14.978Z |
4627303 | 4627303 | 20240711221501_sUQij | ES000X | 2024-07-14T12:08:03.482Z | 2024-07-20T12:13:13.917Z |
4619991 | 4619991 | 20240711011449_xbk9Z | ES000X | 2024-07-13T12:09:00.221Z | 2024-07-19T12:13:42.634Z |
4611695 | 4611695 | 20240710013427_ADMZL | ES000X | 2024-07-12T12:06:59.318Z | 2024-07-18T12:16:59.323Z |
4562717 | 4562717 | 20240705011730_2JUtS | ES000X | 2024-07-07T12:03:53.157Z | 2024-07-13T12:12:49.044Z |
4554030 | 4554030 | 20240704023906_6rJuD | ES000X | 2024-07-06T12:03:04.633Z | 2024-07-12T12:08:54.050Z |
4538377 | 4538377 | 20240703002236_3ZRHb | ES000X | 2024-07-04T12:02:11.673Z | 2024-07-11T12:14:35.233Z |
4537996 | 4537996 | 20240702211752_rO58C | ES000X | 2024-07-04T12:01:33.366Z | 2024-07-11T12:14:32.988Z |
4534808 | 4534808 | 20240702013806_zxj92 | ES000X | 2024-07-03T12:01:45.761Z | 2024-07-10T12:15:25.880Z |
4534770 | 4534770 | 20240702010426_5EJBd | ES000X | 2024-07-03T12:01:40.818Z | 2024-07-10T12:15:25.495Z |
4526500 | 4526500 | 20240629234126_9L5AV | ES000X | 2024-07-01T12:03:21.214Z | 2024-07-08T12:11:49.119Z |
4494215 | 4494215 | 20240622020225_lu9ZL | ES000X | 2024-06-23T12:02:37.382Z | 2024-06-30T12:09:38.563Z |
4492506 | 4492506 | 20240621010214_A8jV7 | ES000X | 2024-06-22T12:05:45.411Z | 2024-06-29T12:13:34.806Z |
4489765 | 4489765 | 20240619023353_Rg0D6 | ES000X | 2024-06-21T12:08:23.517Z | 2024-06-27T12:11:35.799Z |
4465685 | 4465685 | 20240614025412_4inXp | ES000X | 2024-06-16T12:05:28.779Z | 2024-06-22T12:16:23.610Z |
4415988 | 4415988 | 20240604224124_zA6ZZ | ES000X | 2024-06-06T12:05:41.497Z | 2024-06-13T12:08:31.440Z |
4407018 | 4407018 | 20240603030246_DjCuz | ES000X | 2024-06-04T12:07:10.776Z | 2024-06-11T12:13:39.934Z |
4394271 | 4394271 | 20240530015423_zt3Io | ES000X | 2024-05-31T12:09:48.267Z | 2024-06-07T12:16:06.550Z |
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);