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

1,183 rows where station_code = "BA0005" 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
9271805 9271805 20260127201938_CAViA BA0005 2026-01-29T14:23:57.072Z 2026-01-29T14:30:25.151Z
9271746 9271746 20260127194846_ntHW6 BA0005 2026-01-29T14:23:15.301Z 2026-01-29T14:30:25.096Z
9256466 9256466 20260119210108_Jqyk8 BA0005 2026-01-25T14:38:35.864Z 2026-01-28T14:57:33.662Z
9235123 9235123 20260120003200_AjgWO BA0005 2026-01-21T14:17:40.506Z 2026-01-28T14:58:31.825Z
9235086 9235086 20260120002715_ANNJK BA0005 2026-01-21T14:17:27.920Z 2026-01-28T14:58:30.231Z
9234951 9234951 20260119235415_LmmwN BA0005 2026-01-21T14:16:48.801Z 2026-01-28T14:58:21.959Z
9234936 9234936 20260119235325_YUQhn BA0005 2026-01-21T14:16:44.580Z 2026-01-28T14:58:21.398Z
9234739 9234739 20260119231327_tRJ1v BA0005 2026-01-21T14:15:56.561Z 2026-01-28T14:58:03.840Z
9234565 9234565 20260119222716_eSmE3 BA0005 2026-01-21T14:15:09.340Z 2026-01-28T14:57:54.315Z
9234383 9234383 20260119211059_gbeHq BA0005 2026-01-21T14:14:05.889Z 2026-01-28T14:57:35.523Z
9234355 9234355 20260119205744_33LDw BA0005 2026-01-21T14:13:56.164Z 2026-01-28T14:57:32.627Z
9234235 9234235 20260119201721_Rrn7C BA0005 2026-01-21T14:13:12.419Z 2026-01-28T14:57:23.911Z
9234147 9234147 20260119194851_8PH57 BA0005 2026-01-21T14:12:33.653Z 2026-01-28T14:57:17.611Z
9234117 9234117 20260119194307_kGHaT BA0005 2026-01-21T14:12:27.060Z 2026-01-28T14:57:07.310Z
9234113 9234113 20260119194307_JqrCL BA0005 2026-01-21T14:12:26.643Z 2026-01-28T14:57:07.143Z
9234099 9234099 20260119193835_WSUkF BA0005 2026-01-21T14:12:23.494Z 2026-01-28T14:57:05.963Z
9234021 9234021 20260119191821_RJhis BA0005 2026-01-21T14:11:54.277Z 2026-01-28T14:56:59.303Z
9233918 9233918 20260119184538_zGZC1 BA0005 2026-01-21T14:11:23.431Z 2026-01-28T14:56:52.814Z
9233800 9233800 20260119180017_t8Y6Z BA0005 2026-01-21T14:10:41.285Z 2026-01-28T14:56:42.358Z
9233696 9233696 20260119170235_DaXWT BA0005 2026-01-21T14:09:54.455Z 2026-01-28T14:56:23.497Z
9228999 9228999 20260119003251_JsB30 BA0005 2026-01-20T14:20:33.344Z 2026-01-27T15:02:47.173Z
9228603 9228603 20260118230826_uYvfO BA0005 2026-01-20T14:18:35.650Z 2026-01-27T15:02:10.579Z
9228531 9228531 20260118224349_C3fh3 BA0005 2026-01-20T14:18:10.903Z 2026-01-27T15:02:05.939Z
9228456 9228456 20260118222632_vflL2 BA0005 2026-01-20T14:17:53.691Z 2026-01-27T15:02:02.312Z
9228428 9228428 20260118222047_oi8ws BA0005 2026-01-20T14:17:45.845Z 2026-01-27T15:02:00.739Z
9228377 9228377 20260118220048_iLofU BA0005 2026-01-20T14:17:30.294Z 2026-01-27T15:01:57.542Z
9228357 9228357 20260118215023_X3JGe BA0005 2026-01-20T14:17:24.961Z 2026-01-27T15:01:55.904Z
9228311 9228311 20260118213100_H3u5f BA0005 2026-01-20T14:17:09.035Z 2026-01-27T15:01:47.486Z
9228251 9228251 20260118210058_Z3lyF BA0005 2026-01-20T14:16:53.873Z 2026-01-27T15:01:36.572Z
9228236 9228236 20260118205050_VhS24 BA0005 2026-01-20T14:16:47.336Z 2026-01-27T15:01:35.485Z
9228148 9228148 20260118200620_eD31V BA0005 2026-01-20T14:16:16.819Z 2026-01-27T15:01:29.578Z
9227749 9227749 20260118172343_enPzD BA0005 2026-01-20T14:13:46.742Z 2026-01-27T15:00:50.624Z
9205799 9205799 20260112051224_zKSEd BA0005 2026-01-15T14:46:17.698Z 2026-01-20T15:23:29.398Z
9205797 9205797 20260112050102_Q0HT8 BA0005 2026-01-15T14:46:12.345Z 2026-01-20T15:23:17.578Z
9205793 9205793 20260112043353_RiqTI BA0005 2026-01-15T14:46:05.691Z 2026-01-20T15:23:11.714Z
9198511 9198511 20260113165241_32l3H BA0005 2026-01-15T14:05:04.220Z 2026-01-22T15:06:32.600Z
9194099 9194099 20260112174856_OAj3j BA0005 2026-01-14T14:07:16.973Z 2026-01-21T15:03:30.361Z
9194038 9194038 20260112165506_8pjXJ BA0005 2026-01-14T14:06:44.184Z 2026-01-21T15:03:21.513Z
9189567 9189567 20260112050958_H7o0I BA0005 2026-01-13T14:18:18.477Z 2026-01-20T15:23:22.076Z
9189550 9189550 20260112050425_33sHu BA0005 2026-01-13T14:18:10.452Z 2026-01-20T15:23:17.827Z
9188197 9188197 20260111212200_ld8A6 BA0005 2026-01-13T14:10:57.114Z 2026-01-20T15:21:26.566Z
9188189 9188189 20260111212046_YcoMJ BA0005 2026-01-13T14:10:55.321Z 2026-01-20T15:21:26.240Z
9171684 9171684 20260109012727_hDpss BA0005 2026-01-10T14:08:55.396Z 2026-01-17T15:24:18.050Z
9171641 9171641 20260109001736_n1gaa BA0005 2026-01-10T14:08:38.540Z 2026-01-17T15:24:13.458Z
9171462 9171462 20260108220548_r1JtQ BA0005 2026-01-10T14:07:33.277Z 2026-01-17T15:23:53.791Z
9171366 9171366 20260108211648_WMWyH BA0005 2026-01-10T14:06:57.459Z 2026-01-17T15:23:45.857Z
9171273 9171273 20260108203658_aRWOO BA0005 2026-01-10T14:06:25.242Z 2026-01-17T15:23:40.559Z
9171213 9171213 20260108200420_He3LZ BA0005 2026-01-10T14:05:58.536Z 2026-01-17T15:23:36.817Z
9170938 9170938 20260108175209_xg2qk BA0005 2026-01-10T14:04:16.814Z 2026-01-17T15:23:12.517Z
9129001 9129001 20251229042135_xvw9L BA0005 2026-01-03T14:59:24.341Z 2026-01-06T15:17:54.656Z
9128998 9128998 20251229040922_3o3Sh BA0005 2026-01-03T14:59:13.934Z 2026-01-06T15:17:49.566Z
9128971 9128971 20251229030315_c8iWc BA0005 2026-01-03T14:57:55.187Z 2026-01-06T15:17:05.308Z
9128958 9128958 20251229012845_7T64i BA0005 2026-01-03T14:56:27.371Z 2026-01-06T15:16:04.278Z
9128954 9128954 20251229012532_gW7bJ BA0005 2026-01-03T14:56:23.830Z 2026-01-06T15:16:03.066Z
9128952 9128952 20251229012330_gpkkR BA0005 2026-01-03T14:56:22.213Z 2026-01-06T15:16:02.244Z
9128950 9128950 20251229011055_0g21p BA0005 2026-01-03T14:56:01.473Z 2026-01-06T15:15:54.946Z
9128948 9128948 20251229010809_x8zib BA0005 2026-01-03T14:56:00.215Z 2026-01-06T15:15:54.150Z
9128932 9128932 20251228234110_Ro0ag BA0005 2026-01-03T14:55:03.570Z 2026-01-06T15:15:05.292Z
9128788 9128788 20251230212916_2Hm65 BA0005 2026-01-03T14:25:15.776Z 2026-01-08T15:04:47.252Z
9126463 9126463 20260101211106_ibh2V BA0005 2026-01-03T14:04:30.345Z 2026-01-09T14:48:43.164Z
9125178 9125178 20251231170059_8l213 BA0005 2026-01-02T14:54:24.895Z 2026-01-08T15:15:16.730Z
9125177 9125177 20251231170054_QGSdY BA0005 2026-01-02T14:54:24.416Z 2026-01-08T15:15:16.539Z
9121081 9121081 20251231203651_4oiu0 BA0005 2026-01-02T14:05:42.040Z 2026-01-09T14:51:44.868Z
9121043 9121043 20251231202837_KZM1E BA0005 2026-01-02T14:05:33.198Z 2026-01-09T14:51:43.878Z
9120964 9120964 20251231201341_LuHTZ BA0005 2026-01-02T14:05:11.748Z 2026-01-09T14:51:33.160Z
9119340 9119340 20251230173818_1dX7J BA0005 2026-01-01T14:55:45.662Z 2026-01-01T14:58:01.703Z
9112687 9112687 20251231024647_NgTT5 BA0005 2026-01-01T14:16:00.539Z 2026-01-08T15:08:03.547Z
9112235 9112235 20251231021344_Fzrvn BA0005 2026-01-01T14:14:28.241Z 2026-01-08T15:07:34.732Z
9112229 9112229 20251231021330_62QDo BA0005 2026-01-01T14:14:27.479Z 2026-01-08T15:07:34.462Z
9111439 9111439 20251231010931_KpmKn BA0005 2026-01-01T14:11:27.876Z 2026-01-08T15:06:39.819Z
9111192 9111192 20251231004752_Sk1d9 BA0005 2026-01-01T14:10:26.464Z 2026-01-08T15:06:20.282Z
9111059 9111059 20251231003404_kTuIt BA0005 2026-01-01T14:09:58.889Z 2026-01-08T15:06:13.826Z
9110924 9110924 20251231001833_SRIAh BA0005 2026-01-01T14:09:23.982Z 2026-01-02T14:26:33.120Z
9110667 9110667 20251230234947_oKRDq BA0005 2026-01-01T14:08:20.589Z 2026-01-08T15:05:44.671Z
9110638 9110638 20251230234505_ez63z BA0005 2026-01-01T14:08:13.090Z 2026-01-08T15:05:42.992Z
9109955 9109955 20251230214254_Ern4w BA0005 2026-01-01T14:04:55.394Z 2026-01-08T15:04:49.911Z
9109615 9109615 20251230200556_6mQhm BA0005 2026-01-01T14:02:14.062Z 2026-01-08T15:04:14.647Z
9108615 9108615 20251229191254_uq103 BA0005 2025-12-31T14:44:01.505Z 2026-01-06T15:21:40.418Z
9108023 9108023 20251229174522_0sG3K BA0005 2025-12-31T14:42:39.097Z 2026-01-06T15:21:21.479Z
9107974 9107974 20251229173920_4i6Ns BA0005 2025-12-31T14:42:25.914Z 2026-01-02T15:16:17.614Z
9106885 9106885 20251229015813_Gowgr BA0005 2025-12-31T14:34:04.719Z 2025-12-31T14:34:04.719Z
9106859 9106859 20251229010211_c7mg3 BA0005 2025-12-31T14:33:07.150Z 2026-01-06T15:15:41.965Z
9101105 9101105 20251229223743_gLXml BA0005 2025-12-31T14:06:35.925Z 2026-01-07T15:05:53.652Z
9100905 9100905 20251229213619_2WFxG BA0005 2025-12-31T14:05:22.055Z 2026-01-07T15:05:43.551Z
9098991 9098991 20251227204137_24R4j BA0005 2025-12-30T15:11:20.792Z 2026-01-04T15:35:34.718Z
9098547 9098547 20251227193149_p0coU BA0005 2025-12-30T15:10:35.849Z 2026-01-04T15:35:08.176Z
9098380 9098380 20251227185801_qv6HA BA0005 2025-12-30T15:10:26.138Z 2026-01-04T15:34:58.969Z
9098349 9098349 20251227185259_wbKVk BA0005 2025-12-30T15:10:12.249Z 2026-01-04T15:34:57.673Z
9098159 9098159 20251227182028_32aWe BA0005 2025-12-30T15:09:54.749Z 2026-01-04T15:34:48.250Z
9097858 9097858 20251227174002_3GclA BA0005 2025-12-30T15:09:22.434Z 2026-01-04T15:34:23.203Z
9097725 9097725 20251227172526_VspLY BA0005 2025-12-30T15:09:14.663Z 2026-01-04T15:34:19.293Z
9097723 9097723 20251227172526_lNGD3 BA0005 2025-12-30T15:09:14.662Z 2026-01-04T15:34:19.143Z
9097574 9097574 20251227165939_B7c2L BA0005 2025-12-30T15:09:04.096Z 2025-12-30T15:09:04.096Z
9097531 9097531 20251227165049_fVgsR BA0005 2025-12-30T15:09:00.929Z 2025-12-30T15:09:00.929Z
9091965 9091965 20251228202318_pevaB BA0005 2025-12-30T14:53:37.305Z 2026-01-05T15:14:45.909Z
9091748 9091748 20251228195225_lzTzc BA0005 2025-12-30T14:53:17.270Z 2026-01-05T15:14:25.165Z
9091644 9091644 20251228193925_gb26n BA0005 2025-12-30T14:52:57.230Z 2026-01-05T15:14:20.207Z
9080628 9080628 20251229045442_RzXJM BA0005 2025-12-30T14:21:52.896Z 2026-01-06T15:18:23.193Z
9080493 9080493 20251229044505_nLqwJ BA0005 2025-12-30T14:21:25.331Z 2026-01-06T15:18:18.567Z
9080422 9080422 20251229043849_fkjzi BA0005 2025-12-30T14:21:10.591Z 2026-01-06T15:18:16.163Z

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