participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,355 rows where station_code = "UK0087" 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 |
---|---|---|---|---|---|
5570343 | 5570343 | 20241120192032_FHw3j | UK0087 | 2024-11-22T14:15:12.601Z | 2024-11-22T14:19:21.901Z |
5564781 | 5564781 | 20241120032538_YGD1n | UK0087 | 2024-11-21T14:18:02.874Z | 2024-11-22T14:21:36.339Z |
5564492 | 5564492 | 20241120030300_tdre2 | UK0087 | 2024-11-21T14:17:42.057Z | 2024-11-22T14:21:32.807Z |
5564178 | 5564178 | 20241120023502_YHXWw | UK0087 | 2024-11-21T14:17:15.566Z | 2024-11-22T14:21:27.884Z |
5564078 | 5564078 | 20241120022707_BAcfP | UK0087 | 2024-11-21T14:17:07.701Z | 2024-11-22T14:21:26.800Z |
5564027 | 5564027 | 20241120022444_BK3Sv | UK0087 | 2024-11-21T14:17:05.246Z | 2024-11-22T14:21:26.537Z |
5563972 | 5563972 | 20241120021932_xdyhl | UK0087 | 2024-11-21T14:17:00.927Z | 2024-11-22T14:21:25.854Z |
5563295 | 5563295 | 20241120011435_BZLqT | UK0087 | 2024-11-21T14:15:51.443Z | 2024-11-22T14:21:12.537Z |
5563228 | 5563228 | 20241120010724_3ohTp | UK0087 | 2024-11-21T14:15:41.332Z | 2024-11-22T14:21:11.130Z |
5562776 | 5562776 | 20241120001107_JzmB3 | UK0087 | 2024-11-21T14:15:21.567Z | 2024-11-22T14:21:03.893Z |
5562710 | 5562710 | 20241120000441_lzEId | UK0087 | 2024-11-21T14:15:17.604Z | 2024-11-22T14:21:02.746Z |
5558094 | 5558094 | 20241120053638_H7GHG | UK0087 | 2024-11-21T14:02:29.850Z | 2024-11-22T14:19:21.177Z |
5558073 | 5558073 | 20241120053426_GQzDv | UK0087 | 2024-11-21T14:02:26.730Z | 2024-11-22T14:19:21.173Z |
5543395 | 5543395 | 20241115010248_gjNOh | UK0087 | 2024-11-16T14:06:13.995Z | 2024-11-22T14:23:58.794Z |
5543261 | 5543261 | 20241114233349_TkeDf | UK0087 | 2024-11-16T14:05:53.402Z | 2024-11-22T14:23:57.789Z |
5537694 | 5537694 | 20241113000858_Jj3Bz | UK0087 | 2024-11-14T14:12:24.823Z | 2024-11-21T14:26:15.368Z |
5537660 | 5537660 | 20241112235933_XM8F7 | UK0087 | 2024-11-14T14:12:23.099Z | 2024-11-21T14:26:15.161Z |
5537604 | 5537604 | 20241112235324_tScIs | UK0087 | 2024-11-14T14:12:16.289Z | 2024-11-21T14:26:14.937Z |
5537522 | 5537522 | 20241112232938_jckJm | UK0087 | 2024-11-14T14:12:02.724Z | 2024-11-21T14:26:14.006Z |
5532813 | 5532813 | 20241113055734_VG8lK | UK0087 | 2024-11-14T14:00:18.153Z | 2024-11-22T14:24:05.499Z |
5532770 | 5532770 | 20241113054939_SVqPt | UK0087 | 2024-11-14T14:00:09.866Z | 2024-11-22T14:24:04.895Z |
5532692 | 5532692 | 20241112055313_QUoU9 | UK0087 | 2024-11-13T14:17:09.827Z | 2024-11-20T14:26:25.684Z |
5532668 | 5532668 | 20241112054906_NgRzR | UK0087 | 2024-11-13T14:17:07.819Z | 2024-11-20T14:26:25.524Z |
5532345 | 5532345 | 20241112050937_NTM9D | UK0087 | 2024-11-13T14:16:38.189Z | 2024-11-20T14:26:22.131Z |
5531380 | 5531380 | 20241112033443_DYKqa | UK0087 | 2024-11-13T14:15:36.515Z | 2024-11-20T14:26:10.669Z |
5530969 | 5530969 | 20241112030332_0udd3 | UK0087 | 2024-11-13T14:14:56.826Z | 2024-11-20T14:26:05.729Z |
5530883 | 5530883 | 20241112025657_Dqk48 | UK0087 | 2024-11-13T14:14:47.449Z | 2024-11-20T14:26:04.398Z |
5530716 | 5530716 | 20241112023953_DMH7F | UK0087 | 2024-11-13T14:14:30.655Z | 2024-11-20T14:26:02.876Z |
5530670 | 5530670 | 20241112023725_idj2d | UK0087 | 2024-11-13T14:14:27.213Z | 2024-11-20T14:26:02.533Z |
5530629 | 5530629 | 20241112023545_0eS32 | UK0087 | 2024-11-13T14:14:25.277Z | 2024-11-20T14:26:02.037Z |
5530622 | 5530622 | 20241112023534_pgkp6 | UK0087 | 2024-11-13T14:14:25.040Z | 2024-11-20T14:26:02.015Z |
5530614 | 5530614 | 20241112023358_h3TtC | UK0087 | 2024-11-13T14:14:24.880Z | 2024-11-20T14:26:01.997Z |
5529702 | 5529702 | 20241112005723_2IXdj | UK0087 | 2024-11-13T14:13:06.959Z | 2024-11-20T14:25:47.590Z |
5528941 | 5528941 | 20241111231058_WIEDE | UK0087 | 2024-11-13T14:11:44.910Z | 2024-11-20T14:25:37.628Z |
5528807 | 5528807 | 20241111224159_suo6e | UK0087 | 2024-11-13T14:11:27.233Z | 2024-11-20T14:25:36.068Z |
5528493 | 5528493 | 20241111211158_UcsA4 | UK0087 | 2024-11-13T14:10:53.906Z | 2024-11-20T14:25:31.233Z |
5527988 | 5527988 | 20241111190937_kihwN | UK0087 | 2024-11-13T14:09:39.475Z | 2024-11-20T14:25:23.756Z |
5527973 | 5527973 | 20241111190849_nxAeH | UK0087 | 2024-11-13T14:09:39.175Z | 2024-11-20T14:25:23.736Z |
5527660 | 5527660 | 20241111180534_fPQR1 | UK0087 | 2024-11-13T14:08:52.011Z | 2024-11-20T14:25:16.634Z |
5525626 | 5525626 | 20241112055747_0142F | UK0087 | 2024-11-13T14:00:09.916Z | 2024-11-21T14:25:24.392Z |
5423081 | 5423081 | 20241026034134_v9JPh | UK0087 | 2024-10-30T12:24:20.536Z | 2024-11-03T14:27:38.740Z |
5404784 | 5404784 | 20241026235232_SMQBs | UK0087 | 2024-10-29T12:11:57.674Z | 2024-11-04T14:28:51.938Z |
5404447 | 5404447 | 20241026232650_31hau | UK0087 | 2024-10-29T12:11:27.911Z | 2024-11-04T14:28:51.056Z |
5404266 | 5404266 | 20241026231306_OAwVo | UK0087 | 2024-10-29T12:11:03.760Z | 2024-11-04T14:28:50.560Z |
5404171 | 5404171 | 20241026230351_UeIko | UK0087 | 2024-10-29T12:10:57.482Z | 2024-11-04T14:28:50.393Z |
5403750 | 5403750 | 20241026222751_Myfx3 | UK0087 | 2024-10-29T12:10:11.428Z | 2024-11-04T14:28:49.541Z |
5403735 | 5403735 | 20241026222636_tlNb2 | UK0087 | 2024-10-29T12:10:10.593Z | 2024-11-04T14:28:49.527Z |
5403721 | 5403721 | 20241026222438_cNPbV | UK0087 | 2024-10-29T12:10:09.578Z | 2024-11-04T14:28:49.519Z |
5403239 | 5403239 | 20241026213115_8ypVe | UK0087 | 2024-10-29T12:09:14.918Z | 2024-11-04T14:28:47.992Z |
5403175 | 5403175 | 20241026212537_u5XAq | UK0087 | 2024-10-29T12:09:10.195Z | 2024-11-04T14:28:47.923Z |
5403045 | 5403045 | 20241026210855_8qLR2 | UK0087 | 2024-10-29T12:08:48.384Z | 2024-11-04T14:28:47.607Z |
5402732 | 5402732 | 20241026201716_i6UHU | UK0087 | 2024-10-29T12:08:01.483Z | 2024-11-04T14:28:46.384Z |
5402379 | 5402379 | 20241026192444_MS5ox | UK0087 | 2024-10-29T12:07:07.030Z | 2024-11-04T14:28:44.163Z |
5399568 | 5399568 | 20241026043500_C44VJ | UK0087 | 2024-10-28T12:20:02.615Z | 2024-11-03T14:27:39.991Z |
5399528 | 5399528 | 20241026043202_7qIIt | UK0087 | 2024-10-28T12:20:01.577Z | 2024-11-03T14:27:39.932Z |
5399511 | 5399511 | 20241026043005_k27FB | UK0087 | 2024-10-28T12:20:01.340Z | 2024-11-03T14:27:39.889Z |
5399481 | 5399481 | 20241026042639_GP8u8 | UK0087 | 2024-10-28T12:20:00.499Z | 2024-11-03T14:27:39.842Z |
5399449 | 5399449 | 20241026041841_xDpik | UK0087 | 2024-10-28T12:19:59.745Z | 2024-11-03T14:27:39.733Z |
5399061 | 5399061 | 20241026034810_WHJrz | UK0087 | 2024-10-28T12:19:46.857Z | 2024-11-03T14:27:38.956Z |
5398953 | 5398953 | 20241026034045_2nBij | UK0087 | 2024-10-28T12:19:41.165Z | 2024-11-03T14:27:38.700Z |
5398914 | 5398914 | 20241026033718_i44QH | UK0087 | 2024-10-28T12:19:40.094Z | 2024-11-03T14:27:38.598Z |
5398872 | 5398872 | 20241026033425_gjJXo | UK0087 | 2024-10-28T12:19:38.159Z | 2024-11-03T14:27:38.313Z |
5398846 | 5398846 | 20241026033324_gEwM0 | UK0087 | 2024-10-28T12:19:37.132Z | 2024-11-03T14:27:38.295Z |
5398692 | 5398692 | 20241026031904_5Td7f | UK0087 | 2024-10-28T12:19:28.594Z | 2024-11-03T14:27:37.735Z |
5398552 | 5398552 | 20241026030738_DeqGI | UK0087 | 2024-10-28T12:19:21.433Z | 2024-11-03T14:27:36.778Z |
5398387 | 5398387 | 20241026025206_x3Gy2 | UK0087 | 2024-10-28T12:19:13.637Z | 2024-11-03T14:27:36.226Z |
5397080 | 5397080 | 20241026010055_K6C2S | UK0087 | 2024-10-28T12:18:06.938Z | 2024-11-03T14:27:32.002Z |
5397060 | 5397060 | 20241026005940_zCzpA | UK0087 | 2024-10-28T12:18:05.331Z | 2024-11-03T14:27:31.979Z |
5396758 | 5396758 | 20241026003053_MeuLc | UK0087 | 2024-10-28T12:17:55.143Z | 2024-11-03T14:27:30.859Z |
5387375 | 5387375 | 20241025022722_WDcWu | UK0087 | 2024-10-27T12:21:17.309Z | 2024-11-02T12:28:32.424Z |
5376105 | 5376105 | 20241024034157_QAFA5 | UK0087 | 2024-10-26T12:21:50.525Z | 2024-11-01T12:27:01.390Z |
5375844 | 5375844 | 20241024033229_nKCCg | UK0087 | 2024-10-26T12:21:41.625Z | 2024-11-01T12:27:01.219Z |
5375825 | 5375825 | 20241024033205_Du9An | UK0087 | 2024-10-26T12:21:41.193Z | 2024-11-01T12:27:01.213Z |
5372000 | 5372000 | 20241024002638_wd0xj | UK0087 | 2024-10-26T12:19:02.984Z | 2024-11-01T12:26:57.058Z |
5371927 | 5371927 | 20241024002326_Oi3y0 | UK0087 | 2024-10-26T12:18:58.629Z | 2024-11-01T12:26:57.002Z |
5365539 | 5365539 | 20241023233627_jGoDH | UK0087 | 2024-10-25T12:18:00.090Z | 2024-11-01T12:26:56.189Z |
5364834 | 5364834 | 20241023225538_oJ2XX | UK0087 | 2024-10-25T12:17:36.648Z | 2024-11-01T12:26:55.669Z |
5364775 | 5364775 | 20241023225211_o2Fbj | UK0087 | 2024-10-25T12:17:33.874Z | 2024-11-01T12:26:55.624Z |
5364766 | 5364766 | 20241023225155_QrlvZ | UK0087 | 2024-10-25T12:17:33.291Z | 2024-11-01T12:26:55.612Z |
5361486 | 5361486 | 20241023182105_06emf | UK0087 | 2024-10-25T12:12:45.906Z | 2024-11-01T12:26:50.271Z |
5354693 | 5354693 | 20241023024034_wQM7l | UK0087 | 2024-10-24T12:20:46.954Z | 2024-10-31T12:30:06.250Z |
5354482 | 5354482 | 20241023022801_rMsLw | UK0087 | 2024-10-24T12:20:35.782Z | 2024-10-31T12:30:05.874Z |
5354371 | 5354371 | 20241023022300_79yd7 | UK0087 | 2024-10-24T12:20:30.419Z | 2024-10-31T12:30:05.687Z |
5354349 | 5354349 | 20241023022210_yr3gu | UK0087 | 2024-10-24T12:20:29.466Z | 2024-10-31T12:30:05.678Z |
5354336 | 5354336 | 20241023022049_K9TNm | UK0087 | 2024-10-24T12:20:28.358Z | 2024-10-31T12:30:05.651Z |
5354328 | 5354328 | 20241023022012_SadTm | UK0087 | 2024-10-24T12:20:28.273Z | 2024-10-31T12:30:05.644Z |
5353865 | 5353865 | 20241023015208_aGubm | UK0087 | 2024-10-24T12:19:59.193Z | 2024-10-31T12:30:04.931Z |
5353615 | 5353615 | 20241023013518_YiEj3 | UK0087 | 2024-10-24T12:19:48.567Z | 2024-10-31T12:30:04.421Z |
5353464 | 5353464 | 20241023012649_HXuWG | UK0087 | 2024-10-24T12:19:43.495Z | 2024-10-31T12:30:04.270Z |
5353338 | 5353338 | 20241023012038_XGB2c | UK0087 | 2024-10-24T12:19:39.511Z | 2024-10-31T12:30:04.153Z |
5353219 | 5353219 | 20241023011540_hnKwi | UK0087 | 2024-10-24T12:19:35.978Z | 2024-10-31T12:30:04.019Z |
5352392 | 5352392 | 20241023003100_1HEda | UK0087 | 2024-10-24T12:18:44.071Z | 2024-10-31T12:30:02.588Z |
5352256 | 5352256 | 20241023002227_PfYT6 | UK0087 | 2024-10-24T12:18:34.178Z | 2024-10-31T12:30:02.363Z |
5351742 | 5351742 | 20241022235028_GXpqd | UK0087 | 2024-10-24T12:17:55.712Z | 2024-10-31T12:30:00.857Z |
5351273 | 5351273 | 20241022231251_zOAfy | UK0087 | 2024-10-24T12:17:23.510Z | 2024-10-31T12:29:59.722Z |
5351032 | 5351032 | 20241022224936_Jo6Sy | UK0087 | 2024-10-24T12:17:04.636Z | 2024-10-31T12:29:59.286Z |
5350123 | 5350123 | 20241022211517_a6QHa | UK0087 | 2024-10-24T12:15:23.492Z | 2024-10-31T12:29:57.341Z |
5349840 | 5349840 | 20241022204000_nqPMA | UK0087 | 2024-10-24T12:14:42.556Z | 2024-10-31T12:29:56.763Z |
5349124 | 5349124 | 20241022192710_PksZt | UK0087 | 2024-10-24T12:13:11.545Z | 2024-10-31T12:29:54.607Z |
5348952 | 5348952 | 20241022191151_McGs9 | UK0087 | 2024-10-24T12:12:38.375Z | 2024-10-31T12:29:54.233Z |
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);