participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,992 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 |
---|---|---|---|---|---|
5583383 | 5583383 | 20241119115225_73zsN | USL011 | 2024-11-23T14:24:11.705Z | 2024-11-23T14:24:11.705Z |
5576516 | 5576516 | 20241122122248_XMZ6U | USL011 | 2024-11-23T14:09:42.996Z | 2024-11-23T14:09:42.996Z |
5575687 | 5575687 | 20241122100050_M2930 | USL011 | 2024-11-23T14:07:18.137Z | 2024-11-23T14:07:18.137Z |
5575680 | 5575680 | 20241122095930_fwuVq | USL011 | 2024-11-23T14:07:15.604Z | 2024-11-23T14:07:15.604Z |
5575607 | 5575607 | 20241122094915_MbkCz | USL011 | 2024-11-23T14:06:57.483Z | 2024-11-23T14:06:57.483Z |
5575158 | 5575158 | 20241122082501_btX1a | USL011 | 2024-11-23T14:05:37.872Z | 2024-11-23T14:05:37.872Z |
5574928 | 5574928 | 20241122070628_J4Rkr | USL011 | 2024-11-23T14:04:49.974Z | 2024-11-23T14:04:49.974Z |
5574894 | 5574894 | 20241122065757_GxLlv | USL011 | 2024-11-23T14:04:46.155Z | 2024-11-23T14:04:46.155Z |
5574818 | 5574818 | 20241122063131_XDnDF | USL011 | 2024-11-23T14:04:30.265Z | 2024-11-23T14:04:30.265Z |
5574792 | 5574792 | 20241122062859_u3O0b | USL011 | 2024-11-23T14:04:25.984Z | 2024-11-23T14:04:25.984Z |
5573957 | 5573957 | 20241122045522_4WUuN | USL011 | 2024-11-23T14:02:00.249Z | 2024-11-23T14:02:00.249Z |
5568533 | 5568533 | 20241121125609_idjwE | USL011 | 2024-11-22T14:09:17.278Z | 2024-11-23T14:21:24.302Z |
5568288 | 5568288 | 20241121121908_uwPnT | USL011 | 2024-11-22T14:08:38.839Z | 2024-11-23T14:21:24.244Z |
5568223 | 5568223 | 20241121120848_93ws9 | USL011 | 2024-11-22T14:08:30.792Z | 2024-11-23T14:21:24.226Z |
5568136 | 5568136 | 20241121115403_Nv0Qt | USL011 | 2024-11-22T14:08:11.654Z | 2024-11-23T14:21:24.201Z |
5567572 | 5567572 | 20241121103633_Z9ZQf | USL011 | 2024-11-22T14:06:32.514Z | 2024-11-23T14:21:24.046Z |
5567566 | 5567566 | 20241121103502_v2a6X | USL011 | 2024-11-22T14:06:31.827Z | 2024-11-22T14:06:31.827Z |
5567374 | 5567374 | 20241121100649_GleMk | USL011 | 2024-11-22T14:06:01.827Z | 2024-11-23T14:21:23.993Z |
5567214 | 5567214 | 20241121094228_yPoWW | USL011 | 2024-11-22T14:05:35.168Z | 2024-11-23T14:21:23.949Z |
5567151 | 5567151 | 20241121093437_fZTK2 | USL011 | 2024-11-22T14:05:27.390Z | 2024-11-23T14:21:23.927Z |
5567065 | 5567065 | 20241121090808_p2MAp | USL011 | 2024-11-22T14:05:02.168Z | 2024-11-23T14:21:23.895Z |
5565275 | 5565275 | 20241120041116_3o4qs | USL011 | 2024-11-21T14:18:44.385Z | 2024-11-23T14:24:46.474Z |
5560472 | 5560472 | 20241120125456_5PQBE | USL011 | 2024-11-21T14:08:55.376Z | 2024-11-23T14:22:36.319Z |
5560019 | 5560019 | 20241120114630_i8wCF | USL011 | 2024-11-21T14:07:52.487Z | 2024-11-23T14:22:28.032Z |
5559316 | 5559316 | 20241120100256_gubr2 | USL011 | 2024-11-21T14:05:57.199Z | 2024-11-23T14:22:13.101Z |
5559256 | 5559256 | 20241120094813_KcpQg | USL011 | 2024-11-21T14:05:44.634Z | 2024-11-23T14:22:11.489Z |
5558977 | 5558977 | 20241120090140_tf32I | USL011 | 2024-11-21T14:04:56.527Z | 2024-11-23T14:22:04.701Z |
5558806 | 5558806 | 20241120081003_iNhWU | USL011 | 2024-11-21T14:04:26.478Z | 2024-11-23T14:22:01.617Z |
5558685 | 5558685 | 20241120072913_EdjDZ | USL011 | 2024-11-21T14:04:03.010Z | 2024-11-23T14:21:58.984Z |
5558683 | 5558683 | 20241120072831_L45WV | USL011 | 2024-11-21T14:04:02.514Z | 2024-11-23T14:21:58.893Z |
5557773 | 5557773 | 20241120051111_mOyHf | USL011 | 2024-11-21T14:01:43.116Z | 2024-11-23T14:21:41.609Z |
5557221 | 5557221 | 20241119044002_rZN5A | USL011 | 2024-11-20T14:12:28.735Z | 2024-11-23T14:25:10.766Z |
5554875 | 5554875 | 20241119105239_3R2LS | USL011 | 2024-11-20T14:03:40.987Z | 2024-11-23T14:24:09.199Z |
5554636 | 5554636 | 20241119095243_mNCqG | USL011 | 2024-11-20T14:02:52.202Z | 2024-11-23T14:24:06.574Z |
5554583 | 5554583 | 20241119094158_N5qb5 | USL011 | 2024-11-20T14:02:32.348Z | 2024-11-23T14:24:05.650Z |
5554575 | 5554575 | 20241119093951_HXSux | USL011 | 2024-11-20T14:02:31.226Z | 2024-11-23T14:24:05.600Z |
5554521 | 5554521 | 20241119092552_P7LqP | USL011 | 2024-11-20T14:02:21.413Z | 2024-11-23T14:24:04.732Z |
5550133 | 5550133 | 20241118093619_AMGxS | USL011 | 2024-11-19T14:01:36.813Z | 2024-11-23T14:24:53.177Z |
5550061 | 5550061 | 20241118092217_cbGsg | USL011 | 2024-11-19T14:01:31.561Z | 2024-11-23T14:24:52.853Z |
5549989 | 5549989 | 20241118090325_odLQe | USL011 | 2024-11-19T14:01:24.971Z | 2024-11-23T14:24:52.279Z |
5549938 | 5549938 | 20241118084951_2o4gL | USL011 | 2024-11-19T14:01:16.432Z | 2024-11-23T14:24:51.730Z |
5549912 | 5549912 | 20241118084347_kMPaX | USL011 | 2024-11-19T14:01:13.637Z | 2024-11-23T14:24:51.638Z |
5549894 | 5549894 | 20241118083404_qoYt2 | USL011 | 2024-11-19T14:01:09.368Z | 2024-11-23T14:24:51.518Z |
5549835 | 5549835 | 20241118074453_916Vl | USL011 | 2024-11-19T14:00:58.122Z | 2024-11-23T14:24:50.763Z |
5541003 | 5541003 | 20241114124445_VYI38 | USL011 | 2024-11-15T14:04:55.421Z | 2024-11-23T14:26:14.388Z |
5540042 | 5540042 | 20241114095327_kRj1t | USL011 | 2024-11-15T14:02:42.080Z | 2024-11-23T14:26:08.788Z |
5538364 | 5538364 | 20241113032045_2qItd | USL011 | 2024-11-14T14:13:20.312Z | 2024-11-21T14:26:24.923Z |
5535362 | 5535362 | 20241112121852_eYZf0 | USL011 | 2024-11-14T14:07:51.398Z | 2024-11-21T14:25:46.674Z |
5535334 | 5535334 | 20241112121217_k3062 | USL011 | 2024-11-14T14:07:49.318Z | 2024-11-21T14:25:46.482Z |
5535177 | 5535177 | 20241112115215_k2031 | USL011 | 2024-11-14T14:07:25.879Z | 2024-11-21T14:25:44.522Z |
5535096 | 5535096 | 20241112113730_7rdY2 | USL011 | 2024-11-14T14:07:14.815Z | 2024-11-21T14:25:43.849Z |
5534570 | 5534570 | 20241113123920_WmOEK | USL011 | 2024-11-14T14:04:35.966Z | 2024-11-22T14:24:14.616Z |
5534132 | 5534132 | 20241113110312_Jjm7J | USL011 | 2024-11-14T14:03:38.911Z | 2024-11-22T14:24:12.499Z |
5534065 | 5534065 | 20241113105328_3JB43 | USL011 | 2024-11-14T14:03:30.989Z | 2024-11-22T14:24:12.177Z |
5527037 | 5527037 | 20241112105041_tq0VK | USL011 | 2024-11-13T14:04:54.102Z | 2024-11-21T14:25:40.762Z |
5526999 | 5526999 | 20241112104320_fTR14 | USL011 | 2024-11-13T14:04:49.125Z | 2024-11-21T14:25:40.210Z |
5526723 | 5526723 | 20241112100656_zYQJK | USL011 | 2024-11-13T14:04:00.690Z | 2024-11-21T14:25:37.414Z |
5526635 | 5526635 | 20241112095657_mDkKo | USL011 | 2024-11-13T14:03:40.912Z | 2024-11-21T14:25:36.877Z |
5526620 | 5526620 | 20241112095547_CZoLc | USL011 | 2024-11-13T14:03:39.073Z | 2024-11-21T14:25:36.848Z |
5526548 | 5526548 | 20241112094401_rfKaF | USL011 | 2024-11-13T14:03:28.015Z | 2024-11-21T14:25:36.228Z |
5526510 | 5526510 | 20241112093525_mH5Vs | USL011 | 2024-11-13T14:03:21.803Z | 2024-11-21T14:25:36.058Z |
5517155 | 5517155 | 20241110025510_vGZOQ | USL011 | 2024-11-11T14:13:58.850Z | 2024-11-18T14:26:34.963Z |
5516544 | 5516544 | 20241110011702_k1mwz | USL011 | 2024-11-11T14:13:07.536Z | 2024-11-18T14:26:31.852Z |
5513809 | 5513809 | 20241110122313_MBIKW | USL011 | 2024-11-11T14:05:29.927Z | 2024-11-19T14:21:37.882Z |
5513745 | 5513745 | 20241110121728_QycIF | USL011 | 2024-11-11T14:05:24.859Z | 2024-11-19T14:21:37.487Z |
5513456 | 5513456 | 20241110113405_CewqE | USL011 | 2024-11-11T14:04:40.362Z | 2024-11-19T14:21:34.292Z |
5513400 | 5513400 | 20241110112549_9cOiH | USL011 | 2024-11-11T14:04:35.101Z | 2024-11-19T14:21:33.837Z |
5513124 | 5513124 | 20241110103927_RdMGA | USL011 | 2024-11-11T14:03:55.393Z | 2024-11-19T14:21:31.330Z |
5512716 | 5512716 | 20241110093538_wbejo | USL011 | 2024-11-11T14:03:00.953Z | 2024-11-19T14:21:27.644Z |
5511698 | 5511698 | 20241110064050_W7Srg | USL011 | 2024-11-11T14:00:34.331Z | 2024-11-19T14:21:15.393Z |
5511670 | 5511670 | 20241110063653_VvqTi | USL011 | 2024-11-11T14:00:27.385Z | 2024-11-19T14:21:15.081Z |
5511405 | 5511405 | 20241109060512_Q5NGt | USL011 | 2024-11-10T14:16:46.291Z | 2024-11-17T14:24:08.651Z |
5507700 | 5507700 | 20241109121102_3CDMA | USL011 | 2024-11-10T14:05:49.115Z | 2024-11-18T14:26:13.463Z |
5507548 | 5507548 | 20241109114913_4MwQ2 | USL011 | 2024-11-10T14:05:31.503Z | 2024-11-18T14:26:11.936Z |
5507342 | 5507342 | 20241109111719_2WHkE | USL011 | 2024-11-10T14:04:53.981Z | 2024-11-18T14:26:09.941Z |
5507205 | 5507205 | 20241109105220_CSCpQ | USL011 | 2024-11-10T14:04:38.426Z | 2024-11-18T14:26:08.443Z |
5506947 | 5506947 | 20241109100423_Uj8xa | USL011 | 2024-11-10T14:03:55.026Z | 2024-11-18T14:26:04.176Z |
5506854 | 5506854 | 20241109094730_l6FL0 | USL011 | 2024-11-10T14:03:30.204Z | 2024-11-18T14:26:02.972Z |
5506754 | 5506754 | 20241109093139_UwSyp | USL011 | 2024-11-10T14:03:15.518Z | 2024-11-18T14:26:02.069Z |
5506286 | 5506286 | 20241109081228_EoeRa | USL011 | 2024-11-10T14:01:45.066Z | 2024-11-18T14:25:58.180Z |
5506136 | 5506136 | 20241109074414_ILXo1 | USL011 | 2024-11-10T14:01:19.162Z | 2024-11-18T14:25:56.779Z |
5506020 | 5506020 | 20241109072522_Dchs6 | USL011 | 2024-11-10T14:01:03.239Z | 2024-11-18T14:25:55.649Z |
5505583 | 5505583 | 20241108061557_iEItE | USL011 | 2024-11-09T14:16:24.138Z | 2024-11-16T14:28:33.911Z |
5505470 | 5505470 | 20241108053022_kxuCX | USL011 | 2024-11-09T14:16:19.638Z | 2024-11-16T14:28:32.511Z |
5505229 | 5505229 | 20241108041102_zkDKC | USL011 | 2024-11-09T14:15:57.090Z | 2024-11-16T14:28:28.594Z |
5499553 | 5499553 | 20241108123619_fKdj2 | USL011 | 2024-11-09T14:04:18.375Z | 2024-11-17T14:23:12.990Z |
5499517 | 5499517 | 20241108123117_RgqPj | USL011 | 2024-11-09T14:04:15.072Z | 2024-11-17T14:23:12.643Z |
5498903 | 5498903 | 20241108102329_A2ur2 | USL011 | 2024-11-09T14:02:45.189Z | 2024-11-17T14:23:01.314Z |
5498866 | 5498866 | 20241108101629_02Z3g | USL011 | 2024-11-09T14:02:39.353Z | 2024-11-17T14:23:00.823Z |
5498853 | 5498853 | 20241108101426_QRPbo | USL011 | 2024-11-09T14:02:35.455Z | 2024-11-17T14:23:00.616Z |
5497918 | 5497918 | 20241107060122_XkVmv | USL011 | 2024-11-08T14:14:30.507Z | 2024-11-15T14:25:06.751Z |
5493622 | 5493622 | 20241107124529_3HLGG | USL011 | 2024-11-08T14:04:19.895Z | 2024-11-16T14:27:37.461Z |
5492901 | 5492901 | 20241107101748_F0pJl | USL011 | 2024-11-08T14:02:28.680Z | 2024-11-16T14:27:30.390Z |
5492328 | 5492328 | 20241107080909_xUGiL | USL011 | 2024-11-08T14:00:47.261Z | 2024-11-16T14:27:24.073Z |
5492324 | 5492324 | 20241107080829_V6SwY | USL011 | 2024-11-08T14:00:46.908Z | 2024-11-16T14:27:24.038Z |
5492194 | 5492194 | 20241107072513_BoK6z | USL011 | 2024-11-08T14:00:26.515Z | 2024-11-16T14:27:22.989Z |
5492131 | 5492131 | 20241107065740_cMaAD | USL011 | 2024-11-08T14:00:16.604Z | 2024-11-16T14:27:22.115Z |
5492113 | 5492113 | 20241107064601_eDiVm | USL011 | 2024-11-08T14:00:12.859Z | 2024-11-16T14:27:22.015Z |
5485481 | 5485481 | 20241105055744_NGZ9s | USL011 | 2024-11-06T14:18:21.389Z | 2024-11-13T14:27:42.584Z |
5480148 | 5480148 | 20241105114736_ssdCq | USL011 | 2024-11-06T14:04:38.585Z | 2024-11-14T14:23:02.791Z |
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);