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

2,171 rows where station_code = "BG0009" 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
9272843 9272843 20260128034421_Ut4VR BG0009 2026-01-29T14:28:01.550Z 2026-01-29T14:30:25.580Z
9272445 9272445 20260128020829_w2suB BG0009 2026-01-29T14:26:40.139Z 2026-01-29T14:30:25.347Z
9272054 9272054 20260127233125_AjzaZ BG0009 2026-01-29T14:25:25.571Z 2026-01-29T14:30:25.271Z
9272024 9272024 20260127230352_hNN2R BG0009 2026-01-29T14:25:20.006Z 2026-01-29T14:30:25.266Z
9271943 9271943 20260127221503_iByUO BG0009 2026-01-29T14:25:01.000Z 2026-01-29T14:30:25.233Z
9194421 9194421 20260112203813_r0l0B BG0009 2026-01-14T14:09:09.192Z 2026-01-21T15:03:59.543Z
9194402 9194402 20260112203424_9Rz4i BG0009 2026-01-14T14:09:04.227Z 2026-01-21T15:03:55.024Z
9194083 9194083 20260112174152_g5PsS BG0009 2026-01-14T14:07:10.484Z 2026-01-21T15:03:28.384Z
9130896 9130896 20260103042752_BZBPq BG0009 2026-01-04T14:11:58.711Z 2026-01-10T14:59:49.513Z
9130829 9130829 20260103042149_l939q BG0009 2026-01-04T14:11:46.294Z 2026-01-10T14:59:44.630Z
9130266 9130266 20260103024408_MvuYt BG0009 2026-01-04T14:09:12.874Z 2026-01-10T14:58:58.882Z
9130226 9130226 20260103023303_it4vt BG0009 2026-01-04T14:08:59.305Z 2026-01-10T14:58:53.418Z
9130139 9130139 20260103021441_VYw9i BG0009 2026-01-04T14:08:35.819Z 2026-01-10T14:58:45.699Z
9129916 9129916 20260103012813_JgIj9 BG0009 2026-01-04T14:07:10.332Z 2026-01-10T14:58:25.195Z
9099026 9099026 20251227204733_JIwvn BG0009 2025-12-30T15:11:22.904Z 2026-01-04T15:35:37.402Z
9098937 9098937 20251227203142_SBtyH BG0009 2025-12-30T15:11:17.249Z 2026-01-04T15:35:33.215Z
9098429 9098429 20251227190716_kSOwB BG0009 2025-12-30T15:10:29.492Z 2026-01-04T15:35:01.344Z
9091388 9091388 20251228184604_ll152 BG0009 2025-12-30T14:52:24.163Z 2026-01-05T15:14:11.005Z
9091363 9091363 20251228184402_3LqpG BG0009 2025-12-30T14:52:22.778Z 2026-01-05T15:14:10.495Z
9091313 9091313 20251228183630_uAgJm BG0009 2025-12-30T14:52:17.233Z 2026-01-05T15:14:09.036Z
9085661 9085661 20251228034941_YPK2l BG0009 2025-12-30T14:39:08.603Z 2026-01-05T15:09:41.087Z
9085259 9085259 20251228030922_IjAj3 BG0009 2025-12-30T14:38:04.102Z 2026-01-05T15:09:17.469Z
9084969 9084969 20251228023849_STGi1 BG0009 2025-12-30T14:37:18.931Z 2026-01-05T15:09:09.275Z
9084939 9084939 20251228023543_K3BNH BG0009 2025-12-30T14:37:15.348Z 2026-01-05T15:09:08.526Z
9084843 9084843 20251228022615_ZqJ5Y BG0009 2025-12-30T14:36:55.652Z 2026-01-05T15:09:05.834Z
9084839 9084839 20251228022550_Clbb7 BG0009 2025-12-30T14:36:55.313Z 2026-01-05T15:09:05.696Z
9084795 9084795 20251228021907_Vx2ip BG0009 2025-12-30T14:36:48.916Z 2026-01-05T15:09:03.892Z
9084739 9084739 20251228021411_IE3AW BG0009 2025-12-30T14:36:40.648Z 2026-01-05T15:08:54.063Z
9084494 9084494 20251228014953_E4aVG BG0009 2025-12-30T14:35:51.101Z 2026-01-05T15:08:45.043Z
9084488 9084488 20251228014855_gzQ0i BG0009 2025-12-30T14:35:50.596Z 2026-01-05T15:08:44.910Z
9084391 9084391 20251228013755_lTNJV BG0009 2025-12-30T14:35:35.672Z 2026-01-05T15:08:41.110Z
9084213 9084213 20251228012055_1Sw8C BG0009 2025-12-30T14:35:02.761Z 2026-01-05T15:08:35.746Z
9083393 9083393 20251227235022_wW4Hd BG0009 2025-12-30T14:32:30.757Z 2026-01-05T15:07:46.990Z
9083361 9083361 20251227234513_fX6Fe BG0009 2025-12-30T14:32:26.260Z 2026-01-05T15:07:45.900Z
9083304 9083304 20251227233424_GoJXT BG0009 2025-12-30T14:32:18.840Z 2026-01-05T15:07:44.115Z
9083290 9083290 20251227233214_ukmgi BG0009 2025-12-30T14:32:16.708Z 2026-01-05T15:07:43.606Z
9083033 9083033 20251227224256_F29F2 BG0009 2025-12-30T14:31:23.681Z 2026-01-05T15:07:35.175Z
9082970 9082970 20251227222050_ww6KY BG0009 2025-12-30T14:31:15.014Z 2026-01-05T15:07:33.137Z
9082905 9082905 20251227220432_SpHWL BG0009 2025-12-30T14:30:59.227Z 2025-12-30T14:53:53.880Z
9082873 9082873 20251227215925_d43q7 BG0009 2025-12-30T14:30:52.918Z 2026-01-05T15:07:29.862Z
9080511 9080511 20251229044704_QqaCX BG0009 2025-12-30T14:21:31.910Z 2026-01-06T15:18:19.048Z
9080352 9080352 20251229043235_O9REN BG0009 2025-12-30T14:20:50.865Z 2026-01-06T15:18:13.836Z
9079370 9079370 20251229031340_Q1qX2 BG0009 2025-12-30T14:16:50.114Z 2026-01-06T15:17:11.006Z
9078373 9078373 20251229015343_Ga0uT BG0009 2025-12-30T14:12:43.077Z 2026-01-06T15:16:14.952Z
8995416 8995416 20251218002543_BHUoK BG0009 2025-12-26T15:05:48.808Z 2025-12-26T15:05:48.808Z
8995377 8995377 20251218001621_h1rTa BG0009 2025-12-26T15:05:46.659Z 2025-12-26T15:05:46.659Z
8995343 8995343 20251218000732_TZ16z BG0009 2025-12-26T15:05:43.974Z 2025-12-26T15:05:43.974Z
8995141 8995141 20251217231248_iyAoG BG0009 2025-12-26T15:05:08.930Z 2025-12-26T15:05:08.930Z
8995074 8995074 20251217224440_RF0bt BG0009 2025-12-26T15:05:04.606Z 2025-12-26T15:05:04.606Z
8994922 8994922 20251217215919_4Q3In BG0009 2025-12-26T15:04:54.885Z 2025-12-26T15:04:54.885Z
8972602 8972602 20251217013202_v3Wkz BG0009 2025-12-25T14:55:06.550Z 2025-12-25T14:55:06.550Z
8972422 8972422 20251217011851_CbMgr BG0009 2025-12-25T14:54:53.903Z 2025-12-25T14:54:53.903Z
8972070 8972070 20251217005334_pwB55 BG0009 2025-12-25T14:54:42.836Z 2025-12-25T14:54:42.836Z
8972063 8972063 20251217005259_hKITP BG0009 2025-12-25T14:54:42.520Z 2025-12-25T14:54:42.520Z
8971731 8971731 20251217003023_t42F5 BG0009 2025-12-25T14:54:12.919Z 2025-12-25T14:54:12.919Z
8969759 8969759 20251216203725_HZVc4 BG0009 2025-12-25T14:51:41.184Z 2025-12-25T14:51:41.184Z
8969229 8969229 20251216190237_p2m1a BG0009 2025-12-25T14:50:47.162Z 2025-12-25T14:50:47.162Z
8969053 8969053 20251216182100_RArxO BG0009 2025-12-25T14:50:17.978Z 2025-12-25T14:50:17.978Z
8968919 8968919 20251216174729_s67BP BG0009 2025-12-25T14:50:07.871Z 2025-12-25T14:50:07.871Z
8968754 8968754 20251216170008_a48E0 BG0009 2025-12-25T14:49:45.347Z 2025-12-25T14:49:45.347Z
8963037 8963037 20251216042736_35FX9 BG0009 2025-12-25T14:37:46.847Z 2025-12-25T14:37:46.847Z
8962919 8962919 20251216041117_63EXl BG0009 2025-12-25T14:37:32.481Z 2025-12-25T14:37:32.481Z
8962774 8962774 20251216035124_hVS9T BG0009 2025-12-25T14:36:58.153Z 2025-12-25T14:36:58.153Z
8962735 8962735 20251216034650_IxCt6 BG0009 2025-12-25T14:36:51.903Z 2025-12-25T14:36:51.903Z
8962716 8962716 20251216034500_OpHUi BG0009 2025-12-25T14:36:46.687Z 2025-12-25T14:36:46.687Z
8962611 8962611 20251216033557_2mYwX BG0009 2025-12-25T14:36:23.167Z 2025-12-25T14:36:23.167Z
8962529 8962529 20251216032902_N6h8j BG0009 2025-12-25T14:36:12.496Z 2025-12-25T14:36:12.496Z
8962297 8962297 20251216030744_slKLE BG0009 2025-12-25T14:35:26.836Z 2025-12-25T14:35:26.836Z
8961766 8961766 20251216021347_Froh0 BG0009 2025-12-25T14:33:40.154Z 2025-12-25T14:33:40.154Z
8961533 8961533 20251217211816_f3uUT BG0009 2025-12-25T14:33:00.611Z 2025-12-26T15:04:35.862Z
8960962 8960962 20251217195054_XM7Du BG0009 2025-12-25T14:31:24.438Z 2025-12-26T15:04:07.599Z
8960634 8960634 20251217190518_90g0j BG0009 2025-12-25T14:30:23.268Z 2025-12-26T15:03:54.344Z
8960367 8960367 20251217180813_kJA32 BG0009 2025-12-25T14:29:37.239Z 2025-12-26T15:03:33.339Z
8960067 8960067 20251217172240_qJyzY BG0009 2025-12-25T14:28:37.401Z 2025-12-26T15:03:22.448Z
8959747 8959747 20251217163457_bTdd6 BG0009 2025-12-25T14:27:43.148Z 2025-12-26T15:03:01.436Z
8959661 8959661 20251217162015_24mLZ BG0009 2025-12-25T14:27:26.769Z 2025-12-26T15:02:57.838Z
8959635 8959635 20251217161736_bxKvw BG0009 2025-12-25T14:27:12.865Z 2025-12-26T15:02:56.694Z
8953627 8953627 20251217042739_PtgZu BG0009 2025-12-25T14:07:07.617Z 2025-12-26T14:57:13.371Z
8953612 8953612 20251217042452_4l1Uf BG0009 2025-12-25T14:07:03.934Z 2025-12-26T14:57:11.850Z
8953565 8953565 20251217041457_6ndCl BG0009 2025-12-25T14:06:44.954Z 2025-12-26T14:57:04.395Z
8953544 8953544 20251217041210_PFYVw BG0009 2025-12-25T14:06:37.887Z 2025-12-26T14:57:02.568Z
8953501 8953501 20251217040510_3xqz0 BG0009 2025-12-25T14:06:29.177Z 2025-12-26T14:56:58.665Z
8953462 8953462 20251217035736_sXebe BG0009 2025-12-25T14:06:14.700Z 2025-12-26T14:56:54.527Z
8953252 8953252 20251217032438_GuTtY BG0009 2025-12-25T14:05:05.815Z 2025-12-26T14:56:24.699Z
8953126 8953126 20251217030729_V0czH BG0009 2025-12-25T14:04:27.933Z 2025-12-26T14:56:05.257Z
8953074 8953074 20251217030035_y3qAJ BG0009 2025-12-25T14:04:05.361Z 2025-12-26T14:55:58.715Z
8953047 8953047 20251217025638_pt4l4 BG0009 2025-12-25T14:03:54.168Z 2025-12-26T14:55:56.411Z
8952914 8952914 20251217024245_a3xA1 BG0009 2025-12-25T14:03:19.294Z 2025-12-26T14:55:32.648Z
8952784 8952784 20251217022211_gCM3i BG0009 2025-12-25T14:02:28.109Z 2025-12-25T14:55:16.888Z
8952593 8952593 20251217015849_Pqu2B BG0009 2025-12-25T14:01:25.306Z 2025-12-26T14:54:59.757Z
8952564 8952564 20251217015651_1ZY2x BG0009 2025-12-25T14:01:16.748Z 2025-12-26T14:54:57.347Z
8826183 8826183 20251213031722_dZuO5 BG0009 2025-12-17T15:00:59.178Z 2025-12-21T14:17:38.391Z
8825821 8825821 20251213023846_2bEGb BG0009 2025-12-17T14:59:41.956Z 2025-12-21T14:17:37.090Z
8794039 8794039 20251213041920_iNpnu BG0009 2025-12-16T14:06:40.153Z 2025-12-23T14:16:59.422Z
8790987 8790987 20251213033738_JEnPW BG0009 2025-12-16T14:02:54.708Z 2025-12-23T14:16:22.454Z
8790926 8790926 20251213033658_PTtME BG0009 2025-12-16T14:02:50.248Z 2025-12-23T14:16:22.358Z
8789914 8789914 20251213031537_snhY4 BG0009 2025-12-15T14:40:10.662Z 2025-12-21T14:17:38.357Z
8789042 8789042 20251213030545_P5SLW BG0009 2025-12-15T14:39:31.083Z 2025-12-21T14:17:38.043Z
8787125 8787125 20251213024008_ZWyzW BG0009 2025-12-15T14:37:52.380Z 2025-12-21T14:17:37.182Z
8786909 8786909 20251213023757_wU80F BG0009 2025-12-15T14:37:46.252Z 2025-12-21T14:17:37.024Z

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