participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,554 rows where station_code = "UK007M" 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 |
---|---|---|---|---|---|
5191645 | 5191645 | 20240928202906_Jh2hh | UK007M | 2024-09-30T12:17:57.451Z | 2024-10-06T12:28:23.276Z |
5191422 | 5191422 | 20240928200116_jId4G | UK007M | 2024-09-30T12:17:45.368Z | 2024-10-06T12:28:22.618Z |
5186249 | 5186249 | 20240929034128_AtbTo | UK007M | 2024-09-30T12:06:29.521Z | 2024-10-07T12:21:20.071Z |
5185896 | 5185896 | 20240929030718_BEWOk | UK007M | 2024-09-30T12:05:27.198Z | 2024-10-07T12:21:19.260Z |
5185641 | 5185641 | 20240929024046_PtLLx | UK007M | 2024-09-30T12:04:48.691Z | 2024-10-07T12:21:18.536Z |
5185608 | 5185608 | 20240929023803_C3BR2 | UK007M | 2024-09-30T12:04:42.595Z | 2024-10-07T12:21:18.518Z |
5185402 | 5185402 | 20240929022129_WNPty | UK007M | 2024-09-30T12:04:11.336Z | 2024-10-07T12:21:17.658Z |
5182532 | 5182532 | 20240927225622_QP0w9 | UK007M | 2024-09-29T12:16:03.248Z | 2024-10-05T12:29:08.796Z |
5182467 | 5182467 | 20240927224714_lLCY6 | UK007M | 2024-09-29T12:16:00.645Z | 2024-10-05T12:29:08.678Z |
5182332 | 5182332 | 20240927223356_Igd4X | UK007M | 2024-09-29T12:15:55.359Z | 2024-10-05T12:29:08.521Z |
5181572 | 5181572 | 20240927210548_Z1IVb | UK007M | 2024-09-29T12:15:14.614Z | 2024-10-05T12:29:05.998Z |
5181480 | 5181480 | 20240927205713_Gz60k | UK007M | 2024-09-29T12:15:07.702Z | 2024-10-05T12:29:05.914Z |
5181307 | 5181307 | 20240927203511_ANOsH | UK007M | 2024-09-29T12:14:55.211Z | 2024-10-05T12:29:05.571Z |
5180991 | 5180991 | 20240927195524_J2Fh6 | UK007M | 2024-09-29T12:14:30.704Z | 2024-10-05T12:29:04.022Z |
5180879 | 5180879 | 20240927194011_hgi69 | UK007M | 2024-09-29T12:14:22.722Z | 2024-10-05T12:29:02.658Z |
5178928 | 5178928 | 20240928033018_2nx5e | UK007M | 2024-09-29T12:07:14.664Z | 2024-10-06T12:28:01.425Z |
5178875 | 5178875 | 20240928032624_knMNk | UK007M | 2024-09-29T12:07:11.560Z | 2024-10-06T12:28:01.047Z |
5178470 | 5178470 | 20240928025834_46F7f | UK007M | 2024-09-29T12:06:23.854Z | 2024-10-06T12:27:59.902Z |
5178462 | 5178462 | 20240928025833_mitb1 | UK007M | 2024-09-29T12:06:23.653Z | 2024-10-06T12:27:59.896Z |
5178347 | 5178347 | 20240928024758_Xr2fk | UK007M | 2024-09-29T12:06:10.493Z | 2024-10-06T12:27:59.252Z |
5178228 | 5178228 | 20240928024022_FviZl | UK007M | 2024-09-29T12:05:53.565Z | 2024-10-06T12:27:58.536Z |
5178207 | 5178207 | 20240928023936_0PNjm | UK007M | 2024-09-29T12:05:51.494Z | 2024-10-06T12:27:58.419Z |
5178137 | 5178137 | 20240928023504_4i3wP | UK007M | 2024-09-29T12:05:45.186Z | 2024-10-06T12:27:58.165Z |
5178006 | 5178006 | 20240928022618_CLK5d | UK007M | 2024-09-29T12:05:35.216Z | 2024-10-06T12:27:57.829Z |
5177643 | 5177643 | 20240928015741_iyE25 | UK007M | 2024-09-29T12:04:47.773Z | 2024-10-06T12:27:55.721Z |
5177189 | 5177189 | 20240928012333_PHEEh | UK007M | 2024-09-29T12:03:57.894Z | 2024-10-06T12:27:54.427Z |
5177100 | 5177100 | 20240928011813_jRBt3 | UK007M | 2024-09-29T12:03:41.097Z | 2024-10-06T12:27:54.187Z |
5177090 | 5177090 | 20240928011812_B19tV | UK007M | 2024-09-29T12:03:40.679Z | 2024-10-06T12:27:54.178Z |
5176942 | 5176942 | 20240928010936_K2rMD | UK007M | 2024-09-29T12:03:27.143Z | 2024-10-06T12:27:53.521Z |
5176674 | 5176674 | 20240928005149_BiWxE | UK007M | 2024-09-29T12:02:46.603Z | 2024-10-06T12:27:52.099Z |
5176026 | 5176026 | 20240928000601_JdPOp | UK007M | 2024-09-29T12:01:21.355Z | 2024-10-06T12:27:49.531Z |
5175897 | 5175897 | 20240927235957_50j2Q | UK007M | 2024-09-29T12:01:07.309Z | 2024-10-06T12:27:49.215Z |
5175686 | 5175686 | 20240927234158_YKr73 | UK007M | 2024-09-29T12:00:36.608Z | 2024-10-06T12:27:48.320Z |
5165507 | 5165507 | 20240924220205_qqMDy | UK007M | 2024-09-26T12:13:53.068Z | 2024-10-02T12:19:04.976Z |
5165427 | 5165427 | 20240924210520_rI4P7 | UK007M | 2024-09-26T12:13:41.029Z | 2024-10-02T12:19:04.626Z |
5165366 | 5165366 | 20240924205545_2Wpy4 | UK007M | 2024-09-26T12:13:34.693Z | 2024-10-02T12:19:04.396Z |
5165177 | 5165177 | 20240924201457_HEvor | UK007M | 2024-09-26T12:13:23.461Z | 2024-10-02T12:19:03.776Z |
5165107 | 5165107 | 20240924195509_1NFE2 | UK007M | 2024-09-26T12:13:19.654Z | 2024-10-02T12:19:03.540Z |
5157718 | 5157718 | 20240924230626_fZBpb | UK007M | 2024-09-26T12:00:27.007Z | 2024-10-03T12:25:07.295Z |
5133752 | 5133752 | 20240916040217_ygZwe | UK007M | 2024-09-19T12:17:07.115Z | 2024-09-24T12:15:51.231Z |
5133568 | 5133568 | 20240916034141_sVk8p | UK007M | 2024-09-19T12:17:02.131Z | 2024-09-24T12:15:50.319Z |
5133468 | 5133468 | 20240916033130_5v03X | UK007M | 2024-09-19T12:16:57.404Z | 2024-09-24T12:15:49.598Z |
5133368 | 5133368 | 20240916032738_ALLtX | UK007M | 2024-09-19T12:16:55.567Z | 2024-09-24T12:15:49.212Z |
5133212 | 5133212 | 20240916030716_vNXeH | UK007M | 2024-09-19T12:16:49.220Z | 2024-09-24T12:15:48.200Z |
5133076 | 5133076 | 20240916025037_AK9tO | UK007M | 2024-09-19T12:16:43.532Z | 2024-09-24T12:15:46.973Z |
5133017 | 5133017 | 20240916024227_DaFIN | UK007M | 2024-09-19T12:16:40.984Z | 2024-09-24T12:15:46.662Z |
5132810 | 5132810 | 20240916021515_8gZYt | UK007M | 2024-09-19T12:16:33.366Z | 2024-09-24T12:15:45.463Z |
5132750 | 5132750 | 20240916020446_ly8Q6 | UK007M | 2024-09-19T12:16:30.753Z | 2024-09-24T12:15:45.143Z |
5132633 | 5132633 | 20240916014845_I49PP | UK007M | 2024-09-19T12:16:23.745Z | 2024-09-24T12:15:43.809Z |
5132513 | 5132513 | 20240916012313_h5psZ | UK007M | 2024-09-19T12:16:16.337Z | 2024-09-24T12:15:43.243Z |
5132435 | 5132435 | 20240916010730_AJ0qS | UK007M | 2024-09-19T12:16:12.541Z | 2024-09-24T12:15:42.761Z |
5132374 | 5132374 | 20240916005348_GnncH | UK007M | 2024-09-19T12:16:09.802Z | 2024-09-24T12:15:42.495Z |
5132310 | 5132310 | 20240916003156_lj24Q | UK007M | 2024-09-19T12:16:05.110Z | 2024-09-24T12:15:42.108Z |
5132282 | 5132282 | 20240916002247_DHiwZ | UK007M | 2024-09-19T12:16:03.153Z | 2024-09-24T12:15:41.849Z |
5132235 | 5132235 | 20240916000934_ad0L4 | UK007M | 2024-09-19T12:16:00.008Z | 2024-09-24T12:15:41.219Z |
5132040 | 5132040 | 20240915225218_b8X6y | UK007M | 2024-09-19T12:15:44.768Z | 2024-09-24T12:15:39.630Z |
5131991 | 5131991 | 20240915223252_KQ8m6 | UK007M | 2024-09-19T12:15:41.142Z | 2024-09-24T12:15:39.379Z |
5131956 | 5131956 | 20240915222340_a3ikz | UK007M | 2024-09-19T12:15:37.375Z | 2024-09-24T12:15:39.119Z |
5131905 | 5131905 | 20240915220930_wJH4r | UK007M | 2024-09-19T12:15:33.627Z | 2024-09-24T12:15:38.627Z |
5129603 | 5129603 | 20240917041305_jXRwF | UK007M | 2024-09-19T12:11:52.792Z | 2024-09-25T12:22:31.831Z |
5128913 | 5128913 | 20240917025359_DjNKd | UK007M | 2024-09-19T12:11:06.586Z | 2024-09-25T12:22:27.596Z |
5128903 | 5128903 | 20240917025239_9XJjF | UK007M | 2024-09-19T12:11:05.973Z | 2024-09-25T12:22:27.523Z |
5128589 | 5128589 | 20240917020759_7vm3g | UK007M | 2024-09-19T12:10:46.472Z | 2024-09-25T12:22:25.904Z |
5128461 | 5128461 | 20240917014556_EpX3t | UK007M | 2024-09-19T12:10:36.539Z | 2024-09-25T12:22:25.221Z |
5128362 | 5128362 | 20240917013113_7lp2l | UK007M | 2024-09-19T12:10:29.052Z | 2024-09-25T12:22:24.601Z |
5128189 | 5128189 | 20240917010457_029vC | UK007M | 2024-09-19T12:10:19.785Z | 2024-09-25T12:22:23.864Z |
5127910 | 5127910 | 20240917000505_sC3Ql | UK007M | 2024-09-19T12:09:46.714Z | 2024-09-25T12:22:20.951Z |
5127492 | 5127492 | 20240916221156_Vi4D9 | UK007M | 2024-09-19T12:09:15.436Z | 2024-09-25T12:22:15.291Z |
5127061 | 5127061 | 20240916201912_XNx2r | UK007M | 2024-09-19T12:07:59.966Z | 2024-09-25T12:22:05.831Z |
5126965 | 5126965 | 20240916200134_DfSMC | UK007M | 2024-09-19T12:07:48.716Z | 2024-09-25T12:22:05.086Z |
5124784 | 5124784 | 20240917220112_DZ7h4 | UK007M | 2024-09-19T12:01:35.012Z | 2024-09-26T12:18:35.226Z |
5124776 | 5124776 | 20240917220037_lPKzx | UK007M | 2024-09-19T12:01:34.019Z | 2024-09-26T12:18:35.199Z |
5124771 | 5124771 | 20240917215915_6tDWw | UK007M | 2024-09-19T12:01:33.558Z | 2024-09-26T12:18:35.198Z |
5124732 | 5124732 | 20240917215625_mMP25 | UK007M | 2024-09-19T12:01:27.849Z | 2024-09-26T12:18:34.914Z |
5124627 | 5124627 | 20240917213921_D2aqM | UK007M | 2024-09-19T12:01:14.480Z | 2024-09-26T12:18:34.215Z |
5124524 | 5124524 | 20240917205551_GBozT | UK007M | 2024-09-19T12:01:05.529Z | 2024-09-26T12:18:33.196Z |
5120891 | 5120891 | 20240914034036_Sks8h | UK007M | 2024-09-18T12:10:48.453Z | 2024-09-22T12:17:58.432Z |
5120526 | 5120526 | 20240914032631_UikgF | UK007M | 2024-09-18T12:10:42.874Z | 2024-09-22T12:17:57.360Z |
5116622 | 5116622 | 20240915033346_gv04B | UK007M | 2024-09-18T12:07:12.506Z | 2024-09-23T12:16:22.110Z |
5116533 | 5116533 | 20240915033116_Lx8aQ | UK007M | 2024-09-18T12:07:09.025Z | 2024-09-23T12:16:21.622Z |
5116323 | 5116323 | 20240915032139_auUX1 | UK007M | 2024-09-18T12:06:57.244Z | 2024-09-23T12:16:20.945Z |
5116275 | 5116275 | 20240915031959_WrKJe | UK007M | 2024-09-18T12:06:54.173Z | 2024-09-23T12:16:20.863Z |
5116103 | 5116103 | 20240915030837_gGs9x | UK007M | 2024-09-18T12:06:40.024Z | 2024-09-23T12:16:20.450Z |
5115989 | 5115989 | 20240915030242_kxnSo | UK007M | 2024-09-18T12:06:33.544Z | 2024-09-23T12:16:20.183Z |
5114658 | 5114658 | 20240915015312_gJZU1 | UK007M | 2024-09-18T12:05:27.636Z | 2024-09-23T12:16:13.896Z |
5114421 | 5114421 | 20240915014110_JrNif | UK007M | 2024-09-18T12:05:14.433Z | 2024-09-23T12:16:13.218Z |
5113668 | 5113668 | 20240915010442_3DRek | UK007M | 2024-09-18T12:04:38.224Z | 2024-09-23T12:16:10.921Z |
5112609 | 5112609 | 20240914233444_D7QiL | UK007M | 2024-09-18T12:03:16.629Z | 2024-09-23T12:16:04.448Z |
5112541 | 5112541 | 20240914232830_Ay5Rv | UK007M | 2024-09-18T12:03:12.858Z | 2024-09-23T12:16:04.368Z |
5112374 | 5112374 | 20240914230622_sluI3 | UK007M | 2024-09-18T12:03:01.687Z | 2024-09-23T12:16:03.574Z |
5112302 | 5112302 | 20240914225223_Pdi0R | UK007M | 2024-09-18T12:02:58.951Z | 2024-09-23T12:16:03.323Z |
5112129 | 5112129 | 20240914222359_hUNnZ | UK007M | 2024-09-18T12:02:49.161Z | 2024-09-23T12:16:02.445Z |
5111368 | 5111368 | 20240914202837_OlHm7 | UK007M | 2024-09-18T12:01:52.739Z | 2024-09-23T12:15:56.592Z |
5111235 | 5111235 | 20240914201314_Fgem2 | UK007M | 2024-09-18T12:01:44.635Z | 2024-09-23T12:15:54.957Z |
5111190 | 5111190 | 20240914201007_8Xvja | UK007M | 2024-09-18T12:01:42.469Z | 2024-09-23T12:15:54.894Z |
5099805 | 5099805 | 20240913220625_lZj2O | UK007M | 2024-09-17T12:03:35.758Z | 2024-09-22T12:17:48.324Z |
5099623 | 5099623 | 20240913214047_6Jcmp | UK007M | 2024-09-17T12:03:15.038Z | 2024-09-22T12:17:48.023Z |
5099314 | 5099314 | 20240913205849_FR81V | UK007M | 2024-09-17T12:02:44.813Z | 2024-09-22T12:17:47.125Z |
5099033 | 5099033 | 20240913200907_iURxc | UK007M | 2024-09-17T12:02:11.865Z | 2024-09-22T12:17:45.691Z |
5094426 | 5094426 | 20240912040127_C6zQ8 | UK007M | 2024-09-16T12:14:44.641Z | 2024-09-20T12:21:55.278Z |
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);