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,872 rows where station_code = "AT0004" 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
8719917 8719917 20251211041830_Kp6nQ AT0004 2025-12-12T14:01:01.090Z 2025-12-12T14:01:01.090Z
8714572 8714572 20251210052842_f2v0v AT0004 2025-12-11T14:03:14.747Z 2025-12-11T14:03:14.747Z
8714570 8714570 20251210052819_FbFG1 AT0004 2025-12-11T14:03:13.449Z 2025-12-11T14:03:13.449Z
8714314 8714314 20251210050649_bjTsf AT0004 2025-12-11T14:02:16.792Z 2025-12-11T14:02:16.792Z
8713655 8713655 20251209044608_3ea3M AT0004 2025-12-10T14:16:58.374Z 2025-12-10T14:17:20.362Z
8713495 8713495 20251209040943_x8Z1F AT0004 2025-12-10T14:16:29.440Z 2025-12-10T14:17:17.430Z
8713439 8713439 20251209035506_kbUfU AT0004 2025-12-10T14:16:24.619Z 2025-12-10T14:17:17.326Z
8713132 8713132 20251209024123_t8Sea AT0004 2025-12-10T14:15:43.424Z 2025-12-10T14:17:11.431Z
8713080 8713080 20251209023132_XB3O3 AT0004 2025-12-10T14:15:39.059Z 2025-12-10T14:17:11.388Z
8713022 8713022 20251209021744_YOEER AT0004 2025-12-10T14:15:23.300Z 2025-12-10T14:17:10.993Z
8713008 8713008 20251209021524_CDKdQ AT0004 2025-12-10T14:15:21.995Z 2025-12-10T14:17:10.988Z
8712938 8712938 20251209015615_osDvr AT0004 2025-12-10T14:15:15.095Z 2025-12-10T14:17:10.733Z
8712931 8712931 20251209015412_ds26Y AT0004 2025-12-10T14:15:14.005Z 2025-12-10T14:17:10.464Z
8712915 8712915 20251209014643_7zZCU AT0004 2025-12-10T14:15:12.705Z 2025-12-10T14:17:10.158Z
8712805 8712805 20251209012550_QCLTR AT0004 2025-12-10T14:14:57.111Z 2025-12-10T14:17:10.101Z
8712795 8712795 20251209011825_2XwfC AT0004 2025-12-10T14:14:53.317Z 2025-12-10T14:17:10.095Z
8712768 8712768 20251209010823_m45IJ AT0004 2025-12-10T14:14:43.310Z 2025-12-10T14:17:10.084Z
8712646 8712646 20251209003559_POGqh AT0004 2025-12-10T14:14:30.688Z 2025-12-10T14:17:09.999Z
8712630 8712630 20251209003413_dA9m5 AT0004 2025-12-10T14:14:29.400Z 2025-12-10T14:17:09.980Z
8712609 8712609 20251209002611_8PNx3 AT0004 2025-12-10T14:14:26.998Z 2025-12-10T14:17:09.971Z
8712413 8712413 20251208224433_gDvYf AT0004 2025-12-10T14:13:54.979Z 2025-12-10T14:17:09.868Z
8712081 8712081 20251208200603_bc7Q3 AT0004 2025-12-10T14:12:51.254Z 2025-12-10T14:17:08.854Z
8711915 8711915 20251208184958_Z9GxY AT0004 2025-12-10T14:12:23.640Z 2025-12-10T14:17:08.606Z
8711858 8711858 20251208182705_S4nNL AT0004 2025-12-10T14:12:04.131Z 2025-12-10T14:17:08.552Z
8711779 8711779 20251208174325_xwhzB AT0004 2025-12-10T14:11:48.206Z 2025-12-10T14:17:08.380Z
8711725 8711725 20251208165511_M1W9o AT0004 2025-12-10T14:11:31.069Z 2025-12-10T14:17:08.210Z
8700061 8700061 20251207052325_2ptVg AT0004 2025-12-08T14:23:16.616Z 2025-12-11T14:32:36.558Z
8699963 8699963 20251207044457_OEW2q AT0004 2025-12-08T14:22:56.176Z 2025-12-11T14:32:32.052Z
8699933 8699933 20251207043352_CLn3S AT0004 2025-12-08T14:22:52.377Z 2025-12-11T14:32:31.026Z
8699871 8699871 20251207035255_AA468 AT0004 2025-12-08T14:22:42.182Z 2025-12-11T14:32:17.221Z
8699863 8699863 20251207034706_p3P9r AT0004 2025-12-08T14:22:40.880Z 2025-12-11T14:32:16.582Z
8699849 8699849 20251207033447_3n3GW AT0004 2025-12-08T14:22:31.579Z 2025-12-11T14:32:15.937Z
8699775 8699775 20251207023603_tX4IU AT0004 2025-12-08T14:22:20.506Z 2025-12-11T14:32:09.844Z
8699710 8699710 20251207015343_z2kpx AT0004 2025-12-08T14:22:10.482Z 2025-12-11T14:32:07.286Z
8699678 8699678 20251207014029_8amKz AT0004 2025-12-08T14:21:55.423Z 2025-12-11T14:32:05.473Z
8699646 8699646 20251207012333_ykGBL AT0004 2025-12-08T14:21:49.777Z 2025-12-11T14:32:03.718Z
8699548 8699548 20251207005720_cEtHz AT0004 2025-12-08T14:21:37.456Z 2025-12-11T14:32:00.091Z
8699479 8699479 20251207002129_ewhvK AT0004 2025-12-08T14:21:26.983Z 2025-12-11T14:31:57.090Z
8699430 8699430 20251206235826_LP2a1 AT0004 2025-12-08T14:21:12.943Z 2025-12-11T14:31:54.119Z
8699364 8699364 20251206234048_aA9NF AT0004 2025-12-08T14:21:05.379Z 2025-12-11T14:31:39.673Z
8699335 8699335 20251206232403_ZvjG4 AT0004 2025-12-08T14:21:00.165Z 2025-12-11T14:31:38.005Z
8699281 8699281 20251206230123_8QAeg AT0004 2025-12-08T14:20:50.169Z 2025-12-11T14:31:34.216Z
8699239 8699239 20251206224502_HABMb AT0004 2025-12-08T14:20:41.228Z 2025-12-11T14:31:32.316Z
8698907 8698907 20251206183300_YhzvP AT0004 2025-12-08T14:19:30.333Z 2025-12-11T14:30:56.411Z
8687025 8687025 20251204014652_s3QiU AT0004 2025-12-05T14:13:29.742Z 2025-12-11T14:41:58.544Z
8686271 8686271 20251203192325_crGmn AT0004 2025-12-05T14:11:28.741Z 2025-12-11T14:41:20.349Z
8683651 8683651 20251129235639_qp53N AT0004 2025-12-04T14:39:58.049Z 2025-12-08T14:53:47.205Z
8664867 8664867 20251201015328_ZB1O6 AT0004 2025-12-02T14:22:14.706Z 2025-12-09T14:58:39.850Z
8655271 8655271 20251130035142_3HjfQ AT0004 2025-12-01T14:26:42.693Z 2025-12-08T14:55:56.940Z
8654877 8654877 20251130033644_xivuo AT0004 2025-12-01T14:26:08.039Z 2025-12-08T14:55:43.676Z
8654309 8654309 20251130031016_g2y0s AT0004 2025-12-01T14:25:08.570Z 2025-12-08T14:55:10.346Z
8654219 8654219 20251130030357_iKmDy AT0004 2025-12-01T14:24:59.116Z 2025-12-08T14:55:09.020Z
8654199 8654199 20251130030254_tDtq2 AT0004 2025-12-01T14:24:57.448Z 2025-12-08T14:55:08.735Z
8654168 8654168 20251130030231_nOzmI AT0004 2025-12-01T14:24:56.156Z 2025-12-08T14:55:08.377Z
8654110 8654110 20251130025933_SVGtH AT0004 2025-12-01T14:24:52.500Z 2025-12-08T14:55:07.827Z
8653994 8653994 20251130025144_lSIfl AT0004 2025-12-01T14:24:42.424Z 2025-12-08T14:55:06.144Z
8653990 8653990 20251130025108_ycoQ1 AT0004 2025-12-01T14:24:36.637Z 2025-12-08T14:55:05.767Z
8653915 8653915 20251130024810_7TEz2 AT0004 2025-12-01T14:24:29.742Z 2025-12-08T14:55:03.899Z
8653887 8653887 20251130024650_oRt0a AT0004 2025-12-01T14:24:26.094Z 2025-12-08T14:55:03.605Z
8653742 8653742 20251130023830_pbGRE AT0004 2025-12-01T14:24:09.598Z 2025-12-08T14:55:01.191Z
8653712 8653712 20251130023742_9vdNV AT0004 2025-12-01T14:24:02.955Z 2025-12-08T14:55:00.886Z
8653636 8653636 20251130023221_h27wj AT0004 2025-12-01T14:23:53.198Z 2025-12-08T14:55:00.045Z
8653620 8653620 20251130023053_Yzjzr AT0004 2025-12-01T14:23:48.896Z 2025-12-08T14:54:59.728Z
8653578 8653578 20251130022643_600Wg AT0004 2025-12-01T14:23:43.706Z 2025-12-08T14:54:59.094Z
8653547 8653547 20251130022442_6qHlA AT0004 2025-12-01T14:23:40.828Z 2025-12-08T14:54:58.493Z
8653441 8653441 20251130021622_dFZKU AT0004 2025-12-01T14:23:31.796Z 2025-12-08T14:54:56.382Z
8653393 8653393 20251130021342_OBhOI AT0004 2025-12-01T14:23:20.897Z 2025-12-02T14:38:53.067Z
8653391 8653391 20251130021335_J2p57 AT0004 2025-12-01T14:23:20.483Z 2025-12-08T14:54:55.777Z
8653351 8653351 20251130021209_TL7Y4 AT0004 2025-12-01T14:23:17.485Z 2025-12-08T14:54:55.297Z
8653170 8653170 20251130020113_u23US AT0004 2025-12-01T14:23:01.940Z 2025-12-08T14:54:52.067Z
8652851 8652851 20251130013817_E2438 AT0004 2025-12-01T14:22:14.617Z 2025-12-08T14:54:42.305Z
8652420 8652420 20251130010829_tY1Y2 AT0004 2025-12-01T14:21:22.567Z 2025-12-08T14:54:18.872Z
8652245 8652245 20251130005840_DQ45j AT0004 2025-12-01T14:21:02.550Z 2025-12-08T14:54:16.221Z
8651760 8651760 20251130001649_DfJr0 AT0004 2025-12-01T14:19:50.269Z 2025-12-08T14:54:01.902Z
8651728 8651728 20251130001428_YzM90 AT0004 2025-12-01T14:19:46.161Z 2025-12-08T14:54:01.208Z
8651646 8651646 20251130000751_Nr3N9 AT0004 2025-12-01T14:19:37.937Z 2025-12-08T14:53:51.026Z
8651633 8651633 20251130000725_2s101 AT0004 2025-12-01T14:19:36.335Z 2025-12-08T14:53:50.720Z
8651596 8651596 20251129235910_BCqZb AT0004 2025-12-01T14:19:26.074Z 2025-12-08T14:53:47.809Z
8651497 8651497 20251129234829_17LoI AT0004 2025-12-01T14:19:13.228Z 2025-12-08T14:53:46.320Z
8651301 8651301 20251129232237_o2gzj AT0004 2025-12-01T14:18:42.631Z 2025-12-08T14:53:42.708Z
8651120 8651120 20251129224539_DW2Sr AT0004 2025-12-01T14:18:03.885Z 2025-12-08T14:53:32.942Z
8651118 8651118 20251129224538_kP7L8 AT0004 2025-12-01T14:18:03.597Z 2025-12-08T14:53:32.895Z
8650976 8650976 20251129221830_ZlH3T AT0004 2025-12-01T14:17:41.552Z 2025-12-08T14:53:17.364Z
8647087 8647087 20251129033944_teiV7 AT0004 2025-11-30T14:27:30.213Z 2025-12-07T14:58:28.618Z
8647029 8647029 20251129032946_c03Fs AT0004 2025-11-30T14:27:20.936Z 2025-12-07T14:58:25.759Z
8647010 8647010 20251129032602_F3SF7 AT0004 2025-11-30T14:27:15.822Z 2025-12-07T14:58:25.213Z
8646951 8646951 20251129031835_LY2is AT0004 2025-11-30T14:27:10.531Z 2025-12-07T14:58:23.829Z
8646888 8646888 20251129030722_FZDov AT0004 2025-11-30T14:27:05.053Z 2025-12-07T14:58:22.230Z
8646782 8646782 20251129025249_nc1MI AT0004 2025-11-30T14:26:57.359Z 2025-12-07T14:58:19.745Z
8646773 8646773 20251129025234_LK9KN AT0004 2025-11-30T14:26:56.547Z 2025-12-07T14:58:19.567Z
8646697 8646697 20251129023859_D45wK AT0004 2025-11-30T14:26:40.689Z 2025-12-07T14:58:17.375Z
8646654 8646654 20251129023543_j7hsY AT0004 2025-11-30T14:26:37.089Z 2025-12-07T14:58:16.122Z
8646623 8646623 20251129023214_2SOOC AT0004 2025-11-30T14:26:34.388Z 2025-12-07T14:58:15.249Z
8646579 8646579 20251129022431_33wiT AT0004 2025-11-30T14:26:13.217Z 2025-12-07T14:58:14.065Z
8646547 8646547 20251129022023_fJpps AT0004 2025-11-30T14:26:08.893Z 2025-12-07T14:58:13.342Z
8646450 8646450 20251129020728_ZHNeZ AT0004 2025-11-30T14:26:00.185Z 2025-12-07T14:58:10.670Z
8646436 8646436 20251129020632_ni9M2 AT0004 2025-11-30T14:25:59.231Z 2025-12-07T14:58:10.334Z
8646405 8646405 20251129020228_ljwtx AT0004 2025-11-30T14:25:57.170Z 2025-12-07T14:58:09.552Z
8646391 8646391 20251129015805_aCFoL AT0004 2025-11-30T14:25:56.292Z 2025-12-07T14:58:09.263Z
8646359 8646359 20251129015054_DgWu2 AT0004 2025-11-30T14:25:53.604Z 2025-12-07T14:58:08.519Z

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