participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,280 rows where station_code = "UK00AQ" 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 |
---|---|---|---|---|---|
5133794 | 5133794 | 20240916040537_hv4M6 | UK00AQ | 2024-09-19T12:17:08.083Z | 2024-09-19T12:17:08.083Z |
5133473 | 5133473 | 20240916033130_5v03X | UK00AQ | 2024-09-19T12:16:57.404Z | 2024-09-19T12:16:57.404Z |
5133250 | 5133250 | 20240916031230_utz8P | UK00AQ | 2024-09-19T12:16:51.182Z | 2024-09-19T12:16:51.182Z |
5133172 | 5133172 | 20240916030336_0Hf2T | UK00AQ | 2024-09-19T12:16:46.092Z | 2024-09-19T12:16:46.092Z |
5133040 | 5133040 | 20240916024633_VwMNG | UK00AQ | 2024-09-19T12:16:42.146Z | 2024-09-19T12:16:42.146Z |
5133020 | 5133020 | 20240916024227_DaFIN | UK00AQ | 2024-09-19T12:16:40.984Z | 2024-09-19T12:16:40.984Z |
5132866 | 5132866 | 20240916022338_51p7l | UK00AQ | 2024-09-19T12:16:34.830Z | 2024-09-19T12:16:34.830Z |
5132594 | 5132594 | 20240916013741_8JOXx | UK00AQ | 2024-09-19T12:16:20.758Z | 2024-09-19T12:16:20.758Z |
5132477 | 5132477 | 20240916011528_gDqpw | UK00AQ | 2024-09-19T12:16:14.092Z | 2024-09-19T12:16:14.092Z |
5132301 | 5132301 | 20240916002635_B19qt | UK00AQ | 2024-09-19T12:16:04.366Z | 2024-09-19T12:16:04.366Z |
5132289 | 5132289 | 20240916002341_iCLyr | UK00AQ | 2024-09-19T12:16:03.393Z | 2024-09-19T12:16:03.393Z |
5132210 | 5132210 | 20240916000031_wthcY | UK00AQ | 2024-09-19T12:15:58.461Z | 2024-09-19T12:15:58.461Z |
5132133 | 5132133 | 20240915232953_du1W3 | UK00AQ | 2024-09-19T12:15:52.168Z | 2024-09-19T12:15:52.168Z |
5132124 | 5132124 | 20240915232703_278XQ | UK00AQ | 2024-09-19T12:15:51.368Z | 2024-09-19T12:15:51.368Z |
5132031 | 5132031 | 20240915225102_N5m55 | UK00AQ | 2024-09-19T12:15:44.359Z | 2024-09-19T12:15:44.359Z |
5131989 | 5131989 | 20240915223215_yJxTi | UK00AQ | 2024-09-19T12:15:40.760Z | 2024-09-19T12:15:40.760Z |
5131890 | 5131890 | 20240915220051_Y5pgj | UK00AQ | 2024-09-19T12:15:32.481Z | 2024-09-19T12:15:32.481Z |
5129837 | 5129837 | 20240917043812_1G37g | UK00AQ | 2024-09-19T12:12:08.082Z | 2024-09-19T12:12:08.082Z |
5129606 | 5129606 | 20240917041305_jXRwF | UK00AQ | 2024-09-19T12:11:52.792Z | 2024-09-19T12:11:52.792Z |
5129265 | 5129265 | 20240917034125_OsjUI | UK00AQ | 2024-09-19T12:11:24.486Z | 2024-09-19T12:11:24.486Z |
5128915 | 5128915 | 20240917025359_DjNKd | UK00AQ | 2024-09-19T12:11:06.586Z | 2024-09-19T12:11:06.586Z |
5128640 | 5128640 | 20240917021711_NNGdu | UK00AQ | 2024-09-19T12:10:50.259Z | 2024-09-19T12:10:50.259Z |
5128350 | 5128350 | 20240917012818_bZAwq | UK00AQ | 2024-09-19T12:10:28.781Z | 2024-09-19T12:10:28.781Z |
5128032 | 5128032 | 20240917002342_wo6mW | UK00AQ | 2024-09-19T12:09:55.265Z | 2024-09-19T12:09:55.265Z |
5127835 | 5127835 | 20240916234500_eS9UR | UK00AQ | 2024-09-19T12:09:42.056Z | 2024-09-19T12:09:42.056Z |
5127797 | 5127797 | 20240916233505_c3G27 | UK00AQ | 2024-09-19T12:09:39.350Z | 2024-09-19T12:09:39.350Z |
5127752 | 5127752 | 20240916232251_Caf3r | UK00AQ | 2024-09-19T12:09:36.129Z | 2024-09-19T12:09:36.129Z |
5127741 | 5127741 | 20240916231637_AP40D | UK00AQ | 2024-09-19T12:09:35.237Z | 2024-09-19T12:09:35.237Z |
5127649 | 5127649 | 20240916224425_2iyUT | UK00AQ | 2024-09-19T12:09:28.895Z | 2024-09-19T12:09:28.895Z |
5127576 | 5127576 | 20240916223009_dCnVN | UK00AQ | 2024-09-19T12:09:24.257Z | 2024-09-19T12:09:24.257Z |
5127384 | 5127384 | 20240916214237_wssGw | UK00AQ | 2024-09-19T12:09:01.131Z | 2024-09-19T12:09:01.131Z |
5127368 | 5127368 | 20240916213651_39dUt | UK00AQ | 2024-09-19T12:08:59.958Z | 2024-09-19T12:08:59.958Z |
5127364 | 5127364 | 20240916213542_zTeB5 | UK00AQ | 2024-09-19T12:08:59.396Z | 2024-09-19T12:08:59.396Z |
5127308 | 5127308 | 20240916212130_LoVlA | UK00AQ | 2024-09-19T12:08:49.488Z | 2024-09-19T12:08:49.488Z |
5125812 | 5125812 | 20240918040043_GsvGV | UK00AQ | 2024-09-19T12:04:09.394Z | 2024-09-19T12:06:42.089Z |
5125642 | 5125642 | 20240918031259_AwcpL | UK00AQ | 2024-09-19T12:03:46.861Z | 2024-09-19T12:06:42.061Z |
5125456 | 5125456 | 20240918023953_xUbF1 | UK00AQ | 2024-09-19T12:03:17.645Z | 2024-09-19T12:06:42.036Z |
5125400 | 5125400 | 20240918022835_IQf3K | UK00AQ | 2024-09-19T12:03:09.420Z | 2024-09-19T12:06:42.026Z |
5125317 | 5125317 | 20240918020410_iGpxh | UK00AQ | 2024-09-19T12:02:47.148Z | 2024-09-19T12:06:42.011Z |
5125301 | 5125301 | 20240918015709_uNuTF | UK00AQ | 2024-09-19T12:02:42.306Z | 2024-09-19T12:06:42.007Z |
5125296 | 5125296 | 20240918015629_z4VPX | UK00AQ | 2024-09-19T12:02:42.017Z | 2024-09-19T12:06:42.006Z |
5125274 | 5125274 | 20240918015209_6eqf2 | UK00AQ | 2024-09-19T12:02:39.093Z | 2024-09-19T12:06:42.003Z |
5125260 | 5125260 | 20240918014429_xaeHW | UK00AQ | 2024-09-19T12:02:37.491Z | 2024-09-19T12:06:42.001Z |
5125253 | 5125253 | 20240918013655_YGTDV | UK00AQ | 2024-09-19T12:02:36.225Z | 2024-09-19T12:06:41.999Z |
5125140 | 5125140 | 20240918002709_LJepw | UK00AQ | 2024-09-19T12:02:23.341Z | 2024-09-19T12:06:41.981Z |
5125104 | 5125104 | 20240918001643_k7FaD | UK00AQ | 2024-09-19T12:02:20.126Z | 2024-09-19T12:06:41.977Z |
5125029 | 5125029 | 20240917233324_zj5tc | UK00AQ | 2024-09-19T12:01:57.514Z | 2024-09-19T12:06:41.963Z |
5124953 | 5124953 | 20240917230127_mRKp2 | UK00AQ | 2024-09-19T12:01:50.890Z | 2024-09-19T12:06:41.956Z |
5124841 | 5124841 | 20240917221615_MiuQ5 | UK00AQ | 2024-09-19T12:01:39.831Z | 2024-09-19T12:06:41.941Z |
5124679 | 5124679 | 20240917214708_Rol3g | UK00AQ | 2024-09-19T12:01:18.813Z | 2024-09-19T12:06:41.923Z |
5124572 | 5124572 | 20240917211327_fRJG0 | UK00AQ | 2024-09-19T12:01:09.248Z | 2024-09-19T12:06:41.912Z |
5124540 | 5124540 | 20240917210104_BN7FQ | UK00AQ | 2024-09-19T12:01:05.905Z | 2024-09-19T12:06:41.908Z |
5124444 | 5124444 | 20240917202117_SRq2Q | UK00AQ | 2024-09-19T12:00:56.024Z | 2024-09-19T12:06:41.895Z |
5124349 | 5124349 | 20240917193845_X8mlh | UK00AQ | 2024-09-19T12:00:37.424Z | 2024-09-19T12:06:41.881Z |
5114925 | 5114925 | 20240915020738_X45uT | UK00AQ | 2024-09-18T12:05:42.432Z | 2024-09-19T12:19:00.562Z |
5112305 | 5112305 | 20240914225223_Pdi0R | UK00AQ | 2024-09-18T12:02:58.951Z | 2024-09-19T12:18:40.427Z |
5094527 | 5094527 | 20240912040710_6hIRH | UK00AQ | 2024-09-16T12:14:50.242Z | 2024-09-19T12:21:16.224Z |
5077448 | 5077448 | 20240911005326_jfFqt | UK00AQ | 2024-09-15T12:14:45.437Z | 2024-09-19T12:21:38.999Z |
5075155 | 5075155 | 20240911233246_kamDJ | UK00AQ | 2024-09-15T12:09:27.904Z | 2024-09-19T12:21:08.643Z |
5075006 | 5075006 | 20240911232156_oSVhL | UK00AQ | 2024-09-15T12:09:18.044Z | 2024-09-19T12:21:07.992Z |
5074623 | 5074623 | 20240911224950_yx58x | UK00AQ | 2024-09-15T12:08:40.300Z | 2024-09-19T12:21:07.540Z |
5073381 | 5073381 | 20240911211824_ODzYX | UK00AQ | 2024-09-15T12:07:07.068Z | 2024-09-19T12:21:05.707Z |
5039948 | 5039948 | 20240906023339_jW9U3 | UK00AQ | 2024-09-12T12:15:52.572Z | 2024-09-14T12:23:06.237Z |
5039687 | 5039687 | 20240906015147_yMTNy | UK00AQ | 2024-09-12T12:15:41.923Z | 2024-09-14T12:23:04.024Z |
5039138 | 5039138 | 20240905232815_DmFHu | UK00AQ | 2024-09-12T12:15:16.859Z | 2024-09-14T12:23:00.382Z |
5039130 | 5039130 | 20240905232649_pGAnw | UK00AQ | 2024-09-12T12:15:16.683Z | 2024-09-14T12:23:00.339Z |
5039083 | 5039083 | 20240905231738_WGYDH | UK00AQ | 2024-09-12T12:15:15.014Z | 2024-09-14T12:23:00.056Z |
5039041 | 5039041 | 20240905231038_eIjst | UK00AQ | 2024-09-12T12:15:13.619Z | 2024-09-14T12:22:59.908Z |
5038995 | 5038995 | 20240905225714_RZ2yn | UK00AQ | 2024-09-12T12:15:11.734Z | 2024-09-14T12:22:59.699Z |
5038938 | 5038938 | 20240905224306_NzscH | UK00AQ | 2024-09-12T12:15:08.389Z | 2024-09-14T12:22:59.505Z |
5038914 | 5038914 | 20240905223754_rvAxi | UK00AQ | 2024-09-12T12:15:07.040Z | 2024-09-14T12:22:59.205Z |
5038702 | 5038702 | 20240905212638_VI2vH | UK00AQ | 2024-09-12T12:14:55.291Z | 2024-09-14T12:22:57.280Z |
5031896 | 5031896 | 20240906233826_7hiYm | UK00AQ | 2024-09-12T12:06:01.321Z | 2024-09-15T12:21:24.634Z |
5025635 | 5025635 | 20240906023339_6WxUH | UK00AQ | 2024-09-11T12:07:01.518Z | 2024-09-11T12:16:32.732Z |
5025350 | 5025350 | 20240906015147_q2ORo | UK00AQ | 2024-09-11T12:06:18.010Z | 2024-09-11T12:16:32.590Z |
5024735 | 5024735 | 20240905232815_X4wRu | UK00AQ | 2024-09-11T12:04:38.340Z | 2024-09-11T12:16:32.286Z |
5024727 | 5024727 | 20240905232649_5JE20 | UK00AQ | 2024-09-11T12:04:37.757Z | 2024-09-11T12:16:32.283Z |
5024673 | 5024673 | 20240905231738_EbmYu | UK00AQ | 2024-09-11T12:04:24.519Z | 2024-09-11T12:16:32.255Z |
5024626 | 5024626 | 20240905231038_gqxVG | UK00AQ | 2024-09-11T12:04:16.744Z | 2024-09-11T12:16:32.234Z |
5024578 | 5024578 | 20240905225714_RCBtL | UK00AQ | 2024-09-11T12:04:07.453Z | 2024-09-14T12:22:59.704Z |
5024519 | 5024519 | 20240905224306_gz1oz | UK00AQ | 2024-09-11T12:04:00.010Z | 2024-09-11T12:16:32.177Z |
5024495 | 5024495 | 20240905223754_JvVnn | UK00AQ | 2024-09-11T12:03:56.568Z | 2024-09-14T12:22:59.206Z |
5024272 | 5024272 | 20240905212638_DAMua | UK00AQ | 2024-09-11T12:03:11.584Z | 2024-09-11T12:16:32.042Z |
5009628 | 5009628 | 20240904014158_8zjp6 | UK00AQ | 2024-09-09T12:07:52.573Z | 2024-09-12T12:19:23.716Z |
4966691 | 4966691 | 20240811213241_jgiRa | UK00AQ | 2024-09-04T12:07:32.231Z | 2024-09-06T12:06:39.403Z |
4966261 | 4966261 | 20240811212604_1wOae | UK00AQ | 2024-09-04T12:07:21.872Z | 2024-09-06T12:06:19.381Z |
4966222 | 4966222 | 20240811212545_LJicP | UK00AQ | 2024-09-04T12:07:21.087Z | 2024-09-06T12:06:17.852Z |
4966079 | 4966079 | 20240811212303_wmura | UK00AQ | 2024-09-04T12:07:17.767Z | 2024-09-06T12:06:11.404Z |
4965525 | 4965525 | 20240811211616_v2GAt | UK00AQ | 2024-09-04T12:07:00.145Z | 2024-09-06T12:05:58.926Z |
4965064 | 4965064 | 20240811210829_JG61U | UK00AQ | 2024-09-04T12:06:46.890Z | 2024-09-06T12:05:47.067Z |
4954447 | 4954447 | 20240811030121_6ZSc1 | UK00AQ | 2024-09-03T12:18:14.108Z | 2024-09-06T12:29:01.252Z |
4954139 | 4954139 | 20240811025300_iBJ5k | UK00AQ | 2024-09-03T12:18:08.282Z | 2024-09-06T12:28:51.176Z |
4953387 | 4953387 | 20240811023732_NoUpG | UK00AQ | 2024-09-03T12:17:39.074Z | 2024-09-06T12:28:25.417Z |
4952127 | 4952127 | 20240811021636_unDEh | UK00AQ | 2024-09-03T12:16:49.835Z | 2024-09-06T12:27:53.063Z |
4950819 | 4950819 | 20240811021227_w336D | UK00AQ | 2024-09-02T12:16:37.043Z | 2024-09-06T12:27:50.384Z |
4950259 | 4950259 | 20240811020412_aRC3Z | UK00AQ | 2024-09-02T12:16:19.111Z | 2024-09-06T12:27:42.691Z |
4949576 | 4949576 | 20240811015216_zuuDu | UK00AQ | 2024-09-02T12:15:49.750Z | 2024-09-06T12:27:35.219Z |
4949383 | 4949383 | 20240811014833_kWrON | UK00AQ | 2024-09-02T12:15:44.383Z | 2024-09-06T12:27:32.572Z |
4948952 | 4948952 | 20240811014256_9BEes | UK00AQ | 2024-09-02T12:15:26.440Z | 2024-09-06T12:27:28.436Z |
4948812 | 4948812 | 20240811014108_Kby2F | UK00AQ | 2024-09-02T12:15:20.289Z | 2024-09-06T12:27:27.461Z |
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);