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

>10,000 rows count all where station_code = "HU0003" 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
9610762 9610762 20260404213840_Sb0ms HU0003 2026-04-06T12:11:07.465Z 2026-04-06T12:16:14.654Z
9610714 9610714 20260404211630_4pvgy HU0003 2026-04-06T12:10:50.128Z 2026-04-06T12:16:14.641Z
9610516 9610516 20260404200404_wzLxs HU0003 2026-04-06T12:09:53.486Z 2026-04-06T12:16:14.586Z
9609000 9609000 20260404030356_q7ppP HU0003 2026-04-05T12:12:34.890Z 2026-04-06T12:20:56.351Z
9608983 9608983 20260404030035_nqtvd HU0003 2026-04-05T12:12:29.259Z 2026-04-06T12:20:55.342Z
9608909 9608909 20260404023202_6O3Ox HU0003 2026-04-05T12:12:16.189Z 2026-04-06T12:20:50.375Z
9608860 9608860 20260404020159_Fs8iM HU0003 2026-04-05T12:11:59.275Z 2026-04-06T12:20:44.208Z
9608840 9608840 20260404015539_scMNV HU0003 2026-04-05T12:11:55.639Z 2026-04-06T12:20:42.722Z
9608826 9608826 20260404014913_CRHjk HU0003 2026-04-05T12:11:52.162Z 2026-04-06T12:20:41.284Z
9608799 9608799 20260404013356_yEEdN HU0003 2026-04-05T12:11:47.934Z 2026-04-06T12:20:37.706Z
9608706 9608706 20260404005223_lIfWK HU0003 2026-04-05T12:11:23.008Z 2026-04-06T12:20:32.566Z
9608620 9608620 20260403235943_OdrrV HU0003 2026-04-05T12:11:01.378Z 2026-04-06T12:20:26.780Z
9608609 9608609 20260403235716_lNhrY HU0003 2026-04-05T12:10:54.921Z 2026-04-06T12:20:25.326Z
9608569 9608569 20260403234042_iEzLR HU0003 2026-04-05T12:10:50.376Z 2026-04-06T12:20:21.094Z
9608392 9608392 20260403225511_KYZzb HU0003 2026-04-05T12:10:20.265Z 2026-04-06T12:20:10.384Z
9608197 9608197 20260403205119_Finub HU0003 2026-04-05T12:09:28.676Z 2026-04-06T12:19:54.144Z
9608086 9608086 20260403191214_gg7h1 HU0003 2026-04-05T12:08:26.661Z 2026-04-06T12:19:36.594Z
9580096 9580096 20260325000410_RaC3z HU0003 2026-03-26T12:15:04.487Z 2026-04-02T12:37:41.943Z
9580068 9580068 20260325000007_e8Xay HU0003 2026-03-26T12:15:02.119Z 2026-04-02T12:37:41.018Z
9579798 9579798 20260324225640_HLPkL HU0003 2026-03-26T12:14:25.909Z 2026-04-02T12:37:30.680Z
9579739 9579739 20260324223947_8Bx2N HU0003 2026-03-26T12:14:19.052Z 2026-04-02T12:37:28.162Z
9579667 9579667 20260324220756_2QArc HU0003 2026-03-26T12:14:10.001Z 2026-04-02T12:37:19.736Z
9579613 9579613 20260324215818_bvtB5 HU0003 2026-03-26T12:14:04.797Z 2026-04-02T12:37:17.883Z
9579558 9579558 20260324213040_Ad7Wr HU0003 2026-03-26T12:13:56.404Z 2026-04-02T12:37:15.951Z
9579480 9579480 20260324205348_xE01a HU0003 2026-03-26T12:13:47.343Z 2026-04-02T12:37:11.940Z
9579425 9579425 20260324202109_UcRWn HU0003 2026-03-26T12:13:39.250Z 2026-04-02T12:37:09.396Z
9577020 9577020 20260325033916_D0z22 HU0003 2026-03-26T12:03:55.011Z 2026-04-03T12:36:29.669Z
9576902 9576902 20260325032404_VCQS2 HU0003 2026-03-26T12:03:37.054Z 2026-04-03T12:36:25.137Z
9576848 9576848 20260325031621_CafTd HU0003 2026-03-26T12:03:28.865Z 2026-04-03T12:36:23.429Z
9576721 9576721 20260325030025_R3eEm HU0003 2026-03-26T12:03:07.746Z 2026-04-03T12:36:19.032Z
9576590 9576590 20260325023722_bcRYT HU0003 2026-03-26T12:02:42.757Z 2026-04-03T12:36:13.766Z
9576502 9576502 20260325022314_Dt9cw HU0003 2026-03-26T12:02:28.109Z 2026-04-03T12:36:10.426Z
9576497 9576497 20260325022117_orHjY HU0003 2026-03-26T12:02:27.251Z 2026-04-03T12:36:09.577Z
9576392 9576392 20260325020011_XAimD HU0003 2026-03-26T12:02:06.022Z 2026-04-03T12:35:57.159Z
9576144 9576144 20260325012624_O2IQc HU0003 2026-03-26T12:01:26.442Z 2026-04-03T12:35:46.326Z
9576041 9576041 20260325010315_Ic4Gl HU0003 2026-03-26T12:01:05.033Z 2026-04-03T12:35:42.067Z
9575840 9575840 20260325002358_BFWD7 HU0003 2026-03-26T12:00:22.717Z 2026-04-03T12:35:24.174Z
9575830 9575830 20260325002156_991vf HU0003 2026-03-26T12:00:20.498Z 2026-04-03T12:35:23.759Z
9575453 9575453 20260323221448_7OB8Q HU0003 2026-03-25T12:21:10.641Z 2026-03-31T12:28:57.940Z
9575294 9575294 20260323202117_nA7kn HU0003 2026-03-25T12:20:46.045Z 2026-03-31T12:28:53.816Z
9571717 9571717 20260324034239_bInPR HU0003 2026-03-25T12:02:28.671Z 2026-04-02T12:34:40.969Z
9571673 9571673 20260324033130_a2GUj HU0003 2026-03-25T12:02:18.246Z 2026-04-02T12:34:38.608Z
9571653 9571653 20260324032411_f2Tjr HU0003 2026-03-25T12:02:14.128Z 2026-04-02T12:34:36.528Z
9571587 9571587 20260324030418_ZKehc HU0003 2026-03-25T12:02:01.006Z 2026-04-02T12:34:33.342Z
9571569 9571569 20260324025738_ayZma HU0003 2026-03-25T12:01:56.776Z 2026-04-02T12:34:32.217Z
9571526 9571526 20260324024515_D0IFx HU0003 2026-03-25T12:01:48.665Z 2026-04-02T12:34:30.602Z
9571434 9571434 20260324020533_FMpNe HU0003 2026-03-25T12:01:26.954Z 2026-04-02T12:34:26.349Z
9570045 9570045 20260322190058_tqNVh HU0003 2026-03-24T12:22:30.823Z 2026-03-30T12:30:26.957Z
9569986 9569986 20260322184657_nlXu7 HU0003 2026-03-24T12:22:26.535Z 2026-03-30T12:30:25.998Z
9542387 9542387 20260319232030_LyBWL HU0003 2026-03-21T12:30:01.160Z 2026-03-27T12:43:01.712Z
9541823 9541823 20260319215230_Par4f HU0003 2026-03-21T12:29:24.535Z 2026-03-27T12:42:42.137Z
9541764 9541764 20260319213827_tGbfD HU0003 2026-03-21T12:29:20.431Z 2026-03-27T12:42:41.404Z
9541758 9541758 20260319213633_c2eq6 HU0003 2026-03-21T12:29:19.894Z 2026-03-27T12:42:41.351Z
9541595 9541595 20260319210803_YNI5k HU0003 2026-03-21T12:29:12.413Z 2026-03-27T12:42:39.150Z
9541571 9541571 20260319210514_XOPu8 HU0003 2026-03-21T12:29:11.281Z 2026-03-27T12:42:38.901Z
9532547 9532547 20260320010632_iObZ8 HU0003 2026-03-21T12:03:02.766Z 2026-03-28T12:33:33.852Z
9532443 9532443 20260320005717_6VRwl HU0003 2026-03-21T12:02:44.961Z 2026-03-28T12:33:31.511Z
9532256 9532256 20260320004134_ycnh8 HU0003 2026-03-21T12:02:11.276Z 2026-03-28T12:33:26.392Z
9532182 9532182 20260320003023_qoqv7 HU0003 2026-03-21T12:01:56.841Z 2026-03-28T12:33:25.418Z
9531595 9531595 20260319232753_7wEz6 HU0003 2026-03-21T12:00:20.622Z 2026-03-28T12:33:19.115Z
9531157 9531157 20260318223719_2OC9S HU0003 2026-03-20T12:24:59.808Z 2026-03-26T12:39:17.801Z
9530833 9530833 20260318215029_2CoLC HU0003 2026-03-20T12:24:48.840Z 2026-03-26T12:39:15.984Z
9530701 9530701 20260318212601_tmxoX HU0003 2026-03-20T12:24:36.285Z 2026-03-26T12:39:14.888Z
9530674 9530674 20260318212345_zBxFu HU0003 2026-03-20T12:24:35.316Z 2026-03-26T12:39:14.725Z
9530641 9530641 20260318212108_YZjo6 HU0003 2026-03-20T12:24:33.897Z 2026-03-26T12:39:14.551Z
9530363 9530363 20260318204117_Mc7Ao HU0003 2026-03-20T12:24:19.628Z 2026-03-26T12:39:11.496Z
9529762 9529762 20260318192742_rgPL1 HU0003 2026-03-20T12:23:37.882Z 2026-03-26T12:39:06.260Z
9529525 9529525 20260318184402_nTOG4 HU0003 2026-03-20T12:23:15.850Z 2026-03-26T12:39:03.818Z
9521047 9521047 20260319035133_ouYpT HU0003 2026-03-20T12:07:26.616Z 2026-03-27T12:40:50.556Z
9520113 9520113 20260319025451_ClWhs HU0003 2026-03-20T12:05:45.659Z 2026-03-27T12:40:39.149Z
9520101 9520101 20260319025254_aSitl HU0003 2026-03-20T12:05:43.732Z 2026-03-27T12:40:38.930Z
9519137 9519137 20260319015300_ODJZZ HU0003 2026-03-20T12:04:00.060Z 2026-03-27T12:40:18.590Z
9519131 9519131 20260319015154_PXNYS HU0003 2026-03-20T12:03:58.690Z 2026-03-27T12:40:18.480Z
9519096 9519096 20260319014851_OEWkU HU0003 2026-03-20T12:03:55.369Z 2026-03-27T12:40:18.182Z
9518923 9518923 20260319013517_eIUvk HU0003 2026-03-20T12:03:36.954Z 2026-03-27T12:40:16.468Z
9518836 9518836 20260319012915_GEjkc HU0003 2026-03-20T12:03:29.295Z 2026-03-27T12:40:15.685Z
9518810 9518810 20260319012740_eXIi0 HU0003 2026-03-20T12:03:26.297Z 2026-03-27T12:40:15.296Z
9518774 9518774 20260319012420_rn0oF HU0003 2026-03-20T12:03:18.695Z 2026-03-27T12:40:13.621Z
9518753 9518753 20260319012234_GHXTF HU0003 2026-03-20T12:03:14.998Z 2026-03-27T12:40:13.308Z
9518697 9518697 20260319011947_dpG3X HU0003 2026-03-20T12:03:08.255Z 2026-03-27T12:40:12.755Z
9518415 9518415 20260319005740_AyfPr HU0003 2026-03-20T12:02:30.050Z 2026-03-27T12:40:09.404Z
9518350 9518350 20260319005249_z2095 HU0003 2026-03-20T12:02:21.810Z 2026-03-27T12:40:08.671Z
9518036 9518036 20260319002249_M3W1z HU0003 2026-03-20T12:01:47.582Z 2026-03-27T12:40:05.789Z
9517869 9517869 20260319000757_63211 HU0003 2026-03-20T12:01:26.634Z 2026-03-27T12:40:04.386Z
9517865 9517865 20260319000740_2bkGP HU0003 2026-03-20T12:01:26.180Z 2026-03-27T12:40:04.312Z
9517513 9517513 20260318233430_s6VRA HU0003 2026-03-20T12:00:34.872Z 2026-03-27T12:40:00.416Z
9501596 9501596 20260315224819_PxOkH HU0003 2026-03-17T12:25:17.084Z 2026-03-23T12:22:45.052Z
9501459 9501459 20260315222437_kWHsp HU0003 2026-03-17T12:25:03.594Z 2026-03-23T12:22:44.632Z
9501452 9501452 20260315222209_x1LMU HU0003 2026-03-17T12:25:02.902Z 2026-03-23T12:22:44.584Z
9501418 9501418 20260315221539_6yzpB HU0003 2026-03-17T12:24:58.536Z 2026-03-23T12:22:44.352Z
9501364 9501364 20260315220400_wBeGi HU0003 2026-03-17T12:24:53.592Z 2026-03-23T12:22:44.097Z
9501205 9501205 20260315213021_tCHnV HU0003 2026-03-17T12:24:41.334Z 2026-03-23T12:22:43.584Z
9501084 9501084 20260315205322_Zj4CR HU0003 2026-03-17T12:24:23.476Z 2026-03-23T12:22:42.975Z
9500966 9500966 20260315202934_YqUKt HU0003 2026-03-17T12:24:14.960Z 2026-03-23T12:22:42.620Z
9500825 9500825 20260315193834_VrCVd HU0003 2026-03-17T12:23:57.085Z 2026-03-23T12:22:41.776Z
9500750 9500750 20260315191059_ZooPU HU0003 2026-03-17T12:23:46.558Z 2026-03-23T12:22:41.241Z
9500746 9500746 20260315190922_FJEsq HU0003 2026-03-17T12:23:46.130Z 2026-03-23T12:22:41.222Z
9500725 9500725 20260315185138_d5J3p HU0003 2026-03-17T12:23:44.250Z 2026-03-23T12:22:41.087Z
9500707 9500707 20260315183426_l7Jy3 HU0003 2026-03-17T12:23:40.799Z 2026-03-23T12:22:40.976Z
9500692 9500692 20260315182551_tRj7f HU0003 2026-03-17T12:23:38.719Z 2026-03-23T12:22:40.857Z

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