participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,910 rows where station_code = "USL011" 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 |
---|---|---|---|---|---|
5505583 | 5505583 | 20241108061557_iEItE | USL011 | 2024-11-09T14:16:24.138Z | 2024-11-09T14:16:28.820Z |
5505470 | 5505470 | 20241108053022_kxuCX | USL011 | 2024-11-09T14:16:19.638Z | 2024-11-09T14:16:28.793Z |
5505229 | 5505229 | 20241108041102_zkDKC | USL011 | 2024-11-09T14:15:57.090Z | 2024-11-09T14:16:28.730Z |
5499553 | 5499553 | 20241108123619_fKdj2 | USL011 | 2024-11-09T14:04:18.375Z | 2024-11-09T14:04:18.375Z |
5499517 | 5499517 | 20241108123117_RgqPj | USL011 | 2024-11-09T14:04:15.072Z | 2024-11-09T14:04:15.072Z |
5498903 | 5498903 | 20241108102329_A2ur2 | USL011 | 2024-11-09T14:02:45.189Z | 2024-11-09T14:02:45.189Z |
5498866 | 5498866 | 20241108101629_02Z3g | USL011 | 2024-11-09T14:02:39.353Z | 2024-11-09T14:02:39.353Z |
5498853 | 5498853 | 20241108101426_QRPbo | USL011 | 2024-11-09T14:02:35.455Z | 2024-11-09T14:02:35.455Z |
5497918 | 5497918 | 20241107060122_XkVmv | USL011 | 2024-11-08T14:14:30.507Z | 2024-11-09T14:18:53.654Z |
5493622 | 5493622 | 20241107124529_3HLGG | USL011 | 2024-11-08T14:04:19.895Z | 2024-11-09T14:16:27.674Z |
5492901 | 5492901 | 20241107101748_F0pJl | USL011 | 2024-11-08T14:02:28.680Z | 2024-11-09T14:16:27.483Z |
5492328 | 5492328 | 20241107080909_xUGiL | USL011 | 2024-11-08T14:00:47.261Z | 2024-11-09T14:16:27.345Z |
5492324 | 5492324 | 20241107080829_V6SwY | USL011 | 2024-11-08T14:00:46.908Z | 2024-11-09T14:16:27.344Z |
5492194 | 5492194 | 20241107072513_BoK6z | USL011 | 2024-11-08T14:00:26.515Z | 2024-11-09T14:16:27.309Z |
5492131 | 5492131 | 20241107065740_cMaAD | USL011 | 2024-11-08T14:00:16.604Z | 2024-11-09T14:16:27.285Z |
5492113 | 5492113 | 20241107064601_eDiVm | USL011 | 2024-11-08T14:00:12.859Z | 2024-11-09T14:16:27.278Z |
5485481 | 5485481 | 20241105055744_NGZ9s | USL011 | 2024-11-06T14:18:21.389Z | 2024-11-09T14:21:22.081Z |
5480148 | 5480148 | 20241105114736_ssdCq | USL011 | 2024-11-06T14:04:38.585Z | 2024-11-09T14:19:19.023Z |
5479901 | 5479901 | 20241105105714_KUZMA | USL011 | 2024-11-06T14:03:51.475Z | 2024-11-09T14:19:13.637Z |
5479856 | 5479856 | 20241105105314_ZbjKj | USL011 | 2024-11-06T14:03:45.474Z | 2024-11-09T14:19:13.228Z |
5479822 | 5479822 | 20241105104635_NKtg2 | USL011 | 2024-11-06T14:03:40.103Z | 2024-11-09T14:19:12.698Z |
5479653 | 5479653 | 20241105101117_xL3g2 | USL011 | 2024-11-06T14:02:59.711Z | 2024-11-09T14:19:10.251Z |
5479356 | 5479356 | 20241105090954_6XkM6 | USL011 | 2024-11-06T14:02:05.583Z | 2024-11-09T14:19:04.758Z |
5479254 | 5479254 | 20241105084657_3lGkD | USL011 | 2024-11-06T14:01:36.975Z | 2024-11-09T14:19:02.551Z |
5479001 | 5479001 | 20241105072309_m37CS | USL011 | 2024-11-06T14:00:36.825Z | 2024-11-09T14:18:57.810Z |
5465334 | 5465334 | 20241103112856_HH2lZ | USL011 | 2024-11-04T14:03:24.260Z | 2024-11-09T14:21:32.228Z |
5464249 | 5464249 | 20241101061009_CetXn | USL011 | 2024-11-03T14:22:10.112Z | 2024-11-09T14:24:37.392Z |
5464242 | 5464242 | 20241101060513_Gf0Es | USL011 | 2024-11-03T14:22:09.949Z | 2024-11-09T14:24:37.336Z |
5464224 | 5464224 | 20241101054704_mlWhl | USL011 | 2024-11-03T14:22:09.550Z | 2024-11-09T14:24:36.890Z |
5464184 | 5464184 | 20241101045203_xsu1s | USL011 | 2024-11-03T14:22:05.947Z | 2024-11-09T14:24:34.243Z |
5464172 | 5464172 | 20241101042133_VXXos | USL011 | 2024-11-03T14:22:04.883Z | 2024-11-09T14:24:33.501Z |
5464168 | 5464168 | 20241101034942_0hEGy | USL011 | 2024-11-03T14:22:03.307Z | 2024-11-09T14:24:31.964Z |
5459880 | 5459880 | 20241101121032_UM5Q3 | USL011 | 2024-11-03T14:12:44.594Z | 2024-11-09T14:23:21.181Z |
5459604 | 5459604 | 20241101112307_XE2Cc | USL011 | 2024-11-03T14:12:21.451Z | 2024-11-09T14:23:19.963Z |
5459363 | 5459363 | 20241101104900_vOvVE | USL011 | 2024-11-03T14:11:44.780Z | 2024-11-09T14:23:17.534Z |
5459282 | 5459282 | 20241101103707_T03d3 | USL011 | 2024-11-03T14:11:37.622Z | 2024-11-09T14:23:17.304Z |
5459184 | 5459184 | 20241101102115_qHzRU | USL011 | 2024-11-03T14:11:28.037Z | 2024-11-09T14:23:16.883Z |
5458752 | 5458752 | 20241101091250_20eKh | USL011 | 2024-11-03T14:10:34.087Z | 2024-11-09T14:23:14.184Z |
5458687 | 5458687 | 20241101090323_OAdgh | USL011 | 2024-11-03T14:10:28.228Z | 2024-11-09T14:23:13.802Z |
5458659 | 5458659 | 20241101085911_5SRiR | USL011 | 2024-11-03T14:10:17.910Z | 2024-11-09T14:23:13.465Z |
5458569 | 5458569 | 20241101084419_7u1tI | USL011 | 2024-11-03T14:09:59.693Z | 2024-11-09T14:23:12.864Z |
5458511 | 5458511 | 20241101083732_teXrU | USL011 | 2024-11-03T14:09:53.421Z | 2024-11-09T14:23:12.754Z |
5458268 | 5458268 | 20241101075720_5JTQF | USL011 | 2024-11-03T14:09:24.772Z | 2024-11-09T14:23:11.145Z |
5456577 | 5456577 | 20241102114619_RidGe | USL011 | 2024-11-03T14:05:01.538Z | 2024-11-09T14:22:44.519Z |
5454848 | 5454848 | 20241031053210_DR3FI | USL011 | 2024-11-02T12:23:24.942Z | 2024-11-08T14:23:25.938Z |
5447647 | 5447647 | 20241031115848_Ft3nE | USL011 | 2024-11-02T12:08:45.348Z | 2024-11-09T14:24:00.701Z |
5447396 | 5447396 | 20241031113823_ekzei | USL011 | 2024-11-02T12:08:04.755Z | 2024-11-09T14:23:59.534Z |
5446788 | 5446788 | 20241031103211_kGsRn | USL011 | 2024-11-02T12:06:17.257Z | 2024-11-09T14:23:56.461Z |
5446246 | 5446246 | 20241031094110_walZu | USL011 | 2024-11-02T12:04:41.456Z | 2024-11-09T14:23:53.906Z |
5446209 | 5446209 | 20241031093833_kZmiI | USL011 | 2024-11-02T12:04:37.708Z | 2024-11-09T14:23:53.529Z |
5446106 | 5446106 | 20241031092839_809Ws | USL011 | 2024-11-02T12:04:16.276Z | 2024-11-09T14:23:52.934Z |
5445939 | 5445939 | 20241031090421_Rt4TQ | USL011 | 2024-11-02T12:03:37.702Z | 2024-11-09T14:23:52.014Z |
5445934 | 5445934 | 20241031090405_QWnQO | USL011 | 2024-11-02T12:03:36.956Z | 2024-11-09T14:23:52.001Z |
5445862 | 5445862 | 20241031085622_2nT49 | USL011 | 2024-11-02T12:03:24.690Z | 2024-11-09T14:23:51.727Z |
5445103 | 5445103 | 20241031065427_iC4sG | USL011 | 2024-11-02T12:00:56.272Z | 2024-11-09T14:23:47.502Z |
5443124 | 5443124 | 20241030033527_FoFLQ | USL011 | 2024-11-01T12:20:18.512Z | 2024-11-07T14:26:49.617Z |
5442526 | 5442526 | 20241030014506_ww9mV | USL011 | 2024-11-01T12:19:58.404Z | 2024-11-07T14:26:46.854Z |
5435277 | 5435277 | 20241030111227_s3JTc | USL011 | 2024-11-01T12:04:40.968Z | 2024-11-08T14:22:49.900Z |
5434399 | 5434399 | 20241030091528_j4iHg | USL011 | 2024-11-01T12:02:09.938Z | 2024-11-08T14:22:46.253Z |
5434360 | 5434360 | 20241030090417_iUeFs | USL011 | 2024-11-01T12:02:04.035Z | 2024-11-08T14:22:46.156Z |
5433927 | 5433927 | 20241030074009_A2Udk | USL011 | 2024-11-01T12:00:34.154Z | 2024-11-08T14:22:43.812Z |
5423953 | 5423953 | 20241029122844_unf2k | USL011 | 2024-10-31T12:03:17.659Z | 2024-11-07T14:26:29.747Z |
5423948 | 5423948 | 20241029122844_8S83p | USL011 | 2024-10-31T12:03:16.860Z | 2024-11-07T14:26:29.712Z |
5423488 | 5423488 | 20241029103058_BBWOw | USL011 | 2024-10-31T12:01:34.793Z | 2024-11-07T14:26:26.096Z |
5423177 | 5423177 | 20241029074831_iccT4 | USL011 | 2024-10-31T12:00:29.803Z | 2024-11-07T14:26:24.240Z |
5423137 | 5423137 | 20241029072802_62fV3 | USL011 | 2024-10-31T12:00:20.907Z | 2024-11-07T14:26:24.087Z |
5422112 | 5422112 | 20241028121612_7KeH1 | USL011 | 2024-10-30T12:20:22.361Z | 2024-11-06T14:27:09.392Z |
5421912 | 5421912 | 20241028115834_XKU91 | USL011 | 2024-10-30T12:20:17.802Z | 2024-11-06T14:27:08.840Z |
5421745 | 5421745 | 20241028113009_V0xf5 | USL011 | 2024-10-30T12:20:14.096Z | 2024-11-06T14:27:08.368Z |
5421553 | 5421553 | 20241028105912_GOARU | USL011 | 2024-10-30T12:20:06.336Z | 2024-11-06T14:27:07.667Z |
5421514 | 5421514 | 20241028105155_36m2v | USL011 | 2024-10-30T12:20:03.495Z | 2024-11-06T14:27:07.551Z |
5413457 | 5413457 | 20241028100301_gU2U4 | USL011 | 2024-10-30T12:03:06.322Z | 2024-11-06T14:27:06.002Z |
5413112 | 5413112 | 20241028085216_7Kauj | USL011 | 2024-10-30T12:01:53.536Z | 2024-11-06T14:27:04.418Z |
5413067 | 5413067 | 20241028083956_wDSQp | USL011 | 2024-10-30T12:01:43.394Z | 2024-11-06T14:27:04.332Z |
5412802 | 5412802 | 20241028073737_N53X3 | USL011 | 2024-10-30T12:00:43.297Z | 2024-11-06T14:27:02.683Z |
5412756 | 5412756 | 20241028072141_9oEk0 | USL011 | 2024-10-30T12:00:33.825Z | 2024-11-06T14:27:02.236Z |
5399054 | 5399054 | 20241026034712_VcOcZ | USL011 | 2024-10-28T12:19:45.834Z | 2024-11-03T14:27:38.949Z |
5391685 | 5391685 | 20241026124121_J001C | USL011 | 2024-10-28T12:06:13.758Z | 2024-11-04T14:28:36.112Z |
5391536 | 5391536 | 20241026121310_MsGFJ | USL011 | 2024-10-28T12:05:47.927Z | 2024-11-04T14:28:35.410Z |
5388873 | 5388873 | 20241025062043_ua3rx | USL011 | 2024-10-27T12:22:34.492Z | 2024-11-02T12:28:35.102Z |
5388350 | 5388350 | 20241025043716_woJOP | USL011 | 2024-10-27T12:22:10.544Z | 2024-11-02T12:28:33.972Z |
5380620 | 5380620 | 20241025112038_vHq9l | USL011 | 2024-10-27T12:06:21.177Z | 2024-11-03T14:27:11.691Z |
5380543 | 5380543 | 20241025110855_sCR7H | USL011 | 2024-10-27T12:06:09.917Z | 2024-11-03T14:27:11.446Z |
5379737 | 5379737 | 20241025090743_H2h2C | USL011 | 2024-10-27T12:03:51.188Z | 2024-11-03T14:27:08.214Z |
5379690 | 5379690 | 20241025090022_HEBN4 | USL011 | 2024-10-27T12:03:42.929Z | 2024-11-03T14:27:08.109Z |
5379432 | 5379432 | 20241025083554_rcTJf | USL011 | 2024-10-27T12:02:59.726Z | 2024-11-03T14:27:07.567Z |
5379301 | 5379301 | 20241025081657_BC8fN | USL011 | 2024-10-27T12:02:41.835Z | 2024-11-03T14:27:06.702Z |
5379297 | 5379297 | 20241025081647_8zLJq | USL011 | 2024-10-27T12:02:41.379Z | 2024-11-03T14:27:06.699Z |
5378765 | 5378765 | 20241025070713_OzIyR | USL011 | 2024-10-27T12:00:42.812Z | 2024-11-03T14:27:04.794Z |
5369952 | 5369952 | 20241024121309_0eWi3 | USL011 | 2024-10-26T12:08:21.058Z | 2024-11-02T12:28:19.659Z |
5369112 | 5369112 | 20241024105709_IWQ0T | USL011 | 2024-10-26T12:05:53.782Z | 2024-11-02T12:28:17.545Z |
5369046 | 5369046 | 20241024104633_i9XNe | USL011 | 2024-10-26T12:05:43.104Z | 2024-11-02T12:28:17.354Z |
5369003 | 5369003 | 20241024103923_RwCTz | USL011 | 2024-10-26T12:05:28.819Z | 2024-11-02T12:28:17.200Z |
5368957 | 5368957 | 20241024103436_3MVBi | USL011 | 2024-10-26T12:05:17.362Z | 2024-11-02T12:28:17.174Z |
5368296 | 5368296 | 20241024090040_3AgJO | USL011 | 2024-10-26T12:03:02.193Z | 2024-11-02T12:28:15.347Z |
5367963 | 5367963 | 20241024080833_SQALX | USL011 | 2024-10-26T12:02:09.115Z | 2024-11-02T12:28:14.825Z |
5367788 | 5367788 | 20241024074015_B22Ma | USL011 | 2024-10-26T12:01:31.500Z | 2024-11-02T12:28:14.613Z |
5356763 | 5356763 | 20241023075301_yS8GS | USL011 | 2024-10-25T12:01:33.406Z | 2024-11-01T12:26:37.003Z |
5356596 | 5356596 | 20241023072149_WU783 | USL011 | 2024-10-25T12:01:01.908Z | 2024-11-01T12:26:36.259Z |
5346240 | 5346240 | 20241022113838_yAEnQ | USL011 | 2024-10-24T12:04:08.646Z | 2024-10-31T12:29:46.487Z |
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);