participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,857 rows where station_code = "UK00BE" 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 |
---|---|---|---|---|---|
5019795 | 5019795 | 20240904235110_t54YM | UK00BE | 2024-09-10T12:13:32.700Z | 2024-09-13T12:19:53.816Z |
5019737 | 5019737 | 20240904234404_On5Ic | UK00BE | 2024-09-10T12:13:22.787Z | 2024-09-13T12:19:53.667Z |
5009901 | 5009901 | 20240904021313_e1CH3 | UK00BE | 2024-09-09T12:08:12.867Z | 2024-09-12T12:19:24.910Z |
5009803 | 5009803 | 20240904020228_zwUqE | UK00BE | 2024-09-09T12:08:02.066Z | 2024-09-12T12:19:24.475Z |
5009537 | 5009537 | 20240904013222_LkLAp | UK00BE | 2024-09-09T12:07:48.710Z | 2024-09-12T12:19:23.258Z |
5009275 | 5009275 | 20240904010741_DaJDU | UK00BE | 2024-09-09T12:07:33.070Z | 2024-09-12T12:19:22.240Z |
5009165 | 5009165 | 20240904010135_YR4nJ | UK00BE | 2024-09-09T12:07:28.364Z | 2024-09-12T12:19:21.870Z |
5009063 | 5009063 | 20240904005044_57zfU | UK00BE | 2024-09-09T12:07:22.954Z | 2024-09-12T12:19:21.285Z |
5008938 | 5008938 | 20240904003806_i58kE | UK00BE | 2024-09-09T12:07:16.186Z | 2024-09-12T12:19:20.801Z |
5008929 | 5008929 | 20240904003800_cMfP5 | UK00BE | 2024-09-09T12:07:16.062Z | 2024-09-12T12:19:20.689Z |
5008597 | 5008597 | 20240904000202_kSBgV | UK00BE | 2024-09-09T12:06:54.808Z | 2024-09-12T12:19:18.298Z |
5008420 | 5008420 | 20240903234206_Lodrw | UK00BE | 2024-09-09T12:06:43.540Z | 2024-09-12T12:19:17.541Z |
5008326 | 5008326 | 20240903233335_57dui | UK00BE | 2024-09-09T12:06:37.647Z | 2024-09-12T12:19:17.116Z |
5008030 | 5008030 | 20240903225428_ICDHc | UK00BE | 2024-09-09T12:06:19.614Z | 2024-09-12T12:19:15.871Z |
4991945 | 4991945 | 20240901035315_3R9uu | UK00BE | 2024-09-07T12:12:41.623Z | 2024-09-09T12:27:33.888Z |
4991890 | 4991890 | 20240901033521_pJRIQ | UK00BE | 2024-09-07T12:12:36.395Z | 2024-09-09T12:27:29.697Z |
4990106 | 4990106 | 20240831232719_oWSWk | UK00BE | 2024-09-07T12:10:02.220Z | 2024-09-09T12:26:10.806Z |
4989850 | 4989850 | 20240831224531_kugKU | UK00BE | 2024-09-07T12:09:43.001Z | 2024-09-09T12:26:00.610Z |
4983251 | 4983251 | 20240812004226_8OJQU | UK00BE | 2024-09-06T12:15:22.301Z | 2024-09-06T12:15:22.301Z |
4982489 | 4982489 | 20240812003359_G4i2n | UK00BE | 2024-09-06T12:14:53.251Z | 2024-09-06T12:14:53.251Z |
4982416 | 4982416 | 20240812003325_nDtLD | UK00BE | 2024-09-06T12:14:50.625Z | 2024-09-06T12:14:50.625Z |
4982155 | 4982155 | 20240812003044_07IR3 | UK00BE | 2024-09-06T12:14:43.830Z | 2024-09-06T12:14:43.830Z |
4982047 | 4982047 | 20240812002928_MO0ni | UK00BE | 2024-09-06T12:14:41.787Z | 2024-09-06T12:14:41.787Z |
4981775 | 4981775 | 20240812002719_zdGmG | UK00BE | 2024-09-06T12:14:37.479Z | 2024-09-06T12:14:37.479Z |
4981127 | 4981127 | 20240812001855_i2PYB | UK00BE | 2024-09-06T12:14:26.692Z | 2024-09-06T12:14:26.692Z |
4981045 | 4981045 | 20240812001827_rDhIB | UK00BE | 2024-09-06T12:14:25.760Z | 2024-09-06T12:14:25.760Z |
4980243 | 4980243 | 20240812001017_yEdXJ | UK00BE | 2024-09-06T12:13:54.011Z | 2024-09-06T12:13:54.011Z |
4980116 | 4980116 | 20240812000843_8vUOC | UK00BE | 2024-09-06T12:13:47.765Z | 2024-09-06T12:13:47.765Z |
4979884 | 4979884 | 20240812000550_3E6Uo | UK00BE | 2024-09-06T12:13:33.315Z | 2024-09-06T12:13:33.315Z |
4979750 | 4979750 | 20240812000429_LoqMZ | UK00BE | 2024-09-06T12:13:26.532Z | 2024-09-06T12:13:26.532Z |
4979699 | 4979699 | 20240812000340_BHBlA | UK00BE | 2024-09-06T12:13:22.809Z | 2024-09-06T12:13:22.809Z |
4978785 | 4978785 | 20240811235502_ODBJw | UK00BE | 2024-09-06T12:12:42.741Z | 2024-09-06T12:12:42.741Z |
4978690 | 4978690 | 20240811235400_nREc3 | UK00BE | 2024-09-06T12:12:41.001Z | 2024-09-06T12:12:41.001Z |
4978525 | 4978525 | 20240811235209_qSL7q | UK00BE | 2024-09-06T12:12:35.470Z | 2024-09-06T12:12:35.470Z |
4978517 | 4978517 | 20240811235152_Ieya3 | UK00BE | 2024-09-06T12:12:35.334Z | 2024-09-06T12:12:35.334Z |
4978383 | 4978383 | 20240811235028_puOhz | UK00BE | 2024-09-06T12:12:33.096Z | 2024-09-06T12:12:33.096Z |
4978081 | 4978081 | 20240811234748_0CRxz | UK00BE | 2024-09-06T12:12:29.048Z | 2024-09-06T12:12:29.048Z |
4977825 | 4977825 | 20240811234451_d7POk | UK00BE | 2024-09-06T12:12:23.538Z | 2024-09-06T12:12:23.538Z |
4977761 | 4977761 | 20240811234434_cy48V | UK00BE | 2024-09-06T12:12:22.983Z | 2024-09-06T12:12:22.983Z |
4977690 | 4977690 | 20240811234330_i0GDn | UK00BE | 2024-09-06T12:12:21.985Z | 2024-09-06T12:12:21.985Z |
4977615 | 4977615 | 20240811234208_u7NIE | UK00BE | 2024-09-06T12:12:20.691Z | 2024-09-06T12:12:20.691Z |
4977289 | 4977289 | 20240811233828_YChBI | UK00BE | 2024-09-06T12:12:11.292Z | 2024-09-06T12:12:11.292Z |
4977210 | 4977210 | 20240811233718_vtsNl | UK00BE | 2024-09-06T12:12:07.031Z | 2024-09-06T12:12:07.031Z |
4977038 | 4977038 | 20240811233550_V5o1U | UK00BE | 2024-09-06T12:12:01.749Z | 2024-09-06T12:12:01.749Z |
4976717 | 4976717 | 20240811233244_q22I3 | UK00BE | 2024-09-06T12:11:43.781Z | 2024-09-06T12:11:43.781Z |
4975192 | 4975192 | 20240811231554_T68Js | UK00BE | 2024-09-05T12:11:41.483Z | 2024-09-06T12:10:38.425Z |
4974871 | 4974871 | 20240811231213_Ct3tF | UK00BE | 2024-09-05T12:11:33.920Z | 2024-09-06T12:10:33.971Z |
4974422 | 4974422 | 20240811230647_TCUNZ | UK00BE | 2024-09-05T12:11:24.263Z | 2024-09-06T12:10:26.458Z |
4974236 | 4974236 | 20240811230445_SMs7p | UK00BE | 2024-09-05T12:11:21.100Z | 2024-09-06T12:10:23.965Z |
4973740 | 4973740 | 20240811225927_DJQZ7 | UK00BE | 2024-09-05T12:11:07.372Z | 2024-09-06T12:10:03.875Z |
4973437 | 4973437 | 20240811225639_96Z4o | UK00BE | 2024-09-05T12:10:51.106Z | 2024-09-06T12:09:54.346Z |
4973124 | 4973124 | 20240811225342_H5APW | UK00BE | 2024-09-05T12:10:43.028Z | 2024-09-06T12:09:44.275Z |
4972783 | 4972783 | 20240811225029_LFXIm | UK00BE | 2024-09-05T12:10:33.939Z | 2024-09-06T12:09:28.426Z |
4972764 | 4972764 | 20240811225003_tmrxr | UK00BE | 2024-09-05T12:10:33.416Z | 2024-09-06T12:09:27.418Z |
4972058 | 4972058 | 20240811224239_C3pIV | UK00BE | 2024-09-05T12:10:14.681Z | 2024-09-06T12:09:04.194Z |
4971120 | 4971120 | 20240811223209_AcY3K | UK00BE | 2024-09-05T12:09:39.469Z | 2024-09-06T12:08:49.499Z |
4970947 | 4970947 | 20240811222948_Xklqe | UK00BE | 2024-09-05T12:09:34.642Z | 2024-09-06T12:08:46.699Z |
4970748 | 4970748 | 20240811222818_Rfu7g | UK00BE | 2024-09-05T12:09:31.467Z | 2024-09-06T12:08:44.239Z |
4970212 | 4970212 | 20240811222222_XSA31 | UK00BE | 2024-09-05T12:09:21.603Z | 2024-09-06T12:08:30.179Z |
4969407 | 4969407 | 20240811221130_8nkU0 | UK00BE | 2024-09-05T12:08:44.326Z | 2024-09-06T12:07:51.370Z |
4969362 | 4969362 | 20240811221044_5d3ur | UK00BE | 2024-09-05T12:08:43.325Z | 2024-09-06T12:07:50.573Z |
4969182 | 4969182 | 20240811220752_j9c5b | UK00BE | 2024-09-05T12:08:37.057Z | 2024-09-06T12:07:44.070Z |
4969058 | 4969058 | 20240811220605_Xvy0A | UK00BE | 2024-09-05T12:08:34.301Z | 2024-09-06T12:07:41.908Z |
4968821 | 4968821 | 20240811220259_v8mlt | UK00BE | 2024-09-05T12:08:27.618Z | 2024-09-06T12:07:36.703Z |
4968434 | 4968434 | 20240811215826_2J7tH | UK00BE | 2024-09-05T12:08:18.781Z | 2024-09-06T12:07:30.152Z |
4968247 | 4968247 | 20240811215555_qcBeL | UK00BE | 2024-09-05T12:08:08.769Z | 2024-09-06T12:07:26.891Z |
4967917 | 4967917 | 20240811215114_0FxUl | UK00BE | 2024-09-05T12:07:52.686Z | 2024-09-06T12:07:14.628Z |
4967829 | 4967829 | 20240811215037_QVULk | UK00BE | 2024-09-05T12:07:51.590Z | 2024-09-06T12:07:11.976Z |
4967816 | 4967816 | 20240811215008_FxCFX | UK00BE | 2024-09-05T12:07:50.124Z | 2024-09-06T12:07:09.625Z |
4967520 | 4967520 | 20240811214506_3ycBM | UK00BE | 2024-09-05T12:07:40.963Z | 2024-09-06T12:07:01.325Z |
4967295 | 4967295 | 20240811214140_3c3Gq | UK00BE | 2024-09-05T12:07:34.795Z | 2024-09-06T12:06:56.320Z |
4967089 | 4967089 | 20240811213823_K1L0v | UK00BE | 2024-09-05T12:07:29.759Z | 2024-09-06T12:06:52.727Z |
4966971 | 4966971 | 20240811213658_MGwiY | UK00BE | 2024-09-05T12:07:27.259Z | 2024-09-06T12:06:50.973Z |
4966809 | 4966809 | 20240811213344_7M5c5 | UK00BE | 2024-09-05T12:07:14.667Z | 2024-09-06T12:06:47.695Z |
4966613 | 4966613 | 20240811213146_A25Js | UK00BE | 2024-09-04T12:07:30.992Z | 2024-09-06T12:06:37.270Z |
4966335 | 4966335 | 20240811212730_qI7El | UK00BE | 2024-09-04T12:07:24.453Z | 2024-09-06T12:06:24.898Z |
4966142 | 4966142 | 20240811212429_jPibk | UK00BE | 2024-09-04T12:07:18.824Z | 2024-09-06T12:06:14.262Z |
4965735 | 4965735 | 20240811211812_CsWB8 | UK00BE | 2024-09-04T12:07:06.346Z | 2024-09-06T12:06:02.223Z |
4965186 | 4965186 | 20240811211000_QyYUf | UK00BE | 2024-09-04T12:06:51.101Z | 2024-09-06T12:05:50.365Z |
4964675 | 4964675 | 20240811210014_enlaM | UK00BE | 2024-09-04T12:06:31.012Z | 2024-09-06T12:05:27.428Z |
4929319 | 4929319 | 20240810032857_AWrt5 | UK00BE | 2024-08-31T12:21:59.945Z | 2024-09-02T12:29:31.385Z |
4929299 | 4929299 | 20240810032431_2e58F | UK00BE | 2024-08-31T12:21:58.484Z | 2024-09-02T12:29:30.930Z |
4929163 | 4929163 | 20240810030919_FX2PI | UK00BE | 2024-08-31T12:21:52.941Z | 2024-09-02T12:29:28.321Z |
4929126 | 4929126 | 20240810030620_rKXhE | UK00BE | 2024-08-31T12:21:52.143Z | 2024-09-02T12:29:27.470Z |
4929083 | 4929083 | 20240810030428_Y4rF3 | UK00BE | 2024-08-31T12:21:51.241Z | 2024-09-02T12:29:26.844Z |
4929079 | 4929079 | 20240810030427_XXVZk | UK00BE | 2024-08-31T12:21:51.137Z | 2024-09-02T12:29:26.813Z |
4929062 | 4929062 | 20240810030315_TmOcH | UK00BE | 2024-08-31T12:21:50.495Z | 2024-09-02T12:29:26.400Z |
4929029 | 4929029 | 20240810030114_9NEJm | UK00BE | 2024-08-31T12:21:49.310Z | 2024-09-02T12:29:25.723Z |
4928651 | 4928651 | 20240810024516_SrzyA | UK00BE | 2024-08-31T12:21:32.278Z | 2024-09-02T12:29:13.863Z |
4928633 | 4928633 | 20240810024455_SVwF3 | UK00BE | 2024-08-31T12:21:31.051Z | 2024-09-02T12:29:13.640Z |
4928577 | 4928577 | 20240810024408_PZZid | UK00BE | 2024-08-31T12:21:28.068Z | 2024-09-02T12:29:12.985Z |
4928513 | 4928513 | 20240810024204_4KBFj | UK00BE | 2024-08-31T12:21:24.776Z | 2024-09-02T12:29:11.712Z |
4927924 | 4927924 | 20240810022532_MER2N | UK00BE | 2024-08-31T12:21:04.761Z | 2024-09-02T12:28:53.986Z |
4927660 | 4927660 | 20240810021751_I1wTQ | UK00BE | 2024-08-31T12:20:47.595Z | 2024-09-02T12:28:46.577Z |
4927559 | 4927559 | 20240810021551_uVvao | UK00BE | 2024-08-31T12:20:43.300Z | 2024-09-02T12:28:41.132Z |
4927491 | 4927491 | 20240810021430_Yhn8X | UK00BE | 2024-08-31T12:20:40.046Z | 2024-09-02T12:28:37.402Z |
4927382 | 4927382 | 20240810021135_9zsgg | UK00BE | 2024-08-31T12:20:30.847Z | 2024-09-02T12:28:31.769Z |
4927349 | 4927349 | 20240810021039_pUQxa | UK00BE | 2024-08-31T12:20:27.496Z | 2024-09-02T12:28:30.550Z |
4926965 | 4926965 | 20240810020205_FjPOS | UK00BE | 2024-08-31T12:20:11.009Z | 2024-09-02T12:28:13.008Z |
4926922 | 4926922 | 20240810020119_XVTe3 | UK00BE | 2024-08-31T12:20:09.615Z | 2024-09-02T12:28:11.998Z |
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);