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

9,847 rows where station_code = "GR0009" 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
9611636 9611636 20260405025359_zyOp6 GR0009 2026-04-06T12:15:26.807Z 2026-04-06T12:16:14.838Z
9608598 9608598 20260403235203_o5AJt GR0009 2026-04-05T12:10:53.198Z 2026-04-06T12:20:24.498Z
9608389 9608389 20260403224956_UZ1ls GR0009 2026-04-05T12:10:19.262Z 2026-04-06T12:20:09.993Z
9598577 9598577 20260330012056_6dWoi GR0009 2026-03-31T12:10:57.894Z 2026-04-06T12:36:46.950Z
9598487 9598487 20260330003839_eIMJl GR0009 2026-03-31T12:10:42.897Z 2026-04-06T12:36:34.706Z
9598331 9598331 20260329224541_4DF29 GR0009 2026-03-31T12:10:19.705Z 2026-04-06T12:36:25.305Z
9598306 9598306 20260329221905_8GSCk GR0009 2026-03-31T12:10:14.952Z 2026-04-06T12:36:23.657Z
9598288 9598288 20260329220247_pp5be GR0009 2026-03-31T12:10:12.016Z 2026-04-06T12:36:22.548Z
9598259 9598259 20260329214728_kpAY6 GR0009 2026-03-31T12:10:07.955Z 2026-04-06T12:36:20.958Z
9598243 9598243 20260329212537_cexqN GR0009 2026-03-31T12:10:04.561Z 2026-04-06T12:36:19.693Z
9598228 9598228 20260329205047_XVlkt GR0009 2026-03-31T12:10:01.859Z 2026-04-06T12:36:18.473Z
9598218 9598218 20260329203602_2LWgK GR0009 2026-03-31T12:10:00.145Z 2026-04-06T12:36:17.518Z
9598199 9598199 20260329195549_tikvH GR0009 2026-03-31T12:09:56.397Z 2026-04-06T12:36:15.659Z
9598195 9598195 20260329193102_Z4TGL GR0009 2026-03-31T12:09:53.830Z 2026-04-06T12:36:14.771Z
9598184 9598184 20260329182448_2gQc2 GR0009 2026-03-31T12:09:47.131Z 2026-04-06T12:36:11.295Z
9595294 9595294 20260330031613_kvwAf GR0009 2026-03-31T12:00:59.896Z 2026-04-06T12:29:51.752Z
9595060 9595060 20260330020958_96k5F GR0009 2026-03-31T12:00:21.091Z 2026-04-06T12:29:38.297Z
9595044 9595044 20260330015557_8sufn GR0009 2026-03-31T12:00:17.672Z 2026-04-06T12:29:36.978Z
9595025 9595025 20260330014127_wGel5 GR0009 2026-03-31T12:00:13.760Z 2026-04-06T12:29:35.673Z
9589033 9589033 20260328021459_0Yn3R GR0009 2026-03-29T12:00:38.956Z 2026-04-06T12:36:59.819Z
9588895 9588895 20260328015330_xbhRs GR0009 2026-03-29T12:00:27.730Z 2026-04-06T12:36:55.999Z
9588249 9588249 20260326194850_RNKHo GR0009 2026-03-28T12:10:36.897Z 2026-04-04T12:41:51.051Z
9585370 9585370 20260326002622_kVutc GR0009 2026-03-27T12:17:12.503Z 2026-04-03T12:39:58.160Z
9585349 9585349 20260326002324_oxJgI GR0009 2026-03-27T12:17:10.338Z 2026-04-03T12:39:57.798Z
9585341 9585341 20260326002138_enCrd GR0009 2026-03-27T12:17:09.401Z 2026-04-03T12:39:57.283Z
9585250 9585250 20260325235712_M0UmH GR0009 2026-03-27T12:16:59.681Z 2026-04-03T12:39:52.777Z
9585105 9585105 20260325232949_l8Aij GR0009 2026-03-27T12:16:44.851Z 2026-04-03T12:39:49.610Z
9585093 9585093 20260325232453_JGCFM GR0009 2026-03-27T12:16:42.989Z 2026-04-03T12:39:49.253Z
9585045 9585045 20260325231238_cwE8d GR0009 2026-03-27T12:16:35.924Z 2026-04-03T12:39:47.673Z
9581066 9581066 20260326021919_eI37R GR0009 2026-03-27T12:02:03.172Z 2026-04-04T12:38:41.358Z
9580942 9580942 20260326015534_a7Flj GR0009 2026-03-27T12:01:44.311Z 2026-04-04T12:38:35.296Z
9580814 9580814 20260326013841_Z9VlU GR0009 2026-03-27T12:01:29.526Z 2026-04-04T12:38:30.425Z
9580782 9580782 20260326013111_lBK8C GR0009 2026-03-27T12:01:23.386Z 2026-04-04T12:38:29.006Z
9580560 9580560 20260326010220_P1mSh GR0009 2026-03-27T12:00:47.668Z 2026-04-04T12:38:14.045Z
9580544 9580544 20260326005833_izM38 GR0009 2026-03-27T12:00:43.969Z 2026-04-04T12:38:13.347Z
9580541 9580541 20260326005758_KotUe GR0009 2026-03-27T12:00:43.213Z 2026-04-04T12:38:13.200Z
9580405 9580405 20260326004446_y3K90 GR0009 2026-03-27T12:00:22.864Z 2026-04-04T12:38:08.634Z
9579870 9579870 20260324231153_4czDt GR0009 2026-03-26T12:14:36.955Z 2026-04-02T12:37:33.384Z
9576661 9576661 20260325024859_zQxTt GR0009 2026-03-26T12:02:56.809Z 2026-04-03T12:36:16.505Z
9576638 9576638 20260325024600_DnfGE GR0009 2026-03-26T12:02:51.690Z 2026-04-03T12:36:15.488Z
9575641 9575641 20260324000204_AZ1fV GR0009 2026-03-25T12:21:34.491Z 2026-03-31T12:29:03.880Z
9575639 9575639 20260324000017_s0pR8 GR0009 2026-03-25T12:21:34.186Z 2026-03-31T12:29:03.784Z
9571574 9571574 20260324025920_L5Nog GR0009 2026-03-25T12:01:57.970Z 2026-04-02T12:34:32.496Z
9571305 9571305 20260324010154_QYYQI GR0009 2026-03-25T12:00:54.899Z 2026-04-02T12:34:18.969Z
9571294 9571294 20260324005746_NWr0i GR0009 2026-03-25T12:00:50.948Z 2026-04-02T12:34:18.309Z
9571217 9571217 20260324003422_NfC0w GR0009 2026-03-25T12:00:29.803Z 2026-04-02T12:34:13.677Z
9571184 9571184 20260324001726_WU6nW GR0009 2026-03-25T12:00:20.796Z 2026-04-02T12:34:11.628Z
9501403 9501403 20260315221027_GwV45 GR0009 2026-03-17T12:24:57.161Z 2026-03-23T12:22:44.304Z
9501355 9501355 20260315220324_e46kZ GR0009 2026-03-17T12:24:52.727Z 2026-03-23T12:22:44.065Z
9501342 9501342 20260315220118_y1K2s GR0009 2026-03-17T12:24:51.097Z 2026-03-23T12:22:44.003Z
9501224 9501224 20260315213529_BS7Kw GR0009 2026-03-17T12:24:43.243Z 2026-03-23T12:22:43.657Z
9501143 9501143 20260315211514_CJU3G GR0009 2026-03-17T12:24:31.840Z 2026-03-23T12:22:43.347Z
9501030 9501030 20260315204031_9Ls2f GR0009 2026-03-17T12:24:19.050Z 2026-03-23T12:22:42.785Z
9500620 9500620 20260315174127_nQ82T GR0009 2026-03-17T12:23:22.863Z 2026-03-23T12:22:40.155Z
9494916 9494916 20260316032845_Yf3uy GR0009 2026-03-17T12:05:28.305Z 2026-03-24T12:40:51.183Z
9493822 9493822 20260316004337_JVhqj GR0009 2026-03-17T12:02:10.123Z 2026-03-24T12:40:42.260Z
9493736 9493736 20260316002901_MMZGj GR0009 2026-03-17T12:01:54.284Z 2026-03-24T12:40:41.676Z
9493728 9493728 20260316002644_4aiQy GR0009 2026-03-17T12:01:51.830Z 2026-03-24T12:40:41.607Z
9493573 9493573 20260315235234_D9ax4 GR0009 2026-03-17T12:01:22.113Z 2026-03-24T12:40:40.719Z
9493520 9493520 20260315234031_jcvLq GR0009 2026-03-17T12:01:07.773Z 2026-03-24T12:40:40.365Z
9493465 9493465 20260315233335_y5vjQ GR0009 2026-03-17T12:01:00.137Z 2026-03-24T12:40:39.978Z
9493452 9493452 20260315233204_9U1Lv GR0009 2026-03-17T12:00:56.473Z 2026-03-24T12:40:39.851Z
9493395 9493395 20260315232145_1umD7 GR0009 2026-03-17T12:00:41.209Z 2026-03-24T12:40:39.351Z
9493376 9493376 20260315231751_M8blh GR0009 2026-03-17T12:00:37.613Z 2026-03-24T12:40:39.138Z
9493361 9493361 20260315231432_epHPO GR0009 2026-03-17T12:00:33.700Z 2026-03-24T12:40:38.933Z
9493346 9493346 20260315231232_FTnv4 GR0009 2026-03-17T12:00:29.954Z 2026-03-24T12:40:38.759Z
9493024 9493024 20260314223333_fkede GR0009 2026-03-16T12:29:17.653Z 2026-03-22T12:42:56.465Z
9493022 9493022 20260314223220_yl2Gc GR0009 2026-03-16T12:29:17.441Z 2026-03-22T12:42:56.444Z
9493016 9493016 20260314223052_u85jC GR0009 2026-03-16T12:29:16.615Z 2026-03-22T12:42:56.356Z
9492899 9492899 20260314221136_OPwiA GR0009 2026-03-16T12:29:09.104Z 2026-03-22T12:42:55.635Z
9492854 9492854 20260314220256_031F5 GR0009 2026-03-16T12:29:06.183Z 2026-03-22T12:42:55.423Z
9492563 9492563 20260314211929_0d3RR GR0009 2026-03-16T12:28:44.158Z 2026-03-22T12:42:53.159Z
9492407 9492407 20260314204404_Igcpt GR0009 2026-03-16T12:28:32.383Z 2026-03-22T12:42:52.222Z
9492309 9492309 20260314201737_tXwSI GR0009 2026-03-16T12:28:17.370Z 2026-03-22T12:42:51.600Z
9492096 9492096 20260314192105_IYnTI GR0009 2026-03-16T12:28:02.047Z 2026-03-22T12:42:50.216Z
9492059 9492059 20260314190307_sdy3i GR0009 2026-03-16T12:27:58.522Z 2026-03-22T12:42:49.831Z
9492026 9492026 20260314182609_MG82L GR0009 2026-03-16T12:27:52.667Z 2026-03-22T12:42:49.179Z
9492006 9492006 20260314175955_6ptqW GR0009 2026-03-16T12:27:44.907Z 2026-03-22T12:42:48.838Z
9485524 9485524 20260315031734_p8r1y GR0009 2026-03-16T12:06:45.119Z 2026-03-23T12:21:52.675Z
9485507 9485507 20260315031537_TeGQ3 GR0009 2026-03-16T12:06:41.849Z 2026-03-23T12:21:52.540Z
9485493 9485493 20260315031340_zQemM GR0009 2026-03-16T12:06:37.539Z 2026-03-23T12:21:52.458Z
9485449 9485449 20260315030613_9l38w GR0009 2026-03-16T12:06:28.140Z 2026-03-23T12:21:52.277Z
9485421 9485421 20260315030237_ItfgM GR0009 2026-03-16T12:06:24.099Z 2026-03-23T12:21:52.232Z
9485332 9485332 20260315025233_4S69A GR0009 2026-03-16T12:06:04.562Z 2026-03-23T12:21:51.056Z
9485293 9485293 20260315024740_Fr3S2 GR0009 2026-03-16T12:05:57.529Z 2026-03-23T12:21:50.864Z
9485153 9485153 20260315023431_IzT5B GR0009 2026-03-16T12:05:27.234Z 2026-03-23T12:21:50.178Z
9485126 9485126 20260315023253_WInH2 GR0009 2026-03-16T12:05:23.021Z 2026-03-23T12:21:50.130Z
9484895 9484895 20260315015415_au55C GR0009 2026-03-16T12:04:32.308Z 2026-03-23T12:21:48.856Z
9484857 9484857 20260315015015_jLbqb GR0009 2026-03-16T12:04:23.863Z 2026-03-23T12:21:48.713Z
9484727 9484727 20260315013351_2vuxx GR0009 2026-03-16T12:03:55.982Z 2026-03-23T12:21:48.130Z
9484710 9484710 20260315013149_WcgBP GR0009 2026-03-16T12:03:51.644Z 2026-03-23T12:21:48.074Z
9484676 9484676 20260315012711_24rKT GR0009 2026-03-16T12:03:44.236Z 2026-03-23T12:21:47.874Z
9484434 9484434 20260315003914_OAtIS GR0009 2026-03-16T12:02:52.928Z 2026-03-23T12:21:46.769Z
9484354 9484354 20260315002602_JzY3Y GR0009 2026-03-16T12:02:31.799Z 2026-03-23T12:21:46.445Z
9484250 9484250 20260315001027_NfGYF GR0009 2026-03-16T12:02:10.128Z 2026-03-23T12:21:46.045Z
9484238 9484238 20260315000733_Hz5EB GR0009 2026-03-16T12:02:04.944Z 2026-03-23T12:21:45.993Z
9484217 9484217 20260315000500_PYtQr GR0009 2026-03-16T12:01:59.810Z 2026-03-23T12:21:45.898Z
9484215 9484215 20260315000459_bgQ2F GR0009 2026-03-16T12:01:59.286Z 2026-03-23T12:21:45.866Z
9484152 9484152 20260314235628_3pKw4 GR0009 2026-03-16T12:01:43.014Z 2026-03-23T12:21:45.594Z
9483955 9483955 20260314233129_9I3LB GR0009 2026-03-16T12:01:03.769Z 2026-03-23T12:21:44.554Z

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