participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "AU0002" sorted by created_at descending
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 |
|---|---|---|---|---|---|
| 9830143 | 9830143 | 20260430212537_q42q4 | AU0002 | 2026-05-02T12:03:04.016Z | 2026-05-02T12:13:43.598Z |
| 9830136 | 9830136 | 20260430212451_NK7g1 | AU0002 | 2026-05-02T12:03:02.483Z | 2026-05-02T12:13:43.595Z |
| 9829647 | 9829647 | 20260429162002_VQo3U | AU0002 | 2026-05-01T12:28:35.627Z | 2026-05-02T12:32:11.870Z |
| 9829640 | 9829640 | 20260429160128_7DL3V | AU0002 | 2026-05-01T12:28:23.522Z | 2026-05-02T12:32:04.183Z |
| 9829608 | 9829608 | 20260429130523_pb27R | AU0002 | 2026-05-01T12:26:57.140Z | 2026-05-02T12:31:07.737Z |
| 9829605 | 9829605 | 20260429120112_qLBIF | AU0002 | 2026-05-01T12:26:49.327Z | 2026-05-02T12:30:51.146Z |
| 9824808 | 9824808 | 20260429212756_d61Xu | AU0002 | 2026-05-01T12:06:05.337Z | 2026-05-02T12:16:26.092Z |
| 9824673 | 9824673 | 20260429203039_aNDPg | AU0002 | 2026-05-01T12:05:30.499Z | 2026-05-02T12:16:10.784Z |
| 9824669 | 9824669 | 20260429202417_Hugrp | AU0002 | 2026-05-01T12:05:29.312Z | 2026-05-02T12:16:10.026Z |
| 9824627 | 9824627 | 20260429194026_wNYnA | AU0002 | 2026-05-01T12:05:20.891Z | 2026-05-02T12:16:04.094Z |
| 9824617 | 9824617 | 20260429182948_d2LMs | AU0002 | 2026-05-01T12:05:01.156Z | 2026-05-02T12:15:58.186Z |
| 9819216 | 9819216 | 20260428213458_ypqMw | AU0002 | 2026-04-30T12:10:49.343Z | 2026-05-02T12:26:21.381Z |
| 9819186 | 9819186 | 20260428212459_wP8xj | AU0002 | 2026-04-30T12:10:38.329Z | 2026-05-02T12:26:16.442Z |
| 9818270 | 9818270 | 20260428171738_AdCaA | AU0002 | 2026-04-30T12:07:12.309Z | 2026-05-02T12:25:02.354Z |
| 9810887 | 9810887 | 20260427153531_yeALG | AU0002 | 2026-04-29T12:04:37.852Z | 2026-05-02T12:32:33.497Z |
| 9804733 | 9804733 | 20260425131955_aMRJM | AU0002 | 2026-04-27T12:52:20.978Z | 2026-05-02T13:04:33.421Z |
| 9797835 | 9797835 | 20260425214229_WBjis | AU0002 | 2026-04-27T12:21:02.655Z | 2026-05-02T12:50:14.308Z |
| 9797773 | 9797773 | 20260425213012_UY8aj | AU0002 | 2026-04-27T12:20:46.111Z | 2026-05-02T12:50:11.522Z |
| 9797767 | 9797767 | 20260425212916_Jyh2a | AU0002 | 2026-04-27T12:20:45.432Z | 2026-05-02T12:50:11.322Z |
| 9797520 | 9797520 | 20260425205723_4qvCS | AU0002 | 2026-04-27T12:19:45.540Z | 2026-05-02T12:49:52.208Z |
| 9797518 | 9797518 | 20260425205720_iKbN1 | AU0002 | 2026-04-27T12:19:45.182Z | 2026-05-02T12:49:52.135Z |
| 9797455 | 9797455 | 20260425204756_lnqz9 | AU0002 | 2026-04-27T12:19:35.038Z | 2026-05-02T12:49:47.365Z |
| 9797404 | 9797404 | 20260425204155_3Oh49 | AU0002 | 2026-04-27T12:19:16.759Z | 2026-05-02T12:49:44.987Z |
| 9797373 | 9797373 | 20260425203646_yWiAi | AU0002 | 2026-04-27T12:19:09.505Z | 2026-05-02T12:49:44.275Z |
| 9797298 | 9797298 | 20260425202416_K09rK | AU0002 | 2026-04-27T12:18:57.352Z | 2026-05-02T12:49:41.403Z |
| 9797295 | 9797295 | 20260425202416_gqI5M | AU0002 | 2026-04-27T12:18:56.979Z | 2026-05-02T12:49:41.287Z |
| 9797281 | 9797281 | 20260425202311_3HoIv | AU0002 | 2026-04-27T12:18:54.572Z | 2026-05-02T12:49:40.774Z |
| 9797255 | 9797255 | 20260425201709_iY5OI | AU0002 | 2026-04-27T12:18:44.591Z | 2026-05-02T12:49:39.761Z |
| 9797249 | 9797249 | 20260425201637_iaCea | AU0002 | 2026-04-27T12:18:43.450Z | 2026-05-02T12:49:39.420Z |
| 9797220 | 9797220 | 20260425201052_KnQ1h | AU0002 | 2026-04-27T12:18:36.158Z | 2026-05-02T12:49:38.023Z |
| 9797217 | 9797217 | 20260425201006_OFYzy | AU0002 | 2026-04-27T12:18:35.775Z | 2026-05-02T12:49:37.834Z |
| 9797200 | 9797200 | 20260425200729_eQ2dw | AU0002 | 2026-04-27T12:18:32.661Z | 2026-05-02T12:49:36.837Z |
| 9797197 | 9797197 | 20260425200728_Y0Ugs | AU0002 | 2026-04-27T12:18:31.991Z | 2026-05-02T12:49:36.623Z |
| 9797173 | 9797173 | 20260425200045_tRlme | AU0002 | 2026-04-27T12:18:26.656Z | 2026-05-02T12:49:35.424Z |
| 9796961 | 9796961 | 20260425192524_4fke3 | AU0002 | 2026-04-27T12:17:32.995Z | 2026-05-02T12:49:14.252Z |
| 9796900 | 9796900 | 20260425191730_K33Lk | AU0002 | 2026-04-27T12:17:16.494Z | 2026-05-02T12:49:11.954Z |
| 9796862 | 9796862 | 20260425191258_bmkRx | AU0002 | 2026-04-27T12:17:09.035Z | 2026-05-02T12:49:11.099Z |
| 9796663 | 9796663 | 20260425183504_fOXcs | AU0002 | 2026-04-27T12:16:08.491Z | 2026-05-02T12:49:01.093Z |
| 9796626 | 9796626 | 20260425182720_5LLS8 | AU0002 | 2026-04-27T12:16:00.499Z | 2026-05-02T12:48:48.745Z |
| 9796614 | 9796614 | 20260425182629_SLybo | AU0002 | 2026-04-27T12:15:59.377Z | 2026-05-02T12:48:48.351Z |
| 9796589 | 9796589 | 20260425182300_7W5Cp | AU0002 | 2026-04-27T12:15:48.295Z | 2026-05-02T12:48:47.313Z |
| 9796442 | 9796442 | 20260425175749_E08f9 | AU0002 | 2026-04-27T12:15:17.101Z | 2026-05-02T12:48:40.139Z |
| 9796180 | 9796180 | 20260425174254_6Z5Fy | AU0002 | 2026-04-27T12:14:35.844Z | 2026-05-02T12:48:32.134Z |
| 9796072 | 9796072 | 20260425173530_gHlT1 | AU0002 | 2026-04-27T12:14:17.164Z | 2026-05-02T12:48:29.671Z |
| 9795619 | 9795619 | 20260425171356_Nc33C | AU0002 | 2026-04-27T12:13:02.942Z | 2026-05-02T12:48:05.094Z |
| 9795395 | 9795395 | 20260425165943_0oNif | AU0002 | 2026-04-27T12:12:28.708Z | 2026-05-02T12:47:59.446Z |
| 9795330 | 9795330 | 20260425165324_gvl2f | AU0002 | 2026-04-27T12:12:15.869Z | 2026-05-02T12:47:57.523Z |
| 9795300 | 9795300 | 20260425165206_xD39p | AU0002 | 2026-04-27T12:12:12.729Z | 2026-05-02T12:47:56.682Z |
| 9794532 | 9794532 | 20260425155634_Tizxm | AU0002 | 2026-04-27T12:09:51.871Z | 2026-05-02T12:47:14.918Z |
| 9793990 | 9793990 | 20260425151400_MUfFK | AU0002 | 2026-04-27T12:08:20.342Z | 2026-05-02T12:46:58.025Z |
| 9793906 | 9793906 | 20260425150921_YLF2G | AU0002 | 2026-04-27T12:07:59.134Z | 2026-05-02T12:46:55.994Z |
| 9793442 | 9793442 | 20260425143853_5vL4q | AU0002 | 2026-04-27T12:06:47.606Z | 2026-05-02T12:46:31.967Z |
| 9793244 | 9793244 | 20260425142607_lASav | AU0002 | 2026-04-27T12:06:09.225Z | 2026-05-02T12:46:24.337Z |
| 9793045 | 9793045 | 20260425141059_i2Qyo | AU0002 | 2026-04-27T12:05:29.718Z | 2026-05-02T12:46:12.100Z |
| 9792750 | 9792750 | 20260425134526_i4T8V | AU0002 | 2026-04-27T12:04:31.539Z | 2026-05-02T12:46:02.564Z |
| 9790447 | 9790447 | 20260424115228_k8YqM | AU0002 | 2026-04-26T12:34:43.337Z | 2026-05-02T13:14:30.939Z |
| 9790135 | 9790135 | 20260424112511_VqnNV | AU0002 | 2026-04-26T12:34:36.677Z | 2026-05-02T13:14:25.189Z |
| 9789940 | 9789940 | 20260424110948_m2i6n | AU0002 | 2026-04-26T12:33:49.385Z | 2026-05-02T13:14:20.705Z |
| 9783663 | 9783663 | 20260424213929_2CFHM | AU0002 | 2026-04-26T12:15:10.682Z | 2026-05-02T12:59:26.286Z |
| 9783602 | 9783602 | 20260424213524_BlzNT | AU0002 | 2026-04-26T12:15:05.524Z | 2026-05-02T12:59:24.846Z |
| 9783589 | 9783589 | 20260424213356_JizIY | AU0002 | 2026-04-26T12:15:01.853Z | 2026-05-02T12:59:24.363Z |
| 9783577 | 9783577 | 20260424213309_K4LEc | AU0002 | 2026-04-26T12:15:00.968Z | 2026-05-02T12:59:24.079Z |
| 9783476 | 9783476 | 20260424212710_7Gkxi | AU0002 | 2026-04-26T12:14:52.852Z | 2026-05-02T12:59:21.957Z |
| 9783302 | 9783302 | 20260424210613_eLwNW | AU0002 | 2026-04-26T12:14:16.351Z | 2026-05-02T12:59:15.315Z |
| 9783297 | 9783297 | 20260424210528_Mh34u | AU0002 | 2026-04-26T12:14:16.027Z | 2026-05-02T12:59:15.153Z |
| 9783201 | 9783201 | 20260424205515_0G0ZH | AU0002 | 2026-04-26T12:14:03.352Z | 2026-05-02T12:58:58.668Z |
| 9783128 | 9783128 | 20260424204451_2uIfx | AU0002 | 2026-04-26T12:13:56.527Z | 2026-05-02T12:58:56.755Z |
| 9783102 | 9783102 | 20260424204400_gkg3l | AU0002 | 2026-04-26T12:13:54.733Z | 2026-05-02T12:58:56.259Z |
| 9782979 | 9782979 | 20260424202236_Q53NF | AU0002 | 2026-04-26T12:13:24.470Z | 2026-05-02T12:58:49.066Z |
| 9782970 | 9782970 | 20260424202005_h7kLw | AU0002 | 2026-04-26T12:13:22.885Z | 2026-05-02T12:58:48.425Z |
| 9782925 | 9782925 | 20260424201428_vo3of | AU0002 | 2026-04-26T12:13:18.483Z | 2026-05-02T12:58:45.941Z |
| 9782853 | 9782853 | 20260424200455_DYSo2 | AU0002 | 2026-04-26T12:13:10.639Z | 2026-05-02T12:58:43.479Z |
| 9782823 | 9782823 | 20260424195951_fgGJq | AU0002 | 2026-04-26T12:12:52.924Z | 2026-05-02T12:58:42.445Z |
| 9782819 | 9782819 | 20260424195916_2wowt | AU0002 | 2026-04-26T12:12:52.572Z | 2026-05-02T12:58:42.390Z |
| 9782772 | 9782772 | 20260424195026_uXM4c | AU0002 | 2026-04-26T12:12:46.350Z | 2026-05-02T12:58:41.070Z |
| 9782715 | 9782715 | 20260424194229_oVUQM | AU0002 | 2026-04-26T12:12:41.087Z | 2026-05-02T12:58:38.793Z |
| 9782709 | 9782709 | 20260424194107_zPFxY | AU0002 | 2026-04-26T12:12:40.484Z | 2026-05-02T12:58:38.456Z |
| 9782543 | 9782543 | 20260424191512_V4FvN | AU0002 | 2026-04-26T12:12:08.002Z | 2026-05-02T12:58:21.156Z |
| 9782520 | 9782520 | 20260424191222_V0QLZ | AU0002 | 2026-04-26T12:12:06.357Z | 2026-05-02T12:58:17.026Z |
| 9782437 | 9782437 | 20260424190135_vgFLB | AU0002 | 2026-04-26T12:11:59.361Z | 2026-05-02T12:58:13.541Z |
| 9782388 | 9782388 | 20260424185506_AENRE | AU0002 | 2026-04-26T12:11:54.675Z | 2026-05-02T12:58:11.182Z |
| 9782291 | 9782291 | 20260424183351_Ki1ug | AU0002 | 2026-04-26T12:11:31.966Z | 2026-05-02T12:58:06.668Z |
| 9782281 | 9782281 | 20260424183129_B4Gbn | AU0002 | 2026-04-26T12:11:30.502Z | 2026-05-02T12:58:06.286Z |
| 9782147 | 9782147 | 20260424181320_6vB6i | AU0002 | 2026-04-26T12:11:19.601Z | 2026-05-02T12:58:02.507Z |
| 9782004 | 9782004 | 20260424180215_khQeu | AU0002 | 2026-04-26T12:10:54.726Z | 2026-05-02T12:57:58.044Z |
| 9781730 | 9781730 | 20260424174331_cFCrU | AU0002 | 2026-04-26T12:10:19.897Z | 2026-05-02T12:57:50.419Z |
| 9781719 | 9781719 | 20260424174236_hwswC | AU0002 | 2026-04-26T12:10:19.091Z | 2026-05-02T12:57:49.485Z |
| 9781263 | 9781263 | 20260424171804_OoqSh | AU0002 | 2026-04-26T12:09:15.418Z | 2026-05-02T12:57:22.341Z |
| 9781226 | 9781226 | 20260424171542_1X2XJ | AU0002 | 2026-04-26T12:09:12.459Z | 2026-05-02T12:57:20.854Z |
| 9780787 | 9780787 | 20260424165302_92ogx | AU0002 | 2026-04-26T12:08:25.602Z | 2026-05-02T12:57:10.577Z |
| 9780506 | 9780506 | 20260424163523_tx3r3 | AU0002 | 2026-04-26T12:07:55.001Z | 2026-05-02T12:56:50.578Z |
| 9779924 | 9779924 | 20260424160254_Z4zAt | AU0002 | 2026-04-26T12:06:42.232Z | 2026-05-02T12:56:36.617Z |
| 9779647 | 9779647 | 20260424154713_FVKYm | AU0002 | 2026-04-26T12:06:18.106Z | 2026-05-02T12:56:31.435Z |
| 9779316 | 9779316 | 20260424152312_VrCxI | AU0002 | 2026-04-26T12:05:20.100Z | 2026-05-02T12:56:10.301Z |
| 9778428 | 9778428 | 20260424144322_EL1kn | AU0002 | 2026-04-26T12:03:44.125Z | 2026-05-02T12:55:36.392Z |
| 9777900 | 9777900 | 20260424140704_ZVNl0 | AU0002 | 2026-04-26T12:02:25.351Z | 2026-05-02T12:55:21.016Z |
| 9777726 | 9777726 | 20260424135810_R2ABe | AU0002 | 2026-04-26T12:01:50.325Z | 2026-05-02T12:55:17.278Z |
| 9777348 | 9777348 | 20260424133625_q5z6J | AU0002 | 2026-04-26T12:01:09.060Z | 2026-05-02T12:54:55.466Z |
| 9776370 | 9776370 | 20260423113516_TqHu8 | AU0002 | 2026-04-25T12:58:15.901Z | 2026-04-30T13:15:09.928Z |
| 9775772 | 9775772 | 20260423104810_j2tsq | AU0002 | 2026-04-25T12:57:12.939Z | 2026-04-30T13:14:34.567Z |
Advanced export
JSON shape: default, array, newline-delimited
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);