participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,917 rows where station_code = "AU001Z" 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 |
---|---|---|---|---|---|
5097117 | 5097117 | 20240912144340_EfPyx | AU001Z | 2024-09-16T12:16:45.516Z | 2024-09-16T12:17:32.037Z |
5096983 | 5096983 | 20240912132218_jV61T | AU001Z | 2024-09-16T12:16:41.477Z | 2024-09-16T12:17:31.988Z |
5096643 | 5096643 | 20240912112654_at913 | AU001Z | 2024-09-16T12:16:30.750Z | 2024-09-16T12:17:31.836Z |
5085242 | 5085242 | 20240912210225_qfvmI | AU001Z | 2024-09-16T12:03:47.073Z | 2024-09-16T12:17:04.662Z |
5084885 | 5084885 | 20240912203049_4Kp2N | AU001Z | 2024-09-16T12:03:08.903Z | 2024-09-16T12:17:04.513Z |
5084814 | 5084814 | 20240912201638_qzsxK | AU001Z | 2024-09-16T12:02:57.010Z | 2024-09-16T12:17:04.467Z |
5084462 | 5084462 | 20240912194028_9GuSc | AU001Z | 2024-09-16T12:02:06.349Z | 2024-09-16T12:17:04.315Z |
5084052 | 5084052 | 20240912175408_fKtAf | AU001Z | 2024-09-16T12:01:00.660Z | 2024-09-16T12:17:04.064Z |
5083996 | 5083996 | 20240912172531_GEkGa | AU001Z | 2024-09-16T12:00:52.208Z | 2024-09-16T12:17:04.021Z |
5083837 | 5083837 | 20240912160954_BAouD | AU001Z | 2024-09-16T12:00:29.192Z | 2024-09-16T12:17:03.934Z |
5083829 | 5083829 | 20240912160359_r3fYX | AU001Z | 2024-09-16T12:00:27.684Z | 2024-09-16T12:17:03.930Z |
5083826 | 5083826 | 20240912160214_pl6G8 | AU001Z | 2024-09-16T12:00:27.352Z | 2024-09-16T12:17:03.928Z |
5083805 | 5083805 | 20240912154658_M20vO | AU001Z | 2024-09-16T12:00:24.691Z | 2024-09-16T12:17:03.918Z |
5073402 | 5073402 | 20240911212005_6V2Mj | AU001Z | 2024-09-15T12:07:07.925Z | 2024-09-16T12:17:29.241Z |
5073222 | 5073222 | 20240911210639_G1Bt4 | AU001Z | 2024-09-15T12:06:56.029Z | 2024-09-16T12:17:29.215Z |
5073028 | 5073028 | 20240911205307_FrN4M | AU001Z | 2024-09-15T12:06:28.734Z | 2024-09-16T12:17:29.187Z |
5072991 | 5072991 | 20240911205133_XeGXg | AU001Z | 2024-09-15T12:06:25.213Z | 2024-09-16T12:17:29.182Z |
5072850 | 5072850 | 20240911204314_TSKIq | AU001Z | 2024-09-15T12:06:11.837Z | 2024-09-16T12:17:29.159Z |
5072674 | 5072674 | 20240911203621_tltnw | AU001Z | 2024-09-15T12:06:00.192Z | 2024-09-16T12:17:29.134Z |
5072643 | 5072643 | 20240911203343_GfMub | AU001Z | 2024-09-15T12:05:56.381Z | 2024-09-16T12:17:29.126Z |
5072504 | 5072504 | 20240911201618_LUALJ | AU001Z | 2024-09-15T12:05:30.954Z | 2024-09-16T12:17:29.098Z |
5072408 | 5072408 | 20240911200406_CWrtR | AU001Z | 2024-09-15T12:05:19.081Z | 2024-09-16T12:17:29.077Z |
5072193 | 5072193 | 20240911194706_AIkJZ | AU001Z | 2024-09-15T12:04:52.089Z | 2024-09-16T12:17:29.044Z |
5072002 | 5072002 | 20240911191940_dAv3R | AU001Z | 2024-09-15T12:04:17.064Z | 2024-09-16T12:17:29.000Z |
5071981 | 5071981 | 20240911191638_3Ad8l | AU001Z | 2024-09-15T12:04:11.616Z | 2024-09-16T12:17:28.995Z |
5071949 | 5071949 | 20240911190850_q1EBF | AU001Z | 2024-09-15T12:04:05.875Z | 2024-09-16T12:17:28.987Z |
5071913 | 5071913 | 20240911185710_I9VuS | AU001Z | 2024-09-15T12:04:00.376Z | 2024-09-16T12:17:28.977Z |
5071907 | 5071907 | 20240911185603_KmTlc | AU001Z | 2024-09-15T12:03:59.720Z | 2024-09-16T12:17:28.975Z |
5071846 | 5071846 | 20240911183443_tv1af | AU001Z | 2024-09-15T12:03:49.762Z | 2024-09-16T12:17:28.957Z |
5071829 | 5071829 | 20240911183147_gctqx | AU001Z | 2024-09-15T12:03:47.649Z | 2024-09-16T12:17:28.952Z |
5071823 | 5071823 | 20240911182925_hBJa2 | AU001Z | 2024-09-15T12:03:46.960Z | 2024-09-16T12:17:28.951Z |
5071763 | 5071763 | 20240911181351_VBKpj | AU001Z | 2024-09-15T12:03:27.321Z | 2024-09-16T12:17:28.923Z |
5071716 | 5071716 | 20240911175824_51nbC | AU001Z | 2024-09-15T12:03:19.052Z | 2024-09-16T12:17:28.911Z |
5071689 | 5071689 | 20240911175018_OBbGJ | AU001Z | 2024-09-15T12:03:15.411Z | 2024-09-16T12:17:28.897Z |
5071680 | 5071680 | 20240911174736_2kjKC | AU001Z | 2024-09-15T12:03:13.779Z | 2024-09-16T12:17:28.894Z |
5071619 | 5071619 | 20240911172957_Xm4be | AU001Z | 2024-09-15T12:03:05.375Z | 2024-09-16T12:17:28.878Z |
5071608 | 5071608 | 20240911172548_ZKCBj | AU001Z | 2024-09-15T12:03:03.665Z | 2024-09-16T12:17:28.874Z |
5071547 | 5071547 | 20240911171421_OqBAB | AU001Z | 2024-09-15T12:02:52.942Z | 2024-09-16T12:17:28.859Z |
5071522 | 5071522 | 20240911171049_4T5EV | AU001Z | 2024-09-15T12:02:47.328Z | 2024-09-16T12:17:28.853Z |
5071397 | 5071397 | 20240911164556_yZ7Nj | AU001Z | 2024-09-15T12:02:27.190Z | 2024-09-16T12:17:28.801Z |
5071252 | 5071252 | 20240911162206_XqrTk | AU001Z | 2024-09-15T12:02:01.355Z | 2024-09-16T12:17:28.769Z |
5071242 | 5071242 | 20240911162125_Q55rB | AU001Z | 2024-09-15T12:02:00.110Z | 2024-09-16T12:17:28.766Z |
5071100 | 5071100 | 20240911160018_WSQor | AU001Z | 2024-09-15T12:01:40.406Z | 2024-09-16T12:17:28.734Z |
5070715 | 5070715 | 20240911145848_OPNN2 | AU001Z | 2024-09-15T12:00:40.707Z | 2024-09-16T12:17:28.651Z |
5063209 | 5063209 | 20240909201743_3Dn2T | AU001Z | 2024-09-14T12:13:42.105Z | 2024-09-16T12:19:42.688Z |
5062792 | 5062792 | 20240909182521_fsAyr | AU001Z | 2024-09-14T12:12:51.898Z | 2024-09-16T12:19:39.600Z |
5062498 | 5062498 | 20240909173407_65RMG | AU001Z | 2024-09-14T12:12:28.290Z | 2024-09-16T12:19:37.568Z |
5061630 | 5061630 | 20240909153042_RiSwY | AU001Z | 2024-09-14T12:11:03.270Z | 2024-09-16T12:19:32.661Z |
5061598 | 5061598 | 20240909152722_QMkWh | AU001Z | 2024-09-14T12:10:59.712Z | 2024-09-16T12:19:32.265Z |
5061261 | 5061261 | 20240909143817_nOPvn | AU001Z | 2024-09-14T12:10:38.979Z | 2024-09-16T12:19:30.169Z |
5061193 | 5061193 | 20240909143027_BR17b | AU001Z | 2024-09-14T12:10:33.655Z | 2024-09-16T12:19:29.720Z |
5061025 | 5061025 | 20240909135338_2QIZI | AU001Z | 2024-09-14T12:10:06.689Z | 2024-09-16T12:19:28.668Z |
5060826 | 5060826 | 20240910212157_m71zn | AU001Z | 2024-09-14T12:09:38.669Z | 2024-09-16T12:18:20.262Z |
5060824 | 5060824 | 20240910211858_kn1kz | AU001Z | 2024-09-14T12:09:38.338Z | 2024-09-16T12:18:20.141Z |
5060661 | 5060661 | 20240910204959_OgPXH | AU001Z | 2024-09-14T12:09:19.062Z | 2024-09-16T12:18:17.321Z |
5060035 | 5060035 | 20240910193804_q2sRp | AU001Z | 2024-09-14T12:08:01.212Z | 2024-09-16T12:18:11.703Z |
5057832 | 5057832 | 20240910151709_jdmIF | AU001Z | 2024-09-14T12:02:12.045Z | 2024-09-16T12:17:47.860Z |
5057079 | 5057079 | 20240908120736_UXiDi | AU001Z | 2024-09-13T12:17:44.541Z | 2024-09-16T12:21:28.737Z |
5057040 | 5057040 | 20240908115832_683aw | AU001Z | 2024-09-13T12:17:44.030Z | 2024-09-16T12:21:28.522Z |
5056855 | 5056855 | 20240908113248_ByXUA | AU001Z | 2024-09-13T12:17:40.001Z | 2024-09-16T12:21:27.556Z |
5056696 | 5056696 | 20240908111056_hsHXc | AU001Z | 2024-09-13T12:17:37.961Z | 2024-09-16T12:21:26.782Z |
5052676 | 5052676 | 20240907213103_0IXqS | AU001Z | 2024-09-13T12:15:19.018Z | 2024-09-16T12:21:07.040Z |
5052547 | 5052547 | 20240907210215_RlvOD | AU001Z | 2024-09-13T12:15:13.451Z | 2024-09-16T12:21:06.202Z |
5052491 | 5052491 | 20240907205336_q2aiL | AU001Z | 2024-09-13T12:15:11.587Z | 2024-09-16T12:21:05.963Z |
5052486 | 5052486 | 20240907205328_naY8H | AU001Z | 2024-09-13T12:15:11.366Z | 2024-09-16T12:21:05.948Z |
5052054 | 5052054 | 20240907193423_p8sO7 | AU001Z | 2024-09-13T12:14:55.144Z | 2024-09-16T12:21:03.490Z |
5050915 | 5050915 | 20240907162326_LJm66 | AU001Z | 2024-09-13T12:13:52.892Z | 2024-09-16T12:20:59.262Z |
5050876 | 5050876 | 20240907161851_mM8EW | AU001Z | 2024-09-13T12:13:50.955Z | 2024-09-16T12:20:58.863Z |
5050825 | 5050825 | 20240907161316_N1gP1 | AU001Z | 2024-09-13T12:13:47.771Z | 2024-09-16T12:20:58.708Z |
5044277 | 5044277 | 20240908143818_VB6nN | AU001Z | 2024-09-13T12:01:50.232Z | 2024-09-16T12:20:21.319Z |
5043978 | 5043978 | 20240908134236_neP34 | AU001Z | 2024-09-13T12:01:07.268Z | 2024-09-16T12:20:19.577Z |
5043864 | 5043864 | 20240908132450_gW2ub | AU001Z | 2024-09-13T12:00:50.762Z | 2024-09-16T12:20:19.164Z |
5043585 | 5043585 | 20240907113356_gIjdq | AU001Z | 2024-09-12T12:17:37.372Z | 2024-09-15T12:21:42.185Z |
5042840 | 5042840 | 20240907125723_gEk6A | AU001Z | 2024-09-12T12:17:18.809Z | 2024-09-16T12:20:54.585Z |
5042756 | 5042756 | 20240907123836_69YHY | AU001Z | 2024-09-12T12:17:18.084Z | 2024-09-16T12:20:54.092Z |
5042729 | 5042729 | 20240907123255_hgvuP | AU001Z | 2024-09-12T12:17:17.418Z | 2024-09-16T12:20:53.992Z |
5042725 | 5042725 | 20240907123147_PcpjO | AU001Z | 2024-09-12T12:17:17.280Z | 2024-09-16T12:20:53.987Z |
5038390 | 5038390 | 20240905195309_ozo4a | AU001Z | 2024-09-12T12:14:37.543Z | 2024-09-14T12:22:55.923Z |
5038321 | 5038321 | 20240905192142_CfCAg | AU001Z | 2024-09-12T12:14:33.251Z | 2024-09-14T12:22:55.582Z |
5035974 | 5035974 | 20240905121947_lVrQL | AU001Z | 2024-09-12T12:13:14.833Z | 2024-09-14T12:22:51.685Z |
5030703 | 5030703 | 20240906174719_1cD7g | AU001Z | 2024-09-12T12:02:42.077Z | 2024-09-15T12:21:19.481Z |
5030667 | 5030667 | 20240906173032_gppAZ | AU001Z | 2024-09-12T12:02:36.209Z | 2024-09-15T12:21:19.433Z |
5030648 | 5030648 | 20240906172706_MnC4G | AU001Z | 2024-09-12T12:02:33.437Z | 2024-09-15T12:21:19.393Z |
5030273 | 5030273 | 20240906142219_YE3Gt | AU001Z | 2024-09-12T12:01:36.772Z | 2024-09-15T12:21:18.385Z |
5029788 | 5029788 | 20240906112627_wxM4P | AU001Z | 2024-09-12T12:00:31.270Z | 2024-09-15T12:21:17.183Z |
5024088 | 5024088 | 20240905195309_49qho | AU001Z | 2024-09-11T12:02:36.230Z | 2024-09-14T12:22:55.926Z |
5024070 | 5024070 | 20240905192142_ckGwd | AU001Z | 2024-09-11T12:02:31.077Z | 2024-09-11T12:16:31.921Z |
5014304 | 5014304 | 20240905121947_ssTMz | AU001Z | 2024-09-10T12:02:44.497Z | 2024-09-14T12:22:51.686Z |
5014199 | 5014199 | 20240905120120_OQYKk | AU001Z | 2024-09-10T12:02:32.024Z | 2024-09-14T12:22:51.457Z |
5006992 | 5006992 | 20240903194141_xpcMG | AU001Z | 2024-09-09T12:05:18.076Z | 2024-09-12T12:19:11.020Z |
4996743 | 4996743 | 20240902204624_ucfIT | AU001Z | 2024-09-08T12:05:13.812Z | 2024-09-11T12:20:57.702Z |
4996691 | 4996691 | 20240902203848_5HpRZ | AU001Z | 2024-09-08T12:05:10.441Z | 2024-09-11T12:20:57.317Z |
4996591 | 4996591 | 20240902201228_UgwW3 | AU001Z | 2024-09-08T12:04:58.258Z | 2024-09-11T12:20:56.263Z |
4996426 | 4996426 | 20240902193844_K6ylz | AU001Z | 2024-09-08T12:04:48.600Z | 2024-09-11T12:20:54.295Z |
4996366 | 4996366 | 20240902192654_oR2UK | AU001Z | 2024-09-08T12:04:44.566Z | 2024-09-11T12:20:53.201Z |
4995810 | 4995810 | 20240902175649_eWiI3 | AU001Z | 2024-09-08T12:04:05.524Z | 2024-09-11T12:20:48.416Z |
4995808 | 4995808 | 20240902175614_affBS | AU001Z | 2024-09-08T12:04:05.397Z | 2024-09-11T12:20:48.161Z |
4995805 | 4995805 | 20240902175607_k3a4D | AU001Z | 2024-09-08T12:04:05.244Z | 2024-09-11T12:20:48.147Z |
4995770 | 4995770 | 20240902174944_12z7S | AU001Z | 2024-09-08T12:04:03.829Z | 2024-09-11T12:20:48.050Z |
4995748 | 4995748 | 20240902174617_1kTX3 | AU001Z | 2024-09-08T12:04:02.146Z | 2024-09-11T12:20:47.735Z |
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);