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

3,748 rows where station_code = "BG000K" 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
7897058 7897058 20250915024339_svnpX BG000K 2025-09-21T13:00:36.433Z 2025-09-22T13:02:29.692Z
7897056 7897056 20250915021500_FsTwr BG000K 2025-09-21T13:00:31.927Z 2025-09-22T13:02:24.244Z
7897054 7897054 20250915014925_vpmVm BG000K 2025-09-21T13:00:28.028Z 2025-09-22T13:02:19.421Z
7897052 7897052 20250915014816_aHQ6U BG000K 2025-09-21T13:00:27.725Z 2025-09-22T13:02:19.080Z
7897050 7897050 20250915014110_y0bN2 BG000K 2025-09-21T13:00:25.518Z 2025-09-22T13:02:17.604Z
7897048 7897048 20250915013332_VN00z BG000K 2025-09-21T13:00:23.520Z 2025-09-22T13:02:13.922Z
7897046 7897046 20250915012533_YUKrT BG000K 2025-09-21T13:00:20.992Z 2025-09-22T13:02:12.530Z
7897042 7897042 20250915011018_jpLkl BG000K 2025-09-21T13:00:17.805Z 2025-09-22T13:02:09.644Z
7843473 7843473 20250913213124_qHmDF BG000K 2025-09-16T12:39:54.686Z 2025-09-21T13:10:12.455Z
7843424 7843424 20250913205431_SRy0Z BG000K 2025-09-16T12:39:50.686Z 2025-09-21T13:10:03.575Z
7843365 7843365 20250913200558_XpPOX BG000K 2025-09-16T12:39:46.886Z 2025-09-21T13:09:56.878Z
7843327 7843327 20250913193159_pGvuD BG000K 2025-09-16T12:39:36.273Z 2025-09-21T13:09:53.637Z
7835750 7835750 20250914023913_3ch2k BG000K 2025-09-16T12:21:48.431Z 2025-09-22T13:07:11.141Z
7835710 7835710 20250914021753_nhleE BG000K 2025-09-16T12:21:27.804Z 2025-09-22T13:07:08.381Z
7835700 7835700 20250914020906_l6Fws BG000K 2025-09-16T12:21:22.150Z 2025-09-22T13:07:07.300Z
7835679 7835679 20250914020233_tS0vS BG000K 2025-09-16T12:21:18.007Z 2025-09-22T13:07:04.953Z
7835617 7835617 20250914013701_ygnVc BG000K 2025-09-16T12:20:51.849Z 2025-09-22T13:06:55.366Z
7835599 7835599 20250914013143_2b7bI BG000K 2025-09-16T12:20:48.224Z 2025-09-22T13:06:54.584Z
7835388 7835388 20250913233551_EmASp BG000K 2025-09-16T12:19:20.724Z 2025-09-22T13:06:27.507Z
7835376 7835376 20250913233234_4b2nF BG000K 2025-09-16T12:19:17.495Z 2025-09-22T13:06:24.975Z
7832175 7832175 20250915030001_3ju2A BG000K 2025-09-16T12:08:28.704Z 2025-09-22T13:02:35.386Z
7831903 7831903 20250915023013_8MV1E BG000K 2025-09-16T12:07:28.282Z 2025-09-22T13:02:26.146Z
7831736 7831736 20250915020500_8s5IW BG000K 2025-09-16T12:06:41.403Z 2025-09-22T13:02:23.376Z
7831540 7831540 20250915013600_RM4G0 BG000K 2025-09-16T12:05:55.981Z 2025-09-22T13:02:14.294Z
7831006 7831006 20250915003121_zYuEQ BG000K 2025-09-16T12:03:40.768Z 2025-09-22T13:02:03.049Z
7830658 7830658 20250914233941_62yPP BG000K 2025-09-16T12:02:13.227Z 2025-09-20T12:51:50.463Z
7830651 7830651 20250914233920_TP6JJ BG000K 2025-09-16T12:02:11.279Z 2025-09-22T13:01:55.219Z
7830649 7830649 20250914233916_863kT BG000K 2025-09-16T12:02:10.408Z 2025-09-22T13:01:55.056Z
7830607 7830607 20250914233221_34vQF BG000K 2025-09-16T12:01:58.893Z 2025-09-22T13:01:54.111Z
7830553 7830553 20250914232456_M4Trn BG000K 2025-09-16T12:01:41.507Z 2025-09-22T13:01:53.372Z
7830257 7830257 20250914224808_ejo3e BG000K 2025-09-16T12:00:35.587Z 2025-09-22T13:01:46.670Z
7824359 7824359 20250912210713_TYKWo BG000K 2025-09-14T12:29:57.945Z 2025-09-20T13:03:11.255Z
7824170 7824170 20250912203127_9Z9c9 BG000K 2025-09-14T12:29:45.160Z 2025-09-20T13:03:08.989Z
7823732 7823732 20250912190217_OwZnO BG000K 2025-09-14T12:28:46.586Z 2025-09-20T13:02:58.793Z
7823650 7823650 20250912181314_6hjH3 BG000K 2025-09-14T12:28:16.852Z 2025-09-20T13:02:57.420Z
7823639 7823639 20250912174954_28r6q BG000K 2025-09-14T12:28:13.633Z 2025-09-20T13:02:56.837Z
7820237 7820237 20250913022918_3wmK1 BG000K 2025-09-14T12:08:00.350Z 2025-09-21T13:08:33.395Z
7820189 7820189 20250913022225_W6PWU BG000K 2025-09-14T12:07:43.857Z 2025-09-21T13:08:31.689Z
7820077 7820077 20250913020356_z98Qa BG000K 2025-09-14T12:07:21.502Z 2025-09-21T13:08:28.192Z
7820028 7820028 20250913015346_iv1C2 BG000K 2025-09-14T12:07:00.737Z 2025-09-21T13:08:27.245Z
7819069 7819069 20250912223840_isONX BG000K 2025-09-14T12:02:32.533Z 2025-09-21T13:08:08.314Z
7818985 7818985 20250912222302_V82Bf BG000K 2025-09-14T12:01:59.472Z 2025-09-21T13:08:07.021Z
7818705 7818705 20250912213428_4w6gM BG000K 2025-09-14T12:00:34.288Z 2025-09-21T13:08:02.090Z
7800166 7800166 20250910021707_i3ygW BG000K 2025-09-11T12:07:35.777Z 2025-09-18T12:59:31.089Z
7800083 7800083 20250910015424_ei248 BG000K 2025-09-11T12:07:07.800Z 2025-09-18T12:59:28.064Z
7798559 7798559 20250909192732_c3P3k BG000K 2025-09-11T12:00:43.850Z 2025-09-18T12:59:05.147Z
7796020 7796020 20250909025338_n3bXl BG000K 2025-09-10T12:08:36.322Z 2025-09-17T12:56:48.549Z
7795833 7795833 20250909022443_qQcP2 BG000K 2025-09-10T12:08:03.290Z 2025-09-17T12:56:45.337Z
7795763 7795763 20250909021719_Ucs7u BG000K 2025-09-10T12:07:54.082Z 2025-09-17T12:56:43.972Z
7790922 7790922 20250908025344_LbBbu BG000K 2025-09-09T12:08:21.711Z 2025-09-16T12:51:10.657Z
7790879 7790879 20250908024818_gHmRY BG000K 2025-09-09T12:08:14.784Z 2025-09-16T12:51:10.373Z
7790611 7790611 20250908020728_9afQ1 BG000K 2025-09-09T12:07:25.212Z 2025-09-16T12:51:06.377Z
7790605 7790605 20250908020628_s3gh7 BG000K 2025-09-09T12:07:22.604Z 2025-09-16T12:51:06.309Z
7790544 7790544 20250908020009_iQJPX BG000K 2025-09-09T12:07:11.881Z 2025-09-16T12:51:05.776Z
7790393 7790393 20250908012742_Akmkv BG000K 2025-09-09T12:06:40.863Z 2025-09-16T12:51:02.187Z
7790309 7790309 20250908011714_f02B0 BG000K 2025-09-09T12:06:30.018Z 2025-09-16T12:51:01.690Z
7790081 7790081 20250908003113_CG2Dp BG000K 2025-09-09T12:05:41.589Z 2025-09-16T12:50:56.576Z
7788905 7788905 20250907180127_4KJZC BG000K 2025-09-09T12:00:45.481Z 2025-09-16T12:50:34.642Z
7785162 7785162 20250907025151_quxKr BG000K 2025-09-08T12:11:52.927Z 2025-09-15T12:44:13.178Z
7784897 7784897 20250907022308_FMniD BG000K 2025-09-08T12:10:52.549Z 2025-09-15T12:43:59.758Z
7784573 7784573 20250907013947_Qlg2P BG000K 2025-09-08T12:09:53.499Z 2025-09-15T12:43:47.783Z
7784342 7784342 20250907010407_efZIo BG000K 2025-09-08T12:09:04.938Z 2025-09-15T12:43:39.631Z
7783676 7783676 20250906233519_yVSoJ BG000K 2025-09-08T12:06:58.609Z 2025-09-15T12:43:16.725Z
7780305 7780305 20250906024449_CpBrH BG000K 2025-09-07T12:12:26.083Z 2025-09-14T12:49:43.265Z
7779986 7779986 20250906022044_bovim BG000K 2025-09-07T12:11:10.343Z 2025-09-14T12:49:36.463Z
7779848 7779848 20250906020634_ACumY BG000K 2025-09-07T12:10:45.321Z 2025-09-14T12:49:31.176Z
7779813 7779813 20250906020305_HtNiX BG000K 2025-09-07T12:10:34.357Z 2025-09-14T12:49:28.249Z
7779780 7779780 20250906020039_Y6dI3 BG000K 2025-09-07T12:10:27.224Z 2025-09-14T12:49:27.765Z
7779657 7779657 20250906015245_85Zkc BG000K 2025-09-07T12:10:12.783Z 2025-09-14T12:49:26.238Z
7779300 7779300 20250906011043_sw9ze BG000K 2025-09-07T12:08:53.973Z 2025-09-14T12:49:06.572Z
7779249 7779249 20250906010734_8joyZ BG000K 2025-09-07T12:08:46.278Z 2025-09-14T12:49:06.276Z
7779245 7779245 20250906010727_I95Nk BG000K 2025-09-07T12:08:45.487Z 2025-09-14T12:49:06.254Z
7779081 7779081 20250906004027_4Yk0J BG000K 2025-09-07T12:08:05.801Z 2025-09-14T12:49:04.610Z
7778894 7778894 20250906001158_HMNdm BG000K 2025-09-07T12:07:22.540Z 2025-09-14T12:49:02.973Z
7778864 7778864 20250906000924_Jdtul BG000K 2025-09-07T12:07:07.856Z 2025-09-14T12:49:02.722Z
7778787 7778787 20250905235324_ErTAV BG000K 2025-09-07T12:06:54.276Z 2025-09-14T12:49:02.092Z
7778747 7778747 20250905234624_JzRt5 BG000K 2025-09-07T12:06:48.428Z 2025-09-14T12:49:01.096Z
7778667 7778667 20250905233815_DT6rH BG000K 2025-09-07T12:06:25.928Z 2025-09-14T12:49:00.504Z
7778597 7778597 20250905232022_65pY1 BG000K 2025-09-07T12:06:11.554Z 2025-09-14T12:48:59.634Z
7778114 7778114 20250905214225_ZnPSr BG000K 2025-09-07T12:04:17.475Z 2025-09-14T12:48:55.274Z
7777470 7777470 20250905190955_PVmp5 BG000K 2025-09-07T12:01:46.381Z 2025-09-14T12:48:48.313Z
6511074 6511074 20250412232811_l2HVN BG000K 2025-04-14T12:10:02.359Z 2025-04-21T12:33:44.492Z
6508912 6508912 20250413025028_ynG3r BG000K 2025-04-14T12:00:33.762Z 2025-04-22T12:33:34.251Z
6508885 6508885 20250413020953_U3e6g BG000K 2025-04-14T12:00:25.018Z 2025-04-22T12:33:33.633Z
6508875 6508875 20250413012711_lOpx0 BG000K 2025-04-14T12:00:21.624Z 2025-04-22T12:33:33.466Z
6508859 6508859 20250413010549_IlAV8 BG000K 2025-04-14T12:00:16.545Z 2025-04-22T12:33:33.165Z
6508857 6508857 20250413010506_pQFaB BG000K 2025-04-14T12:00:15.609Z 2025-04-22T12:33:33.124Z
6501730 6501730 20250411025327_MOMN5 BG000K 2025-04-12T12:03:13.211Z 2025-04-19T12:24:58.915Z
6501700 6501700 20250411024707_rZ2FR BG000K 2025-04-12T12:03:00.870Z 2025-04-19T12:24:58.111Z
6501432 6501432 20250411020400_5lmnP BG000K 2025-04-12T12:02:09.663Z 2025-04-19T12:24:45.838Z
6500662 6500662 20250409224059_Jc2SB BG000K 2025-04-11T12:19:23.558Z 2025-04-17T12:25:12.237Z
6500418 6500418 20250409210751_9XhMI BG000K 2025-04-11T12:19:02.644Z 2025-04-17T12:25:02.342Z
6495546 6495546 20250410020650_peOpz BG000K 2025-04-11T12:01:44.699Z 2025-04-18T12:21:37.834Z
6495520 6495520 20250410015936_dEvtT BG000K 2025-04-11T12:01:38.542Z 2025-04-18T12:21:36.910Z
6495513 6495513 20250410015557_jRsMs BG000K 2025-04-11T12:01:35.698Z 2025-04-18T12:21:36.725Z
6495252 6495252 20250410001657_7p2Fg BG000K 2025-04-11T12:00:39.930Z 2025-04-18T12:21:26.143Z
6495233 6495233 20250410001511_F41Zu BG000K 2025-04-11T12:00:38.170Z 2025-04-18T12:21:25.962Z
6495167 6495167 20250409234722_V7hFB BG000K 2025-04-11T12:00:22.067Z 2025-04-18T12:21:24.784Z
6494870 6494870 20250408221240_WqI25 BG000K 2025-04-10T12:18:34.520Z 2025-04-16T12:27:19.283Z
6490456 6490456 20250409024054_WCYUy BG000K 2025-04-10T12:03:37.552Z 2025-04-17T12:22:25.371Z

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