home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

109 rows where station_code = "SI0007" sorted by created_at descending

✎ View and edit SQL

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
8439163 8439163 20251112032049_nopof SI0007 2025-11-13T14:25:51.180Z 2025-11-20T15:25:11.389Z
8439147 8439147 20251112031923_hNQO9 SI0007 2025-11-13T14:25:50.535Z 2025-11-13T14:25:50.535Z
8439117 8439117 20251112031527_Qfpfk SI0007 2025-11-13T14:25:45.917Z 2025-11-20T15:25:05.501Z
8439028 8439028 20251112030359_jMQQH SI0007 2025-11-13T14:25:23.764Z 2025-11-20T15:24:56.551Z
8439008 8439008 20251112030236_FZ2iB SI0007 2025-11-13T14:25:21.572Z 2025-11-13T14:25:21.572Z
8438966 8438966 20251112025753_wPYdS SI0007 2025-11-13T14:25:14.595Z 2025-11-20T15:24:54.959Z
8438918 8438918 20251112025149_mBd5D SI0007 2025-11-13T14:25:08.921Z 2025-11-20T15:24:51.763Z
8438900 8438900 20251112024945_08gAT SI0007 2025-11-13T14:25:07.791Z 2025-11-20T15:24:50.689Z
8438817 8438817 20251112024308_sJF7P SI0007 2025-11-13T14:24:59.257Z 2025-11-13T14:24:59.257Z
8438794 8438794 20251112023959_f3BfF SI0007 2025-11-13T14:24:43.390Z 2025-11-20T15:24:47.959Z
8438681 8438681 20251112022627_xPPkD SI0007 2025-11-13T14:24:29.232Z 2025-11-20T15:24:45.197Z
8438676 8438676 20251112022601_g3BJN SI0007 2025-11-13T14:24:28.892Z 2025-11-20T15:24:45.150Z
8438664 8438664 20251112022424_hPQPb SI0007 2025-11-13T14:24:27.982Z 2025-11-20T15:24:45.066Z
8438650 8438650 20251112022335_IKXLw SI0007 2025-11-13T14:24:26.017Z 2025-11-20T15:24:44.848Z
8438626 8438626 20251112021912_bIvNZ SI0007 2025-11-13T14:24:21.939Z 2025-11-20T15:24:43.159Z
8438593 8438593 20251112021718_WSvMc SI0007 2025-11-13T14:24:18.572Z 2025-11-20T15:24:41.968Z
8438517 8438517 20251112020815_N2Z6R SI0007 2025-11-13T14:23:57.698Z 2025-11-20T15:24:38.291Z
8438445 8438445 20251112015939_4ilTI SI0007 2025-11-13T14:23:47.714Z 2025-11-20T15:24:35.225Z
8438413 8438413 20251112015340_eBAxq SI0007 2025-11-13T14:23:44.328Z 2025-11-20T15:24:33.032Z
8438327 8438327 20251112014432_i1Q7T SI0007 2025-11-13T14:23:34.004Z 2025-11-20T15:24:25.248Z
8438275 8438275 20251112014220_rGkSU SI0007 2025-11-13T14:23:13.555Z 2025-11-20T15:24:23.099Z
8438231 8438231 20251112013836_30tLt SI0007 2025-11-13T14:23:07.197Z 2025-11-20T15:24:19.274Z
8438184 8438184 20251112013431_GRKYf SI0007 2025-11-13T14:23:01.821Z 2025-11-20T15:24:17.505Z
8438172 8438172 20251112013206_EVoDd SI0007 2025-11-13T14:23:00.369Z 2025-11-20T15:24:17.029Z
8438113 8438113 20251112012505_FPnxO SI0007 2025-11-13T14:22:53.831Z 2025-11-20T15:24:14.796Z
8438084 8438084 20251112012009_IOo6g SI0007 2025-11-13T14:22:51.716Z 2025-11-20T15:24:13.393Z
8438063 8438063 20251112011719_j2aKB SI0007 2025-11-13T14:22:49.996Z 2025-11-20T15:24:13.063Z
8438024 8438024 20251112011042_1Q76u SI0007 2025-11-13T14:22:32.417Z 2025-11-20T15:24:11.336Z
8437992 8437992 20251112010824_dnTu2 SI0007 2025-11-13T14:22:29.447Z 2025-11-20T15:24:05.313Z
8437987 8437987 20251112010719_ecP0K SI0007 2025-11-13T14:22:28.919Z 2025-11-20T15:24:05.283Z
8437964 8437964 20251112010333_MJago SI0007 2025-11-13T14:22:22.487Z 2025-11-20T15:24:02.205Z
8437945 8437945 20251112010031_9Lje1 SI0007 2025-11-13T14:22:20.480Z 2025-11-20T15:24:01.505Z
8437787 8437787 20251112004441_zB1su SI0007 2025-11-13T14:22:05.545Z 2025-11-20T15:23:53.614Z
8437782 8437782 20251112004433_V6cO3 SI0007 2025-11-13T14:22:05.311Z 2025-11-20T15:23:53.592Z
8437768 8437768 20251112004330_KI7KI SI0007 2025-11-13T14:21:54.808Z 2025-11-20T15:23:53.463Z
8437766 8437766 20251112004207_ADbfc SI0007 2025-11-13T14:21:53.224Z 2025-11-20T15:23:53.437Z
8437757 8437757 20251112004132_rf7cu SI0007 2025-11-13T14:21:52.844Z 2025-11-20T15:23:52.823Z
8437677 8437677 20251112003327_28WJC SI0007 2025-11-13T14:21:46.476Z 2025-11-20T15:23:49.928Z
8437661 8437661 20251112003213_TKoYy SI0007 2025-11-13T14:21:45.616Z 2025-11-20T15:23:49.859Z
8437627 8437627 20251112003001_VD2mr SI0007 2025-11-13T14:21:43.163Z 2025-11-20T15:23:49.088Z
8437611 8437611 20251112002553_GEu00 SI0007 2025-11-13T14:21:31.154Z 2025-11-20T15:23:48.539Z
8437576 8437576 20251112001945_E657K SI0007 2025-11-13T14:21:23.238Z 2025-11-20T15:23:44.030Z
8437572 8437572 20251112001917_3mZzr SI0007 2025-11-13T14:21:22.729Z 2025-11-20T15:23:44.018Z
8437500 8437500 20251112001050_9UPlE SI0007 2025-11-13T14:21:12.672Z 2025-11-20T15:23:37.476Z
8437487 8437487 20251112000912_RDMQJ SI0007 2025-11-13T14:21:11.149Z 2025-11-20T15:23:37.259Z
8437473 8437473 20251112000828_0jOBz SI0007 2025-11-13T14:21:09.542Z 2025-11-20T15:23:37.016Z
8437433 8437433 20251112000503_xdlkx SI0007 2025-11-13T14:21:05.460Z 2025-11-20T15:23:33.627Z
8437425 8437425 20251112000318_AYil3 SI0007 2025-11-13T14:21:04.650Z 2025-11-20T15:23:33.417Z
8437419 8437419 20251112000241_qTtmb SI0007 2025-11-13T14:21:03.821Z 2025-11-20T15:23:32.993Z
8437410 8437410 20251112000101_lPdJ5 SI0007 2025-11-13T14:21:02.742Z 2025-11-20T15:23:30.032Z
8437396 8437396 20251111235734_CWZbK SI0007 2025-11-13T14:21:01.329Z 2025-11-20T15:23:29.745Z
8437350 8437350 20251111235303_ArA2O SI0007 2025-11-13T14:20:54.240Z 2025-11-20T15:23:28.638Z
8437272 8437272 20251111234707_w7H5w SI0007 2025-11-13T14:20:34.172Z 2025-11-20T15:23:24.960Z
8437236 8437236 20251111234305_fHGxg SI0007 2025-11-13T14:20:27.954Z 2025-11-20T15:23:20.937Z
8437231 8437231 20251111234302_ZpbdB SI0007 2025-11-13T14:20:27.835Z 2025-11-20T15:23:20.932Z
8437221 8437221 20251111234058_KqtVs SI0007 2025-11-13T14:20:26.996Z 2025-11-20T15:23:20.576Z
8412233 8412233 20251109195715_A2pKW SI0007 2025-11-11T14:13:24.778Z 2025-11-18T15:20:09.028Z
8412195 8412195 20251109195514_Y7fKY SI0007 2025-11-11T14:13:19.805Z 2025-11-18T15:20:08.491Z
8412027 8412027 20251109194447_PdYWQ SI0007 2025-11-11T14:12:49.047Z 2025-11-18T15:20:04.634Z
8412007 8412007 20251109194009_KxKZ5 SI0007 2025-11-11T14:12:45.077Z 2025-11-18T15:19:58.112Z
8411883 8411883 20251109192945_mdlAi SI0007 2025-11-11T14:12:15.889Z 2025-11-18T15:19:54.768Z
8411379 8411379 20251109184536_afuWt SI0007 2025-11-11T14:10:46.245Z 2025-11-18T15:19:36.337Z
8411374 8411374 20251109184535_9PhEn SI0007 2025-11-11T14:10:45.971Z 2025-11-18T15:19:36.326Z
8411282 8411282 20251109183220_jQv3K SI0007 2025-11-11T14:10:22.775Z 2025-11-18T15:19:31.832Z
8411100 8411100 20251109180854_bgWhw SI0007 2025-11-11T14:09:44.655Z 2025-11-18T15:19:24.238Z
8411070 8411070 20251109180436_ZBB3C SI0007 2025-11-11T14:09:41.159Z 2025-11-18T15:19:23.911Z
8410990 8410990 20251109175629_QU3Wx SI0007 2025-11-11T14:09:30.017Z 2025-11-18T15:19:22.927Z
8410986 8410986 20251109175619_vqfpQ SI0007 2025-11-11T14:09:29.368Z 2025-11-18T15:19:22.910Z
8410866 8410866 20251109174210_DnGaC SI0007 2025-11-11T14:08:58.113Z 2025-11-18T15:19:15.702Z
8410861 8410861 20251109174209_RmIm4 SI0007 2025-11-11T14:08:57.790Z 2025-11-18T15:19:15.588Z
8397771 8397771 20251108023714_XDBuv SI0007 2025-11-09T14:13:12.973Z 2025-11-16T15:04:27.323Z
8397587 8397587 20251108021013_TRJ7w SI0007 2025-11-09T14:12:40.602Z 2025-11-16T15:04:23.012Z
8397415 8397415 20251108013952_yxi8B SI0007 2025-11-09T14:12:12.311Z 2025-11-16T15:04:17.577Z
8397289 8397289 20251108011622_m3jrJ SI0007 2025-11-09T14:11:43.921Z 2025-11-16T15:04:13.221Z
8397264 8397264 20251108010945_BirRh SI0007 2025-11-09T14:11:38.561Z 2025-11-16T15:04:12.298Z
8397095 8397095 20251108003314_nyyBR SI0007 2025-11-09T14:10:57.683Z 2025-11-16T15:04:00.348Z
8397086 8397086 20251108003029_geSEE SI0007 2025-11-09T14:10:55.969Z 2025-11-16T15:04:00.121Z
8397078 8397078 20251108002804_gXjmR SI0007 2025-11-09T14:10:50.927Z 2025-11-16T15:03:59.897Z
8397071 8397071 20251108002728_8YG07 SI0007 2025-11-09T14:10:48.915Z 2025-11-16T15:03:59.825Z
8396877 8396877 20251107233018_KBeat SI0007 2025-11-09T14:10:02.392Z 2025-11-16T15:03:44.688Z
8396850 8396850 20251107232154_nSUVN SI0007 2025-11-09T14:09:59.600Z 2025-11-16T15:03:44.403Z
8396811 8396811 20251107231331_LyWI0 SI0007 2025-11-09T14:09:51.661Z 2025-11-16T15:03:41.674Z
8396804 8396804 20251107231104_KxAQA SI0007 2025-11-09T14:09:50.565Z 2025-11-16T15:03:41.332Z
8396796 8396796 20251107230901_jiNEy SI0007 2025-11-09T14:09:49.376Z 2025-11-16T15:03:41.173Z
8396766 8396766 20251107225651_atMJT SI0007 2025-11-09T14:09:44.218Z 2025-11-16T15:03:39.591Z
8396743 8396743 20251107224712_q6G32 SI0007 2025-11-09T14:09:39.946Z 2025-11-16T15:03:39.076Z
8396711 8396711 20251107223813_dCTfY SI0007 2025-11-09T14:09:30.345Z 2025-11-16T15:03:38.648Z
8396686 8396686 20251107223315_KeT5n SI0007 2025-11-09T14:09:24.674Z 2025-11-16T15:03:37.094Z
8383162 8383162 20251104001044_EqE3U SI0007 2025-11-06T14:24:04.156Z 2025-11-12T15:10:12.993Z
8383158 8383158 20251103235502_qyiPW SI0007 2025-11-06T14:24:02.438Z 2025-11-12T15:10:10.314Z
8383151 8383151 20251103234445_4AwrZ SI0007 2025-11-06T14:24:00.381Z 2025-11-12T15:10:07.212Z
8383149 8383149 20251103233923_dMsIT SI0007 2025-11-06T14:23:59.453Z 2025-11-12T15:10:06.271Z
8383140 8383140 20251103233645_2EHeu SI0007 2025-11-06T14:23:58.129Z 2025-11-12T15:10:05.277Z
8383131 8383131 20251103232044_14Vn9 SI0007 2025-11-06T14:23:55.388Z 2025-11-12T15:09:57.847Z
8383126 8383126 20251103232010_n2ZpE SI0007 2025-11-06T14:23:54.838Z 2025-11-12T15:09:56.692Z
8383124 8383124 20251103231509_igTXS SI0007 2025-11-06T14:23:54.043Z 2025-11-12T15:09:52.794Z
8383111 8383111 20251103223331_68y7S SI0007 2025-11-06T14:23:48.684Z 2025-11-12T15:09:41.946Z
8383098 8383098 20251103221921_soF4R SI0007 2025-11-06T14:23:32.280Z 2025-11-12T15:09:37.529Z
8380289 8380289 20251105013248_uhrBB SI0007 2025-11-06T14:11:14.926Z 2025-11-13T15:14:48.660Z
8380276 8380276 20251105013012_cl3AL SI0007 2025-11-06T14:11:12.980Z 2025-11-13T15:14:48.440Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network