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

341 rows where station_code = "UK00C4" 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
9253008 9253008 20260121054358_JkipB UK00C4 2026-01-24T14:35:05.619Z 2026-01-29T15:05:36.661Z
9214648 9214648 20260116071803_VSjf4 UK00C4 2026-01-17T14:22:32.456Z 2026-01-24T15:13:57.706Z
9199876 9199876 20260113214611_QRD0C UK00C4 2026-01-15T14:12:55.190Z 2026-01-22T15:08:04.536Z
9174799 9174799 20260109230311_uEvmk UK00C4 2026-01-11T14:04:26.424Z 2026-01-18T15:07:11.407Z
9157892 9157892 20260105191248_RMf2i UK00C4 2026-01-07T14:04:02.405Z 2026-01-13T15:06:43.693Z
9136190 9136190 20260103194145_YrdfE UK00C4 2026-01-05T14:06:17.761Z 2026-01-12T15:01:11.819Z
9135970 9135970 20260103192759_nkF49 UK00C4 2026-01-05T14:05:48.106Z 2026-01-12T15:01:03.169Z
9132603 9132603 20260103071046_tFINp UK00C4 2026-01-04T14:17:12.519Z 2026-01-10T15:01:40.865Z
9116294 9116294 20251231060130_ugLj2 UK00C4 2026-01-01T14:27:43.903Z 2026-01-08T15:11:42.110Z
9099320 9099320 20251226202544_TuRR4 UK00C4 2025-12-30T15:23:20.224Z 2026-01-03T15:43:43.068Z
9093432 9093432 20251227064904_KbmLN UK00C4 2025-12-30T15:03:40.656Z 2026-01-04T15:30:53.712Z
9092867 9092867 20251227032228_mxcpy UK00C4 2025-12-30T15:01:05.292Z 2026-01-04T15:28:05.222Z
9065365 9065365 20251226050844_JT6y3 UK00C4 2025-12-29T14:38:29.652Z 2026-01-03T15:36:52.579Z
9055459 9055459 20251227032228_8zNJi UK00C4 2025-12-29T14:18:06.170Z 2025-12-29T14:51:08.682Z
9054967 9054967 20251227030146_OJcNT UK00C4 2025-12-29T14:16:50.088Z 2025-12-30T15:00:37.864Z
9054639 9054639 20251227024613_wYoCE UK00C4 2025-12-29T14:16:01.880Z 2026-01-04T15:27:28.404Z
9029488 9029488 20251225035400_f2ks3 UK00C4 2025-12-28T14:16:29.025Z 2026-01-02T15:44:23.119Z
8992830 8992830 20251218195816_xTG2n UK00C4 2025-12-26T14:51:47.321Z 2025-12-27T15:26:57.216Z
8977707 8977707 20251219053612_rdPwL UK00C4 2025-12-26T14:13:29.792Z 2025-12-26T14:32:01.406Z
8977582 8977582 20251219052133_3o72L UK00C4 2025-12-26T14:13:06.591Z 2025-12-28T15:17:33.996Z
8974563 8974563 20251220023237_QgsBr UK00C4 2025-12-26T14:04:42.438Z 2025-12-29T15:22:42.851Z
8969538 8969538 20251216200800_xluHv UK00C4 2025-12-25T14:51:06.744Z 2025-12-25T14:51:06.744Z
8969098 8969098 20251216183544_YYfsl UK00C4 2025-12-25T14:50:21.158Z 2025-12-25T14:50:21.158Z
8963913 8963913 20251216070015_D53a5 UK00C4 2025-12-25T14:40:14.132Z 2025-12-25T14:40:14.132Z
8963528 8963528 20251216054854_6qO8N UK00C4 2025-12-25T14:39:18.105Z 2025-12-25T14:39:18.105Z
8963365 8963365 20251216052200_t7PDc UK00C4 2025-12-25T14:38:59.501Z 2025-12-25T14:38:59.501Z
8963341 8963341 20251216051519_ApvRa UK00C4 2025-12-25T14:38:39.689Z 2025-12-25T14:38:39.689Z
8963210 8963210 20251216045720_pLUjl UK00C4 2025-12-25T14:38:23.642Z 2025-12-25T14:38:23.642Z
8962964 8962964 20251216041728_6LBVU UK00C4 2025-12-25T14:37:38.592Z 2025-12-25T14:37:38.592Z
8962941 8962941 20251216041407_zqmbr UK00C4 2025-12-25T14:37:35.115Z 2025-12-25T14:37:35.115Z
8962935 8962935 20251216041256_TqRzO UK00C4 2025-12-25T14:37:34.329Z 2025-12-25T14:37:34.329Z
8962507 8962507 20251216032508_K5Hmy UK00C4 2025-12-25T14:35:58.740Z 2025-12-25T14:35:58.740Z
8802753 8802753 20251213065429_SJm2v UK00C4 2025-12-16T14:15:03.822Z 2025-12-23T14:19:26.251Z
8801147 8801147 20251213061703_suBum UK00C4 2025-12-16T14:13:21.459Z 2025-12-23T14:19:20.412Z
8800908 8800908 20251213061305_soRby UK00C4 2025-12-16T14:13:15.246Z 2025-12-23T14:19:19.788Z
8800264 8800264 20251213055907_b70VH UK00C4 2025-12-16T14:12:34.308Z 2025-12-23T14:19:14.146Z
8799054 8799054 20251213053610_J3PZ3 UK00C4 2025-12-16T14:11:21.114Z 2025-12-23T14:18:34.967Z
8798989 8798989 20251213053504_VoMh2 UK00C4 2025-12-16T14:11:20.289Z 2025-12-23T14:18:34.650Z
8797631 8797631 20251213050933_YvmLv UK00C4 2025-12-16T14:10:08.505Z 2025-12-23T14:18:06.252Z
8797528 8797528 20251213050752_sgDLt UK00C4 2025-12-16T14:10:04.940Z 2025-12-23T14:18:04.276Z
8796928 8796928 20251213045715_k2YmV UK00C4 2025-12-16T14:09:08.999Z 2025-12-23T14:17:49.761Z
8796776 8796776 20251213045505_yzFcP UK00C4 2025-12-16T14:09:02.215Z 2025-12-23T14:17:47.962Z
8795540 8795540 20251213043835_ZVDF3 UK00C4 2025-12-16T14:08:09.300Z 2025-12-23T14:17:31.286Z
8795204 8795204 20251213043412_TRCrs UK00C4 2025-12-16T14:07:40.378Z 2025-12-23T14:17:26.264Z
8793701 8793701 20251213041413_gvd2q UK00C4 2025-12-16T14:06:17.547Z 2025-12-23T14:16:54.976Z
8792149 8792149 20251213035024_FJVrX UK00C4 2025-12-16T14:04:21.334Z 2025-12-23T14:16:24.873Z
8790799 8790799 20251213033548_2ZO1R UK00C4 2025-12-16T14:02:36.300Z 2025-12-23T14:16:22.180Z
8788286 8788286 20251213025546_FfGuq UK00C4 2025-12-15T14:38:41.276Z 2025-12-21T14:17:37.703Z
8787961 8787961 20251213025117_3HsEg UK00C4 2025-12-15T14:38:32.774Z 2025-12-21T14:17:37.560Z
8787495 8787495 20251213024439_q7GmH UK00C4 2025-12-15T14:38:21.927Z 2025-12-21T14:17:37.358Z
8787082 8787082 20251213023925_wnzy3 UK00C4 2025-12-15T14:37:50.357Z 2025-12-21T14:17:37.134Z
8787074 8787074 20251213023925_GN3xb UK00C4 2025-12-15T14:37:50.154Z 2025-12-21T14:17:37.132Z
8786742 8786742 20251213023440_bDhXF UK00C4 2025-12-15T14:37:42.801Z 2025-12-21T14:17:36.913Z
8786399 8786399 20251213022959_UDLgs UK00C4 2025-12-15T14:37:34.505Z 2025-12-21T14:17:36.714Z
8786107 8786107 20251213022539_0ZUFP UK00C4 2025-12-15T14:37:28.517Z 2025-12-21T14:17:36.568Z
8783667 8783667 20251213014836_zwBuB UK00C4 2025-12-15T14:35:24.450Z 2025-12-21T14:17:35.092Z
8783560 8783560 20251213014714_EoAgc UK00C4 2025-12-15T14:35:02.550Z 2025-12-21T14:17:35.030Z
8783435 8783435 20251213014326_7RPe0 UK00C4 2025-12-15T14:34:39.570Z 2025-12-21T14:17:34.950Z
8783002 8783002 20251213013703_45rB5 UK00C4 2025-12-15T14:34:28.213Z 2025-12-21T14:17:34.664Z
8782365 8782365 20251213012718_r9WUg UK00C4 2025-12-15T14:34:15.354Z 2025-12-21T14:17:34.272Z
8780283 8780283 20251213005504_EvgyD UK00C4 2025-12-15T14:32:36.878Z 2025-12-21T14:17:33.150Z
8779310 8779310 20251213003931_xhrxU UK00C4 2025-12-15T14:31:50.704Z 2025-12-21T14:17:32.630Z
8778403 8778403 20251213002522_leA1O UK00C4 2025-12-15T14:31:07.247Z 2025-12-21T14:17:32.136Z
8778036 8778036 20251213001810_XokX8 UK00C4 2025-12-15T14:30:52.841Z 2025-12-21T14:17:31.918Z
8776284 8776284 20251212234446_raMtl UK00C4 2025-12-15T14:29:02.286Z 2025-12-21T14:17:30.812Z
8773912 8773912 20251212225056_8S0mp UK00C4 2025-12-15T14:26:47.258Z 2025-12-21T14:17:29.401Z
8773268 8773268 20251212223231_EVdwG UK00C4 2025-12-15T14:25:58.862Z 2025-12-21T14:17:28.945Z
8772370 8772370 20251212220257_5LwVT UK00C4 2025-12-15T14:24:50.929Z 2025-12-21T14:17:28.425Z
8771668 8771668 20251212214116_Oy0vh UK00C4 2025-12-15T14:23:53.905Z 2025-12-21T14:17:28.024Z
8771508 8771508 20251212213206_TA7J3 UK00C4 2025-12-15T14:23:47.845Z 2025-12-21T14:17:27.903Z
8771301 8771301 20251212211750_0ytrk UK00C4 2025-12-15T14:23:12.564Z 2025-12-21T14:17:27.725Z
8770624 8770624 20251212204444_uvelf UK00C4 2025-12-15T14:22:18.940Z 2025-12-21T14:17:27.318Z
8770572 8770572 20251212204127_io9Wt UK00C4 2025-12-15T14:22:15.508Z 2025-12-21T14:17:27.290Z
8770220 8770220 20251212201504_BTefC UK00C4 2025-12-15T14:21:42.499Z 2025-12-21T14:17:27.108Z
8768901 8768901 20251212175042_dUs98 UK00C4 2025-12-15T14:18:20.297Z 2025-12-21T14:17:26.362Z
8727093 8727093 20251212061836_kEdrj UK00C4 2025-12-13T14:06:44.213Z 2025-12-21T14:17:21.478Z
8726189 8726189 20251212041751_ycBxY UK00C4 2025-12-13T14:02:15.969Z 2025-12-21T14:17:20.840Z
8706077 8706077 20251207191024_cBqy9 UK00C4 2025-12-09T14:22:53.028Z 2025-12-16T15:11:53.840Z
8690077 8690077 20251204202205_u4EJ4 UK00C4 2025-12-06T14:13:10.674Z 2025-12-13T16:03:39.872Z
8680295 8680295 20251202230359_C4OUv UK00C4 2025-12-04T14:11:38.084Z 2025-12-11T14:45:37.004Z
8657568 8657568 20251130055248_d2ZbY UK00C4 2025-12-01T14:34:33.347Z 2025-12-08T14:56:40.753Z
8650711 8650711 20251129211302_QstM5 UK00C4 2025-12-01T14:17:01.247Z 2025-12-08T14:53:04.161Z
8650389 8650389 20251129200646_maY8K UK00C4 2025-12-01T14:15:59.899Z 2025-12-08T14:52:58.732Z
8648678 8648678 20251128065821_hRe6x UK00C4 2025-11-30T14:38:18.752Z 2025-12-06T15:04:05.101Z
8648674 8648674 20251128051611_V6e2y UK00C4 2025-11-30T14:38:05.430Z 2025-12-06T15:03:57.750Z
8603019 8603019 20251125053821_eF6wq UK00C4 2025-11-26T14:26:35.376Z 2025-12-02T15:09:33.970Z
8602990 8602990 20251125053704_MJWXt UK00C4 2025-11-26T14:26:31.930Z 2025-12-02T15:09:33.864Z
8602323 8602323 20251125044746_EL2pn UK00C4 2025-11-26T14:25:33.447Z 2025-12-02T15:09:30.467Z
8601820 8601820 20251125041926_s2Hp2 UK00C4 2025-11-26T14:24:47.240Z 2025-12-02T15:09:25.879Z
8601682 8601682 20251125040918_pxOOo UK00C4 2025-11-26T14:24:35.804Z 2025-12-02T15:09:18.775Z
8601468 8601468 20251125034826_3T622 UK00C4 2025-11-26T14:24:02.904Z 2025-12-02T15:09:09.318Z
8600556 8600556 20251125030610_uHLR4 UK00C4 2025-11-26T14:22:47.106Z 2025-12-02T15:08:46.389Z
8600002 8600002 20251125023605_kWZ5s UK00C4 2025-11-26T14:21:56.434Z 2025-12-02T15:08:33.367Z
8599839 8599839 20251125022714_XW83O UK00C4 2025-11-26T14:21:32.252Z 2025-12-02T15:08:32.347Z
8599391 8599391 20251125020311_9Cou8 UK00C4 2025-11-26T14:20:53.115Z 2025-12-02T15:08:23.801Z
8599315 8599315 20251125015822_AEmak UK00C4 2025-11-26T14:20:46.823Z 2025-12-02T15:08:22.249Z
8598455 8598455 20251125005748_84iU8 UK00C4 2025-11-26T14:19:08.243Z 2025-12-02T15:07:54.690Z
8598353 8598353 20251125005215_oYcHZ UK00C4 2025-11-26T14:18:40.551Z 2025-12-02T15:07:53.197Z
8598244 8598244 20251125004549_GcEN3 UK00C4 2025-11-26T14:18:30.434Z 2025-12-02T15:07:49.033Z
8597205 8597205 20251124231344_CA3XE UK00C4 2025-11-26T14:16:21.421Z 2025-12-02T15:07:24.295Z

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