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

548 rows where station_code = "AU004H" 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
8685289 8685289 20251204173900_NiWMj AU004H 2025-12-05T14:06:26.706Z 2025-12-05T14:06:26.706Z
8685209 8685209 20251204154147_joOp4 AU004H 2025-12-05T14:06:11.495Z 2025-12-05T14:06:11.495Z
8684698 8684698 20251204135339_2RpmG AU004H 2025-12-05T14:04:18.421Z 2025-12-05T14:04:18.421Z
8678304 8678304 20251203171837_eNLwi AU004H 2025-12-04T14:04:16.035Z 2025-12-05T14:14:35.242Z
8678297 8678297 20251203170613_JKWg2 AU004H 2025-12-04T14:04:14.556Z 2025-12-05T14:14:35.232Z
8678267 8678267 20251203163434_AyNmz AU004H 2025-12-04T14:04:07.831Z 2025-12-05T14:14:35.204Z
8678247 8678247 20251203160143_bbiGp AU004H 2025-12-04T14:04:02.713Z 2025-12-05T14:14:35.178Z
8678234 8678234 20251203154733_KHAH2 AU004H 2025-12-04T14:04:00.007Z 2025-12-05T14:14:35.170Z
8678204 8678204 20251203152713_2j5kZ AU004H 2025-12-04T14:03:51.598Z 2025-12-05T14:14:35.149Z
8678167 8678167 20251203150935_Lujk2 AU004H 2025-12-04T14:03:42.187Z 2025-12-05T14:14:35.131Z
8678109 8678109 20251203145215_KWdoS AU004H 2025-12-04T14:03:33.752Z 2025-12-05T14:14:35.109Z
8678095 8678095 20251203144244_EHibQ AU004H 2025-12-04T14:03:31.477Z 2025-12-05T14:14:35.101Z
8678090 8678090 20251203143949_e42sA AU004H 2025-12-04T14:03:29.958Z 2025-12-05T14:14:35.098Z
8678037 8678037 20251203141135_Uvh9h AU004H 2025-12-04T14:03:16.845Z 2025-12-05T14:14:35.066Z
8677982 8677982 20251203135502_9XeFM AU004H 2025-12-04T14:03:09.701Z 2025-12-05T14:14:35.038Z
8677641 8677641 20251203112326_No3Jy AU004H 2025-12-04T14:02:07.420Z 2025-12-05T14:14:34.906Z
8673228 8673228 20251201173851_4JCYQ AU004H 2025-12-03T14:18:02.168Z 2025-12-05T14:26:17.611Z
8673158 8673158 20251201171415_0FBwn AU004H 2025-12-03T14:17:42.038Z 2025-12-05T14:26:13.267Z
8673152 8673152 20251201171148_eOeg9 AU004H 2025-12-03T14:17:41.100Z 2025-12-05T14:26:12.797Z
8673125 8673125 20251201170549_o2SHC AU004H 2025-12-03T14:17:37.253Z 2025-12-05T14:26:11.180Z
8673106 8673106 20251201165723_GR6Tp AU004H 2025-12-03T14:17:34.110Z 2025-12-05T14:26:10.206Z
8672974 8672974 20251201160141_7GW1s AU004H 2025-12-03T14:17:02.538Z 2025-12-05T14:25:52.242Z
8670302 8670302 20251202162137_DIE8w AU004H 2025-12-03T14:07:54.372Z 2025-12-05T14:18:39.351Z
8670295 8670295 20251202162035_tEMFa AU004H 2025-12-03T14:07:53.365Z 2025-12-05T14:18:39.071Z
8670293 8670293 20251202161837_mLEgR AU004H 2025-12-03T14:07:52.762Z 2025-12-05T14:18:38.979Z
8670265 8670265 20251202155317_NDvmC AU004H 2025-12-03T14:07:46.498Z 2025-12-05T14:18:35.365Z
8670218 8670218 20251202152836_sem4n AU004H 2025-12-03T14:07:28.299Z 2025-12-05T14:18:31.879Z
8670143 8670143 20251202133049_ehhNB AU004H 2025-12-03T14:07:02.478Z 2025-12-05T14:18:15.347Z
8669573 8669573 20251202113616_ZIe44 AU004H 2025-12-03T14:04:35.318Z 2025-12-05T14:17:33.156Z
8669459 8669459 20251202111433_iR0Y0 AU004H 2025-12-03T14:04:01.041Z 2025-12-05T14:17:22.425Z
8669384 8669384 20251202110408_jt05C AU004H 2025-12-03T14:03:31.527Z 2025-12-05T14:17:17.178Z
8661954 8661954 20251130173531_3ZsNp AU004H 2025-12-02T14:13:41.762Z 2025-12-05T14:32:43.453Z
8661918 8661918 20251130173056_LkMJA AU004H 2025-12-02T14:13:36.998Z 2025-12-05T14:32:42.154Z
8661821 8661821 20251130171817_wOxq0 AU004H 2025-12-02T14:13:09.175Z 2025-12-05T14:32:36.716Z
8661808 8661808 20251130171524_ukPiX AU004H 2025-12-02T14:13:06.308Z 2025-12-05T14:32:36.173Z
8661751 8661751 20251130170521_9A5La AU004H 2025-12-02T14:12:55.048Z 2025-12-05T14:32:34.001Z
8661623 8661623 20251130163443_kh00D AU004H 2025-12-02T14:12:22.178Z 2025-12-05T14:32:27.673Z
8661525 8661525 20251130154248_pTxpK AU004H 2025-12-02T14:11:47.338Z 2025-12-05T14:32:06.719Z
8661465 8661465 20251130152750_7DLx2 AU004H 2025-12-02T14:11:34.046Z 2025-12-05T14:32:03.713Z
8661191 8661191 20251130145713_v2bPg AU004H 2025-12-02T14:10:40.990Z 2025-12-05T14:31:52.743Z
8661073 8661073 20251130143939_AIvxr AU004H 2025-12-02T14:10:16.314Z 2025-12-05T14:31:48.801Z
8660926 8660926 20251130141341_7Eq3c AU004H 2025-12-02T14:09:44.642Z 2025-12-05T14:31:43.071Z
8660030 8660030 20251130114453_o7lwj AU004H 2025-12-02T14:06:17.209Z 2025-12-05T14:30:41.133Z
8659617 8659617 20251130105540_j4fqC AU004H 2025-12-02T14:04:39.366Z 2025-12-05T14:30:25.460Z
8640666 8640666 20251129151847_BO6i1 AU004H 2025-11-30T14:09:11.498Z 2025-12-05T14:39:23.937Z
8640167 8640167 20251129130134_MC9mk AU004H 2025-11-30T14:07:26.261Z 2025-12-05T14:38:47.980Z
8639858 8639858 20251129121629_YVDdn AU004H 2025-11-30T14:06:17.345Z 2025-12-05T14:38:34.417Z
8639111 8639111 20251129102910_32Hi1 AU004H 2025-11-30T14:03:44.076Z 2025-11-30T14:03:44.076Z
8638907 8638907 20251129100322_fmJTz AU004H 2025-11-30T14:02:51.727Z 2025-11-30T14:02:51.727Z
8621927 8621927 20251126171222_td382 AU004H 2025-11-28T14:17:03.524Z 2025-12-05T15:02:49.548Z
8621923 8621923 20251126170848_qJ2ql AU004H 2025-11-28T14:17:02.852Z 2025-12-05T15:02:49.449Z
8621915 8621915 20251126170259_DsLQk AU004H 2025-11-28T14:17:01.776Z 2025-12-05T15:02:49.315Z
8621802 8621802 20251126162819_PTWdX AU004H 2025-11-28T14:16:38.985Z 2025-12-05T15:02:48.070Z
8621754 8621754 20251126162127_XIQ2E AU004H 2025-11-28T14:16:30.969Z 2025-12-05T15:02:47.622Z
8621719 8621719 20251126161127_1vhHZ AU004H 2025-11-28T14:16:27.402Z 2025-12-05T15:02:47.214Z
8621405 8621405 20251126150744_m6kYn AU004H 2025-11-28T14:15:39.314Z 2025-12-05T15:02:43.935Z
8621070 8621070 20251126142423_w3Mdj AU004H 2025-11-28T14:14:39.701Z 2025-12-05T15:02:40.243Z
8621057 8621057 20251126142153_ynIVy AU004H 2025-11-28T14:14:37.998Z 2025-12-05T15:02:40.085Z
8620982 8620982 20251126140828_m3W2d AU004H 2025-11-28T14:14:28.592Z 2025-12-05T15:02:39.402Z
8620719 8620719 20251126132300_0xwqm AU004H 2025-11-28T14:13:47.246Z 2025-12-05T15:02:35.166Z
8619464 8619464 20251126101327_ho3aL AU004H 2025-11-28T14:08:57.837Z 2025-12-05T15:00:59.261Z
8619031 8619031 20251127171037_bT4hh AU004H 2025-11-28T14:06:59.104Z 2025-12-05T14:55:50.887Z
8619017 8619017 20251127163844_9Q2HN AU004H 2025-11-28T14:06:51.529Z 2025-12-05T14:55:33.872Z
8619015 8619015 20251127163827_EoFzx AU004H 2025-11-28T14:06:49.046Z 2025-12-05T14:55:33.395Z
8618903 8618903 20251127143517_vYJm3 AU004H 2025-11-28T14:06:22.731Z 2025-12-05T14:54:31.042Z
8618566 8618566 20251127124126_ny8oS AU004H 2025-11-28T14:04:59.012Z 2025-12-05T14:54:18.116Z
8617980 8617980 20251127110632_efIx3 AU004H 2025-11-28T14:03:04.544Z 2025-12-05T14:54:07.431Z
8617658 8617658 20251127100948_U2X13 AU004H 2025-11-28T14:01:50.675Z 2025-12-05T14:54:02.406Z
8605821 8605821 20251125171918_dp8gV AU004H 2025-11-27T14:08:02.408Z 2025-12-04T15:05:45.001Z
8605775 8605775 20251125170114_LIKyj AU004H 2025-11-27T14:07:52.140Z 2025-12-04T15:05:42.059Z
8605731 8605731 20251125163053_0A3Jk AU004H 2025-11-27T14:07:28.643Z 2025-12-04T15:05:37.879Z
8605730 8605730 20251125163033_EUPTB AU004H 2025-11-27T14:07:28.157Z 2025-12-04T15:05:37.818Z
8605636 8605636 20251125152634_0NJ3R AU004H 2025-11-27T14:06:49.126Z 2025-12-04T15:05:34.874Z
8605585 8605585 20251125145637_MapVm AU004H 2025-11-27T14:06:17.873Z 2025-12-04T15:05:30.679Z
8605576 8605576 20251125144738_o2VGC AU004H 2025-11-27T14:06:13.104Z 2025-12-04T15:05:30.287Z
8605567 8605567 20251125143740_guFVp AU004H 2025-11-27T14:06:03.140Z 2025-12-04T15:05:29.737Z
8605563 8605563 20251125143517_4DBa7 AU004H 2025-11-27T14:06:00.729Z 2025-12-04T15:05:29.392Z
8605557 8605557 20251125142431_afIBI AU004H 2025-11-27T14:05:57.998Z 2025-12-04T15:05:28.894Z
8605515 8605515 20251125133925_BF4iV AU004H 2025-11-27T14:05:32.752Z 2025-12-04T15:05:27.206Z
8605432 8605432 20251125114808_igN1H AU004H 2025-11-27T14:04:29.670Z 2025-12-04T15:05:19.232Z
8605426 8605426 20251125112629_D5MJT AU004H 2025-11-27T14:04:22.043Z 2025-12-04T15:05:18.138Z
8585533 8585533 20251123165459_vbqfS AU004H 2025-11-25T14:10:00.439Z 2025-12-02T15:10:01.812Z
8585044 8585044 20251123142650_7setk AU004H 2025-11-25T14:08:27.681Z 2025-12-02T15:09:53.359Z
8584850 8584850 20251123133933_jmxfW AU004H 2025-11-25T14:07:49.655Z 2025-12-02T15:09:52.254Z
8584836 8584836 20251123133705_0Lzmr AU004H 2025-11-25T14:07:47.734Z 2025-12-02T15:09:52.170Z
8584445 8584445 20251123121414_LNRr1 AU004H 2025-11-25T14:06:22.518Z 2025-12-02T15:09:48.726Z
8533010 8533010 20251119173423_5296r AU004H 2025-11-21T14:09:30.141Z 2025-11-28T14:54:08.462Z
8533008 8533008 20251119173405_ElVIi AU004H 2025-11-21T14:09:29.623Z 2025-11-28T14:54:08.398Z
8532928 8532928 20251119171826_fV42J AU004H 2025-11-21T14:09:10.654Z 2025-11-28T14:54:02.917Z
8532850 8532850 20251119170608_Rtie3 AU004H 2025-11-21T14:09:01.212Z 2025-11-28T14:54:02.133Z
8532214 8532214 20251119154238_qPIt2 AU004H 2025-11-21T14:07:33.313Z 2025-11-28T14:53:54.010Z
8531536 8531536 20251119143734_c8nJ1 AU004H 2025-11-21T14:05:29.341Z 2025-11-28T14:53:36.398Z
8531505 8531505 20251119143515_Nx6WB AU004H 2025-11-21T14:05:24.533Z 2025-11-28T14:53:35.701Z
8531422 8531422 20251119142755_O2WqI AU004H 2025-11-21T14:05:08.052Z 2025-11-28T14:53:35.151Z
8531389 8531389 20251119142509_gVjaQ AU004H 2025-11-21T14:05:00.350Z 2025-11-28T14:53:34.755Z
8531337 8531337 20251119141613_B60wI AU004H 2025-11-21T14:04:50.416Z 2025-11-28T14:53:33.492Z
8531278 8531278 20251119141051_CMjGx AU004H 2025-11-21T14:04:43.709Z 2025-11-28T14:53:32.552Z
8531277 8531277 20251119141040_eIO79 AU004H 2025-11-21T14:04:42.962Z 2025-11-28T14:53:32.353Z
8531207 8531207 20251119140129_sfYnI AU004H 2025-11-21T14:04:22.722Z 2025-11-28T14:53:31.180Z
8530984 8530984 20251119132735_CEhN0 AU004H 2025-11-21T14:03:39.916Z 2025-11-28T14:53:27.595Z

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