participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
501 rows where station_code = "ES0015" 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 |
---|---|---|---|---|---|
5282678 | 5282678 | 20241010225906_TXoI1 | ES0015 | 2024-10-12T12:15:54.934Z | 2024-10-19T12:27:45.121Z |
5199037 | 5199037 | 20240929212341_14Z1W | ES0015 | 2024-10-01T12:15:37.500Z | 2024-10-07T12:21:37.275Z |
5195113 | 5195113 | 20240930045550_Gfkq2 | ES0015 | 2024-10-01T12:03:24.629Z | 2024-10-09T12:29:02.027Z |
5194908 | 5194908 | 20240930032905_GSKdV | ES0015 | 2024-10-01T12:02:35.670Z | 2024-10-09T12:29:01.412Z |
5182669 | 5182669 | 20240927230846_QRbET | ES0015 | 2024-09-29T12:16:10.928Z | 2024-10-05T12:29:08.947Z |
5179559 | 5179559 | 20240928042207_723Ge | ES0015 | 2024-09-29T12:08:12.316Z | 2024-10-06T12:28:04.402Z |
5169794 | 5169794 | 20240927031101_pEEl4 | ES0015 | 2024-09-28T12:04:05.092Z | 2024-10-05T12:28:33.898Z |
5169733 | 5169733 | 20240927025816_zT3iJ | ES0015 | 2024-09-28T12:03:54.193Z | 2024-10-05T12:28:33.558Z |
5133552 | 5133552 | 20240916033920_fP33f | ES0015 | 2024-09-19T12:17:01.423Z | 2024-09-24T12:15:50.126Z |
5133012 | 5133012 | 20240916024227_q386K | ES0015 | 2024-09-19T12:16:40.945Z | 2024-09-24T12:15:46.643Z |
5132566 | 5132566 | 20240916013301_sOwl8 | ES0015 | 2024-09-19T12:16:19.222Z | 2024-09-24T12:15:43.479Z |
5129791 | 5129791 | 20240917042953_UZrPk | ES0015 | 2024-09-19T12:12:05.062Z | 2024-09-25T12:22:32.977Z |
5117506 | 5117506 | 20240915044950_dMDlG | ES0015 | 2024-09-18T12:07:43.701Z | 2024-09-23T12:16:25.455Z |
5117471 | 5117471 | 20240915043809_DH6rm | ES0015 | 2024-09-18T12:07:42.316Z | 2024-09-23T12:16:25.037Z |
5116922 | 5116922 | 20240915035059_72G3U | ES0015 | 2024-09-18T12:07:26.332Z | 2024-09-23T12:16:23.334Z |
5116754 | 5116754 | 20240915033922_K2pfi | ES0015 | 2024-09-18T12:07:19.790Z | 2024-09-23T12:16:22.812Z |
5114580 | 5114580 | 20240915014959_p4OpW | ES0015 | 2024-09-18T12:05:22.767Z | 2024-09-23T12:16:13.765Z |
5114207 | 5114207 | 20240915013114_UpkOF | ES0015 | 2024-09-18T12:05:06.300Z | 2024-09-23T12:16:12.565Z |
5077602 | 5077602 | 20240911010514_Fy8XI | ES0015 | 2024-09-15T12:14:53.731Z | 2024-09-19T12:21:39.397Z |
5069544 | 5069544 | 20240910215036_Xzs24 | ES0015 | 2024-09-14T12:19:59.708Z | 2024-09-19T12:21:35.054Z |
5063792 | 5063792 | 20240909224442_uXTJT | ES0015 | 2024-09-14T12:14:22.692Z | 2024-09-18T12:15:14.793Z |
5063748 | 5063748 | 20240909223241_5d62h | ES0015 | 2024-09-14T12:14:18.633Z | 2024-09-18T12:15:14.481Z |
5060616 | 5060616 | 20240910204327_TvPKr | ES0015 | 2024-09-14T12:09:12.775Z | 2024-09-19T12:21:33.127Z |
5053375 | 5053375 | 20240908002157_NJHhb | ES0015 | 2024-09-13T12:16:02.027Z | 2024-09-16T12:21:10.447Z |
5047180 | 5047180 | 20240909025723_Hq34t | ES0015 | 2024-09-13T12:08:35.802Z | 2024-09-17T12:19:01.459Z |
5046861 | 5046861 | 20240909013950_h3dnf | ES0015 | 2024-09-13T12:07:40.363Z | 2024-09-17T12:19:00.514Z |
5046616 | 5046616 | 20240909002607_mVXTi | ES0015 | 2024-09-13T12:07:08.073Z | 2024-09-17T12:18:59.618Z |
5046386 | 5046386 | 20240908231342_flqBL | ES0015 | 2024-09-13T12:06:36.137Z | 2024-09-17T12:18:59.308Z |
5032492 | 5032492 | 20240907010809_F5WmQ | ES0015 | 2024-09-12T12:07:24.335Z | 2024-09-15T12:21:26.600Z |
5019779 | 5019779 | 20240904234914_ebo25 | ES0015 | 2024-09-10T12:13:29.473Z | 2024-09-13T12:19:53.766Z |
4981555 | 4981555 | 20240812002345_Hb1zS | ES0015 | 2024-09-06T12:14:33.362Z | 2024-09-06T12:14:33.362Z |
4975304 | 4975304 | 20240811231657_yEwIM | ES0015 | 2024-09-05T12:11:44.749Z | 2024-09-06T12:10:39.687Z |
4973004 | 4973004 | 20240811225236_PYsmA | ES0015 | 2024-09-05T12:10:40.648Z | 2024-09-06T12:09:38.914Z |
4971077 | 4971077 | 20240811223147_ztMMV | ES0015 | 2024-09-05T12:09:36.951Z | 2024-09-06T12:08:48.639Z |
4954655 | 4954655 | 20240811030750_0f0wJ | ES0015 | 2024-09-03T12:18:18.617Z | 2024-09-06T12:29:05.964Z |
4953401 | 4953401 | 20240811023751_63jDI | ES0015 | 2024-09-03T12:17:39.894Z | 2024-09-06T12:28:25.845Z |
4926862 | 4926862 | 20240810015932_ukOhG | ES0015 | 2024-08-31T12:20:07.272Z | 2024-09-02T12:28:08.561Z |
4921909 | 4921909 | 20240810010510_Qxn2s | ES0015 | 2024-08-30T12:14:24.761Z | 2024-09-02T12:27:16.552Z |
4915631 | 4915631 | 20240809225328_WWTVC | ES0015 | 2024-08-30T12:10:07.513Z | 2024-09-02T12:23:59.231Z |
4913238 | 4913238 | 20240809214245_5Y4QV | ES0015 | 2024-08-29T12:09:02.664Z | 2024-09-02T12:22:46.762Z |
4912008 | 4912008 | 20240809205138_krsO9 | ES0015 | 2024-08-29T12:08:04.636Z | 2024-09-02T12:22:06.175Z |
4898050 | 4898050 | 20240807204300_2kz4c | ES0015 | 2024-08-28T12:16:11.446Z | 2024-08-28T12:16:11.446Z |
4855212 | 4855212 | 20240806002919_sfIJb | ES0015 | 2024-08-17T12:19:44.377Z | 2024-08-19T12:26:30.219Z |
4852621 | 4852621 | 20240805220805_LER8J | ES0015 | 2024-08-17T12:16:20.202Z | 2024-08-19T12:24:28.776Z |
4847440 | 4847440 | 20240805034709_oinIq | ES0015 | 2024-08-16T12:20:51.958Z | 2024-08-17T12:33:01.431Z |
4847383 | 4847383 | 20240805032344_6sStH | ES0015 | 2024-08-16T12:20:43.947Z | 2024-08-17T12:32:58.893Z |
4847359 | 4847359 | 20240805031727_KRKSU | ES0015 | 2024-08-16T12:20:41.125Z | 2024-08-17T12:32:58.030Z |
4847323 | 4847323 | 20240805030540_XBd7q | ES0015 | 2024-08-16T12:20:37.124Z | 2024-08-17T12:32:56.979Z |
4836712 | 4836712 | 20240805022627_c22Hb | ES0015 | 2024-08-15T12:16:17.716Z | 2024-08-17T12:32:45.784Z |
4836290 | 4836290 | 20240805021248_UOl8K | ES0015 | 2024-08-15T12:16:06.258Z | 2024-08-17T12:32:36.057Z |
4836207 | 4836207 | 20240805020847_E2DiD | ES0015 | 2024-08-15T12:16:02.891Z | 2024-08-17T12:32:32.848Z |
4834539 | 4834539 | 20240805010154_LuEAy | ES0015 | 2024-08-15T12:14:46.342Z | 2024-08-17T12:31:58.281Z |
4834393 | 4834393 | 20240805005506_SsTXx | ES0015 | 2024-08-15T12:14:39.880Z | 2024-08-17T12:31:55.281Z |
4830278 | 4830278 | 20240804212535_2ZNTG | ES0015 | 2024-08-15T12:10:17.409Z | 2024-08-17T12:29:40.675Z |
4826528 | 4826528 | 20240804040226_GFajj | ES0015 | 2024-08-14T12:21:10.842Z | 2024-08-15T12:26:20.849Z |
4826483 | 4826483 | 20240804034245_Bygd6 | ES0015 | 2024-08-14T12:21:08.617Z | 2024-08-15T12:26:19.983Z |
4826409 | 4826409 | 20240804030957_oPEMl | ES0015 | 2024-08-14T12:21:00.289Z | 2024-08-15T12:26:18.074Z |
4826282 | 4826282 | 20240804023402_hzPXn | ES0015 | 2024-08-14T12:20:53.882Z | 2024-08-15T12:26:14.192Z |
4825439 | 4825439 | 20240804011434_2IufF | ES0015 | 2024-08-14T12:20:06.805Z | 2024-08-15T12:25:51.558Z |
4824866 | 4824866 | 20240804002415_7db2v | ES0015 | 2024-08-14T12:19:37.246Z | 2024-08-15T12:25:38.753Z |
4822077 | 4822077 | 20240803205946_TEpTN | ES0015 | 2024-08-14T12:16:34.979Z | 2024-08-15T12:24:08.700Z |
4797003 | 4797003 | 20240802024618_cujFR | ES0015 | 2024-08-11T12:16:16.460Z | 2024-08-11T12:16:16.460Z |
4796023 | 4796023 | 20240802015241_wcBS4 | ES0015 | 2024-08-11T12:15:55.022Z | 2024-08-11T12:15:55.022Z |
4786093 | 4786093 | 20240802004607_ndih2 | ES0015 | 2024-08-10T12:16:38.192Z | 2024-08-11T12:14:58.283Z |
4784283 | 4784283 | 20240801232136_G7581 | ES0015 | 2024-08-10T12:14:51.105Z | 2024-08-11T12:14:26.830Z |
4783815 | 4783815 | 20240801225213_D7knz | ES0015 | 2024-08-10T12:14:18.429Z | 2024-08-11T12:14:18.108Z |
4780166 | 4780166 | 20240801015251_77SNA | ES0015 | 2024-08-07T12:14:52.196Z | 2024-08-10T12:21:47.095Z |
4778966 | 4778966 | 20240731235644_ULJDQ | ES0015 | 2024-08-07T12:14:08.300Z | 2024-08-10T12:21:19.151Z |
4778734 | 4778734 | 20240731233131_vhd30 | ES0015 | 2024-08-07T12:13:58.199Z | 2024-08-10T12:21:13.352Z |
4778510 | 4778510 | 20240731230536_xBeto | ES0015 | 2024-08-07T12:13:47.521Z | 2024-08-10T12:21:07.135Z |
4778314 | 4778314 | 20240731223939_5SsYj | ES0015 | 2024-08-07T12:13:41.306Z | 2024-08-10T12:21:03.931Z |
4771541 | 4771541 | 20240801024647_Cj9pt | ES0015 | 2024-08-07T12:00:42.444Z | 2024-08-11T12:10:46.863Z |
4769539 | 4769539 | 20240731205619_je6lA | ES0015 | 2024-08-06T12:10:58.641Z | 2024-08-10T12:20:39.161Z |
4761705 | 4761705 | 20240731012859_SEKPj | ES0015 | 2024-08-06T12:00:55.704Z | 2024-08-10T12:17:25.641Z |
4471775 | 4471775 | 20240616024432_722LO | ES0015 | 2024-06-18T12:00:51.506Z | 2024-06-24T12:10:59.752Z |
4471621 | 4471621 | 20240616005720_jRh7f | ES0015 | 2024-06-18T12:00:27.474Z | 2024-06-24T12:10:57.814Z |
4422646 | 4422646 | 20240605023954_sqCsh | ES0015 | 2024-06-07T12:10:06.795Z | 2024-06-13T12:08:34.225Z |
4422544 | 4422544 | 20240605015501_RKlc4 | ES0015 | 2024-06-07T12:10:01.950Z | 2024-06-13T12:08:33.964Z |
4417147 | 4417147 | 20240603235802_IGzQT | ES0015 | 2024-06-06T12:08:50.370Z | 2024-06-12T12:10:39.397Z |
4382400 | 4382400 | 20240526014133_CHxky | ES0015 | 2024-05-28T12:09:46.531Z | 2024-06-03T12:16:59.959Z |
4310199 | 4310199 | 20240507031942_4L2WT | ES0015 | 2024-05-14T12:11:00.407Z | 2024-05-16T12:13:38.071Z |
4266759 | 4266759 | 20240502034440_CNalC | ES0015 | 2024-05-03T12:08:38.410Z | 2024-05-10T12:23:53.116Z |
4234139 | 4234139 | 20240424020139_l43Zf | ES0015 | 2024-04-26T12:00:19.053Z | 2024-05-03T12:19:17.355Z |
4180239 | 4180239 | 20240413030741_4KIyf | ES0015 | 2024-04-14T12:04:29.006Z | 2024-04-21T12:21:44.686Z |
4180151 | 4180151 | 20240413023756_SjdzA | ES0015 | 2024-04-14T12:04:08.333Z | 2024-04-21T12:21:41.430Z |
4180086 | 4180086 | 20240413022234_kZHL2 | ES0015 | 2024-04-14T12:03:58.356Z | 2024-04-21T12:21:40.364Z |
4175872 | 4175872 | 20240412040659_qDq6s | ES0015 | 2024-04-13T12:07:07.498Z | 2024-04-20T12:25:33.065Z |
4175662 | 4175662 | 20240412030152_0ef3V | ES0015 | 2024-04-13T12:06:32.581Z | 2024-04-20T12:25:30.893Z |
4170869 | 4170869 | 20240411021139_vDkpK | ES0015 | 2024-04-12T12:04:05.598Z | 2024-04-19T12:13:19.681Z |
4170714 | 4170714 | 20240411010850_QRAZs | ES0015 | 2024-04-12T12:03:35.657Z | 2024-04-19T12:13:19.214Z |
4170685 | 4170685 | 20240411005151_jvdCU | ES0015 | 2024-04-12T12:03:28.594Z | 2024-04-19T12:13:19.110Z |
4169523 | 4169523 | 20240410013158_J5BLR | ES0015 | 2024-04-11T12:14:50.709Z | 2024-04-18T12:21:15.177Z |
4166727 | 4166727 | 20240410001108_DIL2h | ES0015 | 2024-04-11T12:05:58.089Z | 2024-04-18T12:21:11.410Z |
4142996 | 4142996 | 20240404035103_zRWHR | ES0015 | 2024-04-05T12:03:57.068Z | 2024-04-12T12:19:47.305Z |
4076712 | 4076712 | 20240316014547_O8DVt | ES0015 | 2024-03-17T12:08:04.494Z | 2024-03-24T12:20:46.144Z |
4035679 | 4035679 | 20240306041213_Xn9Sc | ES0015 | 2024-03-07T14:08:24.065Z | 2024-03-14T12:25:25.017Z |
4031232 | 4031232 | 20240305020109_cv1eL | ES0015 | 2024-03-06T14:08:38.582Z | 2024-03-13T12:20:51.917Z |
3982051 | 3982051 | 20240217053026_l8n0j | ES0015 | 2024-02-18T14:08:08.250Z | 2024-02-25T14:18:57.654Z |
3965588 | 3965588 | 20240214012331_3252i | ES0015 | 2024-02-15T14:07:10.657Z | 2024-02-22T14:23:51.921Z |
3928227 | 3928227 | 20240205031820_TFra2 | ES0015 | 2024-02-07T14:10:00.809Z | 2024-02-13T14:27:04.030Z |
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);