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

>10,000 rows count all where station_code = "IT0001" 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
9611797 9611797 20260405032541_lBAZG IT0001 2026-04-06T12:16:01.534Z 2026-04-06T12:16:14.864Z
9611625 9611625 20260405024956_4gi2b IT0001 2026-04-06T12:15:18.461Z 2026-04-06T12:16:14.835Z
9611154 9611154 20260405003419_Jptnc IT0001 2026-04-06T12:13:19.607Z 2026-04-06T12:16:14.743Z
9611103 9611103 20260405000926_Q6ekk IT0001 2026-04-06T12:13:00.113Z 2026-04-06T12:16:14.732Z
9610728 9610728 20260404212443_osKpQ IT0001 2026-04-06T12:10:58.603Z 2026-04-06T12:16:14.645Z
9610686 9610686 20260404211153_40vAU IT0001 2026-04-06T12:10:42.491Z 2026-04-06T12:16:14.635Z
9610591 9610591 20260404204549_X6eGO IT0001 2026-04-06T12:10:15.414Z 2026-04-06T12:16:14.613Z
9600795 9600795 20260401025859_8OAiM IT0001 2026-04-02T12:00:19.640Z 2026-04-06T12:24:09.896Z
9600720 9600720 20260331013254_TUjhq IT0001 2026-04-01T12:11:38.976Z 2026-04-06T12:33:48.031Z
9600694 9600694 20260331011457_SFMx8 IT0001 2026-04-01T12:11:33.470Z 2026-04-06T12:33:46.348Z
9600678 9600678 20260331004814_f0d0H IT0001 2026-04-01T12:11:30.143Z 2026-04-06T12:33:45.283Z
9600629 9600629 20260331002624_j4wAT IT0001 2026-04-01T12:11:22.877Z 2026-04-06T12:33:43.214Z
9600612 9600612 20260331001640_eyQnb IT0001 2026-04-01T12:11:20.006Z 2026-04-06T12:33:42.524Z
9600601 9600601 20260331000222_tkcc2 IT0001 2026-04-01T12:11:18.304Z 2026-04-06T12:33:42.009Z
9598698 9598698 20260331030115_uFdun IT0001 2026-04-01T12:00:36.639Z 2026-04-06T12:26:47.942Z
9598646 9598646 20260331020734_u90r3 IT0001 2026-04-01T12:00:19.478Z 2026-04-06T12:26:41.633Z
9595393 9595393 20260330034845_A62OQ IT0001 2026-03-31T12:01:16.100Z 2026-04-06T12:30:00.647Z
9595209 9595209 20260330030445_XFLZl IT0001 2026-03-31T12:00:47.817Z 2026-04-06T12:29:48.246Z
9595048 9595048 20260330015952_R0yoO IT0001 2026-03-31T12:00:18.516Z 2026-04-06T12:29:37.405Z
9595039 9595039 20260330015521_1f2lI IT0001 2026-03-31T12:00:16.714Z 2026-04-06T12:29:36.624Z
9591951 9591951 20260327231751_NGZOZ IT0001 2026-03-29T12:07:01.145Z 2026-04-05T12:35:21.962Z
9580089 9580089 20260325000214_fDh2F IT0001 2026-03-26T12:15:03.799Z 2026-04-02T12:37:41.688Z
9580004 9580004 20260324234738_3NA4i IT0001 2026-03-26T12:14:52.356Z 2026-04-02T12:37:38.757Z
9579995 9579995 20260324234555_DRRaI IT0001 2026-03-26T12:14:50.656Z 2026-04-02T12:37:38.334Z
9579923 9579923 20260324232304_85zXh IT0001 2026-03-26T12:14:40.915Z 2026-04-02T12:37:34.679Z
9579705 9579705 20260324221838_uG948 IT0001 2026-03-26T12:14:14.021Z 2026-04-02T12:37:26.489Z
9577028 9577028 20260325034025_ScQvA IT0001 2026-03-26T12:03:55.920Z 2026-04-03T12:36:29.866Z
9576901 9576901 20260325032356_M2XXn IT0001 2026-03-26T12:03:36.675Z 2026-04-03T12:36:25.020Z
9576762 9576762 20260325030550_Dkwlz IT0001 2026-03-26T12:03:13.960Z 2026-04-03T12:36:20.298Z
9576730 9576730 20260325030026_T22ww IT0001 2026-03-26T12:03:08.370Z 2026-04-03T12:36:19.174Z
9576684 9576684 20260325025307_E3jG6 IT0001 2026-03-26T12:02:59.275Z 2026-04-03T12:36:17.215Z
9576621 9576621 20260325024421_cerNH IT0001 2026-03-26T12:02:49.251Z 2026-04-03T12:36:14.901Z
9576598 9576598 20260325023818_bqkmS IT0001 2026-03-26T12:02:44.934Z 2026-04-03T12:36:14.015Z
9576425 9576425 20260325020449_i688W IT0001 2026-03-26T12:02:10.827Z 2026-04-03T12:35:58.157Z
9576340 9576340 20260325015532_FgaEV IT0001 2026-03-26T12:01:58.376Z 2026-04-03T12:35:53.741Z
9576312 9576312 20260325015108_vu2Bm IT0001 2026-03-26T12:01:54.304Z 2026-04-03T12:35:52.812Z
9576063 9576063 20260325010816_eZDhR IT0001 2026-03-26T12:01:10.080Z 2026-04-03T12:35:42.919Z
9576030 9576030 20260325010127_RV0e0 IT0001 2026-03-26T12:01:01.863Z 2026-04-03T12:35:41.454Z
9576008 9576008 20260325005804_jrrZ5 IT0001 2026-03-26T12:00:57.156Z 2026-04-03T12:35:40.641Z
9575634 9575634 20260323235926_mskpm IT0001 2026-03-25T12:21:33.629Z 2026-03-31T12:29:03.658Z
9575625 9575625 20260323235614_Fn3tJ IT0001 2026-03-25T12:21:32.353Z 2026-03-31T12:29:03.472Z
9575596 9575596 20260323233546_w7kQI IT0001 2026-03-25T12:21:28.011Z 2026-03-31T12:29:02.580Z
9575584 9575584 20260323232959_xPILi IT0001 2026-03-25T12:21:27.006Z 2026-03-31T12:29:02.365Z
9571745 9571745 20260324035304_dPQA6 IT0001 2026-03-25T12:02:32.805Z 2026-04-02T12:34:42.177Z
9571711 9571711 20260324033947_3UIWl IT0001 2026-03-25T12:02:26.988Z 2026-04-02T12:34:40.561Z
9571597 9571597 20260324030812_a12NY IT0001 2026-03-25T12:02:02.487Z 2026-04-02T12:34:33.715Z
9571580 9571580 20260324030135_E78IC IT0001 2026-03-25T12:01:58.988Z 2026-04-02T12:34:32.768Z
9571482 9571482 20260324023024_qQKuV IT0001 2026-03-25T12:01:40.227Z 2026-04-02T12:34:28.762Z
9571379 9571379 20260324014226_emJQc IT0001 2026-03-25T12:01:15.336Z 2026-04-02T12:34:23.773Z
9571378 9571378 20260324014147_8lT7j IT0001 2026-03-25T12:01:14.830Z 2026-04-02T12:34:23.645Z
9571366 9571366 20260324013620_YQYlr IT0001 2026-03-25T12:01:12.650Z 2026-04-02T12:34:23.137Z
9571315 9571315 20260324010937_jI0JC IT0001 2026-03-25T12:00:58.462Z 2026-04-02T12:34:19.513Z
9571287 9571287 20260324005323_j9eQq IT0001 2026-03-25T12:00:48.555Z 2026-04-02T12:34:17.879Z
9571267 9571267 20260324004818_aTrn1 IT0001 2026-03-25T12:00:44.324Z 2026-04-02T12:34:17.202Z
9571265 9571265 20260324004809_yBQNl IT0001 2026-03-25T12:00:43.416Z 2026-04-02T12:34:17.118Z
9570557 9570557 20260322220103_BJ2tA IT0001 2026-03-24T12:23:27.493Z 2026-03-30T12:30:45.398Z
9570182 9570182 20260322193939_Chxst IT0001 2026-03-24T12:22:45.881Z 2026-03-30T12:30:29.163Z
9562903 9562903 20260323034225_WCdMi IT0001 2026-03-24T12:04:23.728Z 2026-03-31T12:26:28.908Z
9562658 9562658 20260323025820_j1QTJ IT0001 2026-03-24T12:03:42.571Z 2026-03-31T12:26:16.900Z
9562328 9562328 20260323020859_JRVgC IT0001 2026-03-24T12:02:49.978Z 2026-03-31T12:26:07.849Z
9562230 9562230 20260323015203_IXPDM IT0001 2026-03-24T12:02:32.057Z 2026-03-31T12:26:04.545Z
9562224 9562224 20260323015134_T25yh IT0001 2026-03-24T12:02:30.829Z 2026-03-31T12:26:04.292Z
9561986 9561986 20260323010903_AzZAO IT0001 2026-03-24T12:01:46.273Z 2026-03-31T12:25:58.304Z
9561890 9561890 20260323005323_ZQS3a IT0001 2026-03-24T12:01:32.106Z 2026-03-31T12:25:55.776Z
9561884 9561884 20260323005159_M7ZZB IT0001 2026-03-24T12:01:30.454Z 2026-03-31T12:25:55.545Z
9561625 9561625 20260323001045_rqv5j IT0001 2026-03-24T12:00:42.504Z 2026-03-31T12:25:48.935Z
9553328 9553328 20260322013109_GT6wm IT0001 2026-03-23T12:01:24.214Z 2026-03-30T12:27:39.420Z
9553275 9553275 20260322012923_mDkAV IT0001 2026-03-23T12:01:22.390Z 2026-03-30T12:27:38.816Z
9553240 9553240 20260322012650_94GRS IT0001 2026-03-23T12:01:20.418Z 2026-03-30T12:27:38.277Z
9553210 9553210 20260322012415_4YNru IT0001 2026-03-23T12:01:19.279Z 2026-03-30T12:27:37.859Z
9552935 9552935 20260322005726_9Pas9 IT0001 2026-03-23T12:01:01.670Z 2026-03-30T12:27:32.534Z
9551885 9551885 20260320220518_Ez44c IT0001 2026-03-22T12:27:15.575Z 2026-03-28T12:37:03.607Z
9551875 9551875 20260320220230_ar2N5 IT0001 2026-03-22T12:27:14.911Z 2026-03-28T12:37:03.528Z
9551867 9551867 20260320215931_xnKpq IT0001 2026-03-22T12:27:08.105Z 2026-03-28T12:37:03.308Z
9551665 9551665 20260320204750_WTETn IT0001 2026-03-22T12:26:54.764Z 2026-03-28T12:36:59.606Z
9543144 9543144 20260321024640_fI0jk IT0001 2026-03-22T12:02:48.032Z 2026-03-29T12:19:03.542Z
9541741 9541741 20260319213532_TLAe2 IT0001 2026-03-21T12:29:19.263Z 2026-03-27T12:42:41.190Z
9541704 9541704 20260319213104_mEejP IT0001 2026-03-21T12:29:17.411Z 2026-03-27T12:42:40.966Z
9541651 9541651 20260319211729_pCB7y IT0001 2026-03-21T12:29:14.564Z 2026-03-27T12:42:40.497Z
9541617 9541617 20260319211101_byYDe IT0001 2026-03-21T12:29:13.388Z 2026-03-27T12:42:40.339Z
9541567 9541567 20260319210509_iS1v9 IT0001 2026-03-21T12:29:11.106Z 2026-03-27T12:42:38.862Z
9541360 9541360 20260319202106_3YPIG IT0001 2026-03-21T12:28:51.477Z 2026-03-27T12:42:36.864Z
9541356 9541356 20260319202106_4thfr IT0001 2026-03-21T12:28:51.321Z 2026-03-27T12:42:36.849Z
9541347 9541347 20260319201947_J9Mem IT0001 2026-03-21T12:28:50.933Z 2026-03-27T12:42:36.728Z
9534180 9534180 20260320033358_mx3Pz IT0001 2026-03-21T12:07:22.319Z 2026-03-28T12:34:15.515Z
9533982 9533982 20260320031355_LSmJd IT0001 2026-03-21T12:06:49.555Z 2026-03-28T12:34:03.136Z
9533896 9533896 20260320030731_47thr IT0001 2026-03-21T12:06:33.925Z 2026-03-28T12:34:01.966Z
9533763 9533763 20260320025601_RMyTL IT0001 2026-03-21T12:06:13.104Z 2026-03-28T12:34:00.231Z
9533744 9533744 20260320025405_8Q7tw IT0001 2026-03-21T12:06:09.334Z 2026-03-28T12:33:59.991Z
9533342 9533342 20260320022437_flYcR IT0001 2026-03-21T12:05:11.936Z 2026-03-28T12:33:52.131Z
9533338 9533338 20260320022431_RM2Yu IT0001 2026-03-21T12:05:11.378Z 2026-03-28T12:33:52.110Z
9532874 9532874 20260320013521_3iKuE IT0001 2026-03-21T12:03:51.820Z 2026-03-28T12:33:45.701Z
9532621 9532621 20260320011417_WFQKs IT0001 2026-03-21T12:03:13.676Z 2026-03-28T12:33:34.698Z
9532607 9532607 20260320011157_qlbcy IT0001 2026-03-21T12:03:09.957Z 2026-03-28T12:33:34.526Z
9532575 9532575 20260320010750_bKHxB IT0001 2026-03-21T12:03:05.869Z 2026-03-28T12:33:34.151Z
9532429 9532429 20260320005629_bzjso IT0001 2026-03-21T12:02:41.267Z 2026-03-28T12:33:31.106Z
9532399 9532399 20260320005133_WqPOb IT0001 2026-03-21T12:02:35.889Z 2026-03-28T12:33:29.648Z
9532166 9532166 20260320002550_ZSBFe IT0001 2026-03-21T12:01:53.055Z 2026-03-28T12:33:25.122Z
9532107 9532107 20260320001856_w1vA1 IT0001 2026-03-21T12:01:43.826Z 2026-03-28T12:33:24.651Z
9531963 9531963 20260320000557_L8w66 IT0001 2026-03-21T12:01:17.628Z 2026-03-28T12:33:23.203Z

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