participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,940 rows where station_code = "UK007V" 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 |
---|---|---|---|---|---|
5570512 | 5570512 | 20241120195158_Mn4p4 | UK007V | 2024-11-22T14:15:39.340Z | 2024-11-22T14:19:21.929Z |
5565397 | 5565397 | 20241120042225_8BGbB | UK007V | 2024-11-21T14:18:47.729Z | 2024-11-22T14:21:46.413Z |
5564614 | 5564614 | 20241120031418_BG2qX | UK007V | 2024-11-21T14:17:53.180Z | 2024-11-22T14:21:34.417Z |
5564468 | 5564468 | 20241120025859_ZV0li | UK007V | 2024-11-21T14:17:39.476Z | 2024-11-22T14:21:32.607Z |
5563705 | 5563705 | 20241120015822_YKFTE | UK007V | 2024-11-21T14:16:35.202Z | 2024-11-22T14:21:21.216Z |
5563311 | 5563311 | 20241120011610_KC4wl | UK007V | 2024-11-21T14:15:52.391Z | 2024-11-22T14:21:12.603Z |
5562034 | 5562034 | 20241119224744_802o7 | UK007V | 2024-11-21T14:14:21.087Z | 2024-11-22T14:20:51.813Z |
5561264 | 5561264 | 20241119192510_RqJVD | UK007V | 2024-11-21T14:12:54.288Z | 2024-11-22T14:20:29.211Z |
5558486 | 5558486 | 20241120061428_2WU2U | UK007V | 2024-11-21T14:03:25.277Z | 2024-11-22T14:19:21.239Z |
5531943 | 5531943 | 20241112042132_TEyhF | UK007V | 2024-11-13T14:16:03.174Z | 2024-11-20T14:26:16.386Z |
5528502 | 5528502 | 20241111211303_x7UIP | UK007V | 2024-11-13T14:10:55.438Z | 2024-11-20T14:25:31.422Z |
5528415 | 5528415 | 20241111204407_fQpGg | UK007V | 2024-11-13T14:10:35.882Z | 2024-11-20T14:25:30.233Z |
5453393 | 5453393 | 20241031020833_kQIcv | UK007V | 2024-11-02T12:22:32.912Z | 2024-11-08T14:23:17.243Z |
5444189 | 5444189 | 20241031005630_k22LO | UK007V | 2024-11-01T12:21:08.370Z | 2024-11-08T14:23:14.071Z |
5440727 | 5440727 | 20241030225503_aqQ4K | UK007V | 2024-11-01T12:15:47.568Z | 2024-11-08T14:23:10.531Z |
5407348 | 5407348 | 20241027023236_IfgMF | UK007V | 2024-10-29T12:15:21.865Z | 2024-11-04T14:28:57.354Z |
5406968 | 5406968 | 20241027021426_L90xQ | UK007V | 2024-10-29T12:15:03.381Z | 2024-11-04T14:28:56.736Z |
5405999 | 5405999 | 20241027011200_6Ip7s | UK007V | 2024-10-29T12:13:47.293Z | 2024-11-04T14:28:54.832Z |
5405118 | 5405118 | 20241027001428_SrH8F | UK007V | 2024-10-29T12:12:29.796Z | 2024-11-04T14:28:52.692Z |
5402234 | 5402234 | 20241026190449_cGSb1 | UK007V | 2024-10-29T12:06:43.028Z | 2024-11-04T14:28:43.318Z |
5385106 | 5385106 | 20241024215138_mtP1g | UK007V | 2024-10-27T12:18:24.089Z | 2024-11-02T12:28:29.149Z |
5377649 | 5377649 | 20241024050157_XWYpZ | UK007V | 2024-10-26T12:22:43.064Z | 2024-11-01T12:27:02.692Z |
5377553 | 5377553 | 20241024045658_pIuPJ | UK007V | 2024-10-26T12:22:40.401Z | 2024-11-01T12:27:02.580Z |
5375728 | 5375728 | 20241024032628_ZKq7d | UK007V | 2024-10-26T12:21:37.536Z | 2024-11-01T12:27:01.172Z |
5373019 | 5373019 | 20241024012016_zXKw5 | UK007V | 2024-10-26T12:19:53.929Z | 2024-11-01T12:26:58.096Z |
5366094 | 5366094 | 20241024000427_7yUSb | UK007V | 2024-10-25T12:18:16.099Z | 2024-11-01T12:26:56.744Z |
5364712 | 5364712 | 20241023224856_rwT2V | UK007V | 2024-10-25T12:17:31.409Z | 2024-11-01T12:26:55.597Z |
5363221 | 5363221 | 20241023203730_MUJjd | UK007V | 2024-10-25T12:15:42.350Z | 2024-11-01T12:26:52.964Z |
5351526 | 5351526 | 20241022233517_w0xF3 | UK007V | 2024-10-24T12:17:37.781Z | 2024-10-31T12:30:00.494Z |
5350249 | 5350249 | 20241022212953_nGbG4 | UK007V | 2024-10-24T12:15:31.529Z | 2024-10-31T12:29:57.625Z |
5350069 | 5350069 | 20241022210709_8quwG | UK007V | 2024-10-24T12:15:15.735Z | 2024-10-31T12:29:57.258Z |
5349986 | 5349986 | 20241022205908_0w0DB | UK007V | 2024-10-24T12:15:01.601Z | 2024-10-31T12:29:57.096Z |
5349192 | 5349192 | 20241022193245_J0A7y | UK007V | 2024-10-24T12:13:17.652Z | 2024-10-31T12:29:54.779Z |
5344903 | 5344903 | 20241022045533_MTE3c | UK007V | 2024-10-23T12:18:56.811Z | 2024-10-30T12:26:51.946Z |
5344894 | 5344894 | 20241022045500_VUDx2 | UK007V | 2024-10-23T12:18:56.785Z | 2024-10-30T12:26:51.945Z |
5344593 | 5344593 | 20241022043359_j3IRa | UK007V | 2024-10-23T12:18:42.772Z | 2024-10-30T12:26:51.395Z |
5344360 | 5344360 | 20241022041655_gPp58 | UK007V | 2024-10-23T12:18:33.477Z | 2024-10-30T12:26:51.196Z |
5344293 | 5344293 | 20241022041352_uTSxR | UK007V | 2024-10-23T12:18:30.751Z | 2024-10-30T12:26:51.113Z |
5341262 | 5341262 | 20241022012222_gk3lE | UK007V | 2024-10-23T12:15:34.138Z | 2024-10-30T12:26:46.739Z |
5340656 | 5340656 | 20241022004025_2PaPq | UK007V | 2024-10-23T12:14:46.241Z | 2024-10-30T12:26:46.116Z |
5340551 | 5340551 | 20241022002923_w3FzI | UK007V | 2024-10-23T12:14:38.376Z | 2024-10-30T12:26:45.991Z |
5338621 | 5338621 | 20241021201055_3oH6f | UK007V | 2024-10-23T12:11:29.188Z | 2024-10-30T12:26:42.583Z |
5332576 | 5332576 | 20241020205604_qP5pS | UK007V | 2024-10-22T12:13:38.211Z | 2024-10-29T12:26:33.562Z |
5332389 | 5332389 | 20241020191050_qAG3P | UK007V | 2024-10-22T12:12:50.097Z | 2024-10-29T12:26:33.052Z |
5321420 | 5321420 | 20241018044947_LAGdo | UK007V | 2024-10-19T12:07:24.930Z | 2024-10-26T12:27:56.795Z |
5321164 | 5321164 | 20241018035830_ccUGF | UK007V | 2024-10-19T12:06:58.426Z | 2024-10-26T12:27:56.261Z |
5320999 | 5320999 | 20241018033046_YRGLc | UK007V | 2024-10-19T12:06:32.465Z | 2024-10-26T12:27:56.021Z |
5318726 | 5318726 | 20241017050148_H7FM3 | UK007V | 2024-10-18T12:04:24.572Z | 2024-10-25T12:24:36.643Z |
5318668 | 5318668 | 20241017043233_wO3Fz | UK007V | 2024-10-18T12:04:16.151Z | 2024-10-25T12:24:36.544Z |
5318653 | 5318653 | 20241017042942_DSPpw | UK007V | 2024-10-18T12:04:15.172Z | 2024-10-25T12:24:36.520Z |
5284359 | 5284359 | 20241011023817_yuNQr | UK007V | 2024-10-12T12:17:18.361Z | 2024-10-19T12:27:55.522Z |
5284130 | 5284130 | 20241011022153_EVcpB | UK007V | 2024-10-12T12:17:09.477Z | 2024-10-19T12:27:54.086Z |
5276812 | 5276812 | 20241011051052_wlvF2 | UK007V | 2024-10-12T12:01:46.206Z | 2024-10-20T12:23:14.102Z |
5138451 | 5138451 | 20240919194125_UxnIS | UK007V | 2024-09-21T12:00:19.049Z | 2024-09-28T12:23:07.430Z |
5129770 | 5129770 | 20240917042607_3EGWz | UK007V | 2024-09-19T12:12:03.111Z | 2024-09-25T12:22:32.732Z |
5129404 | 5129404 | 20240917035457_VPmvh | UK007V | 2024-09-19T12:11:34.640Z | 2024-09-25T12:22:30.610Z |
5128863 | 5128863 | 20240917024843_8lfcr | UK007V | 2024-09-19T12:11:04.080Z | 2024-09-25T12:22:27.320Z |
5128701 | 5128701 | 20240917022511_pyqVJ | UK007V | 2024-09-19T12:10:57.603Z | 2024-09-25T12:22:26.559Z |
5128136 | 5128136 | 20240917004738_p3zvx | UK007V | 2024-09-19T12:10:08.468Z | 2024-09-25T12:22:23.494Z |
5127761 | 5127761 | 20240916232351_gO9sb | UK007V | 2024-09-19T12:09:36.753Z | 2024-09-25T12:22:19.446Z |
5127655 | 5127655 | 20240916224526_M9Tpa | UK007V | 2024-09-19T12:09:29.558Z | 2024-09-25T12:22:18.119Z |
5122073 | 5122073 | 20240914043057_QqBh3 | UK007V | 2024-09-18T12:11:05.320Z | 2024-09-22T12:18:03.247Z |
5121683 | 5121683 | 20240914041207_LDHts | UK007V | 2024-09-18T12:10:59.349Z | 2024-09-22T12:18:02.695Z |
5121390 | 5121390 | 20240914035911_Tv6J3 | UK007V | 2024-09-18T12:10:54.723Z | 2024-09-22T12:18:00.559Z |
5121331 | 5121331 | 20240914035815_Xm2fk | UK007V | 2024-09-18T12:10:54.567Z | 2024-09-22T12:18:00.400Z |
5121156 | 5121156 | 20240914035416_WO0B7 | UK007V | 2024-09-18T12:10:52.062Z | 2024-09-22T12:17:59.815Z |
5120967 | 5120967 | 20240914034301_pu1Yj | UK007V | 2024-09-18T12:10:48.930Z | 2024-09-22T12:17:59.368Z |
5116935 | 5116935 | 20240915035106_fqa3m | UK007V | 2024-09-18T12:07:26.453Z | 2024-09-23T12:16:23.335Z |
5116356 | 5116356 | 20240915032341_RXHs5 | UK007V | 2024-09-18T12:06:59.896Z | 2024-09-23T12:16:21.246Z |
5115690 | 5115690 | 20240915024901_cfo4B | UK007V | 2024-09-18T12:06:21.189Z | 2024-09-23T12:16:18.483Z |
5114263 | 5114263 | 20240915013416_YFd5H | UK007V | 2024-09-18T12:05:09.097Z | 2024-09-23T12:16:12.813Z |
5112998 | 5112998 | 20240915001128_05fde | UK007V | 2024-09-18T12:03:50.087Z | 2024-09-23T12:16:06.809Z |
5112985 | 5112985 | 20240915001109_JKPUo | UK007V | 2024-09-18T12:03:49.893Z | 2024-09-23T12:16:06.798Z |
5112960 | 5112960 | 20240915001108_I3lqt | UK007V | 2024-09-18T12:03:49.751Z | 2024-09-23T12:16:06.789Z |
5108148 | 5108148 | 20240913042645_M2B6h | UK007V | 2024-09-17T12:13:31.473Z | 2024-09-21T12:16:37.201Z |
5107919 | 5107919 | 20240913041500_M9G1b | UK007V | 2024-09-17T12:13:25.945Z | 2024-09-21T12:16:36.661Z |
5106602 | 5106602 | 20240913032918_4RKKo | UK007V | 2024-09-17T12:12:57.692Z | 2024-09-21T12:16:33.870Z |
5106045 | 5106045 | 20240913030733_lQoMo | UK007V | 2024-09-17T12:12:39.062Z | 2024-09-21T12:16:31.547Z |
5105951 | 5105951 | 20240913030350_8635I | UK007V | 2024-09-17T12:12:34.439Z | 2024-09-21T12:16:31.322Z |
5105029 | 5105029 | 20240913022811_3jGUA | UK007V | 2024-09-17T12:11:50.580Z | 2024-09-21T12:16:29.024Z |
5104624 | 5104624 | 20240913021743_J37Pr | UK007V | 2024-09-17T12:11:41.383Z | 2024-09-21T12:16:28.644Z |
5103852 | 5103852 | 20240913014220_6dD5N | UK007V | 2024-09-17T12:11:13.377Z | 2024-09-21T12:16:26.206Z |
5101924 | 5101924 | 20240914005527_NzMrf | UK007V | 2024-09-17T12:06:24.077Z | 2024-09-22T12:17:52.214Z |
5101394 | 5101394 | 20240914002224_WXZng | UK007V | 2024-09-17T12:05:40.189Z | 2024-09-22T12:17:51.274Z |
5100766 | 5100766 | 20240913234523_7Nw8T | UK007V | 2024-09-17T12:04:54.854Z | 2024-09-22T12:17:50.241Z |
5100163 | 5100163 | 20240913225901_JMOgI | UK007V | 2024-09-17T12:04:05.388Z | 2024-09-22T12:17:49.217Z |
5099645 | 5099645 | 20240913214413_NYLuO | UK007V | 2024-09-17T12:03:17.396Z | 2024-09-22T12:17:48.085Z |
5099586 | 5099586 | 20240913213756_QKdb2 | UK007V | 2024-09-17T12:03:11.594Z | 2024-09-22T12:17:47.949Z |
5099290 | 5099290 | 20240913205605_cIAgm | UK007V | 2024-09-17T12:02:41.768Z | 2024-09-22T12:17:47.086Z |
5094675 | 5094675 | 20240912041435_23yq3 | UK007V | 2024-09-16T12:14:53.888Z | 2024-09-20T12:21:55.713Z |
5094646 | 5094646 | 20240912041421_mhOs2 | UK007V | 2024-09-16T12:14:53.122Z | 2024-09-20T12:21:55.687Z |
5092763 | 5092763 | 20240912025622_elS9Z | UK007V | 2024-09-16T12:14:03.522Z | 2024-09-20T12:21:51.308Z |
5092706 | 5092706 | 20240912025508_2E2zD | UK007V | 2024-09-16T12:14:02.367Z | 2024-09-20T12:21:51.044Z |
5092563 | 5092563 | 20240912025008_peMth | UK007V | 2024-09-16T12:13:59.638Z | 2024-09-20T12:21:50.750Z |
5092409 | 5092409 | 20240912024433_m5fyE | UK007V | 2024-09-16T12:13:51.850Z | 2024-09-20T12:21:50.332Z |
5092287 | 5092287 | 20240912024205_EW2CV | UK007V | 2024-09-16T12:13:47.547Z | 2024-09-20T12:21:50.115Z |
5091435 | 5091435 | 20240912020942_gADsK | UK007V | 2024-09-16T12:13:06.237Z | 2024-09-20T12:21:47.561Z |
5091024 | 5091024 | 20240912015545_2qpdO | UK007V | 2024-09-16T12:12:46.797Z | 2024-09-20T12:21:46.320Z |
5090524 | 5090524 | 20240912012856_Zeybw | UK007V | 2024-09-16T12:12:22.552Z | 2024-09-20T12:21:45.054Z |
5090479 | 5090479 | 20240912012733_SX3w8 | UK007V | 2024-09-16T12:12:21.535Z | 2024-09-20T12:21:45.013Z |
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);