participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,358 rows where station_code = "AU0007" 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 |
---|---|---|---|---|---|
3074406 | 3074406 | 20230928143106_nkuyd | AU0007 | 2024-01-06T00:02:15.185Z | 2024-01-06T00:02:15.185Z |
3049504 | 3049504 | 20230923181056_LgfNd | AU0007 | 2024-01-06T00:02:07.375Z | 2024-01-06T00:02:07.375Z |
3048593 | 3048593 | 20230923143007_vCqq2 | AU0007 | 2024-01-06T00:02:05.942Z | 2024-01-06T00:02:05.942Z |
2983272 | 2983272 | 20230912165759_RpHZy | AU0007 | 2024-01-06T00:01:46.534Z | 2024-01-06T00:01:46.534Z |
2983260 | 2983260 | 20230912165411_iUiIu | AU0007 | 2024-01-06T00:01:46.532Z | 2024-01-06T00:01:46.532Z |
2983147 | 2983147 | 20230912162042_EL0Qt | AU0007 | 2024-01-06T00:01:46.518Z | 2024-01-06T00:01:46.518Z |
2982493 | 2982493 | 20230912122554_tgWNP | AU0007 | 2024-01-06T00:01:46.439Z | 2024-01-06T00:01:46.439Z |
2383533 | 2383533 | 20230414203234_lnvwZ | AU0007 | 2024-01-05T23:56:54.253Z | 2024-01-05T23:56:54.253Z |
2383351 | 2383351 | 20230414170643_CaACk | AU0007 | 2024-01-05T23:56:54.229Z | 2024-01-05T23:56:54.229Z |
2383011 | 2383011 | 20230414135209_Mcd58 | AU0007 | 2024-01-05T23:56:54.189Z | 2024-01-05T23:56:54.189Z |
2382830 | 2382830 | 20230414120621_1axJs | AU0007 | 2024-01-05T23:56:52.922Z | 2024-01-05T23:56:52.922Z |
2380372 | 2380372 | 20230413172110_A5S0b | AU0007 | 2024-01-05T23:56:52.631Z | 2024-01-05T23:56:52.631Z |
2378932 | 2378932 | 20230412203139_NTyEp | AU0007 | 2024-01-05T23:56:51.279Z | 2024-01-05T23:56:51.279Z |
2378843 | 2378843 | 20230412184351_2SYxo | AU0007 | 2024-01-05T23:56:51.267Z | 2024-01-05T23:56:51.267Z |
2378819 | 2378819 | 20230412181518_f3NlC | AU0007 | 2024-01-05T23:56:51.263Z | 2024-01-05T23:56:51.263Z |
2378754 | 2378754 | 20230412164310_BIB3h | AU0007 | 2024-01-05T23:56:51.256Z | 2024-01-05T23:56:51.256Z |
2378556 | 2378556 | 20230412125038_hD5mo | AU0007 | 2024-01-05T23:56:51.231Z | 2024-01-05T23:56:51.231Z |
2373622 | 2373622 | 20230410130753_2OMtD | AU0007 | 2024-01-05T23:56:47.827Z | 2024-01-05T23:56:47.827Z |
2372057 | 2372057 | 20230409184940_0al4Q | AU0007 | 2024-01-05T23:56:45.230Z | 2024-01-05T23:56:45.230Z |
2372049 | 2372049 | 20230409183537_RqiLM | AU0007 | 2024-01-05T23:56:45.227Z | 2024-01-05T23:56:45.227Z |
2372033 | 2372033 | 20230409181446_1vmKh | AU0007 | 2024-01-05T23:56:45.221Z | 2024-01-05T23:56:45.221Z |
2371991 | 2371991 | 20230409170703_wjxnl | AU0007 | 2024-01-05T23:56:45.207Z | 2024-01-05T23:56:45.207Z |
2371957 | 2371957 | 20230409161916_UDTJI | AU0007 | 2024-01-05T23:56:45.195Z | 2024-01-05T23:56:45.195Z |
2371929 | 2371929 | 20230409155217_rt6lm | AU0007 | 2024-01-05T23:56:45.186Z | 2024-01-05T23:56:45.186Z |
2371848 | 2371848 | 20230409124443_2RKnp | AU0007 | 2024-01-05T23:56:45.157Z | 2024-01-05T23:56:45.157Z |
2367598 | 2367598 | 20230406205007_s2NY3 | AU0007 | 2024-01-05T23:56:40.429Z | 2024-01-05T23:56:40.429Z |
2367568 | 2367568 | 20230406190334_ILklK | AU0007 | 2024-01-05T23:56:40.425Z | 2024-01-05T23:56:40.425Z |
2367550 | 2367550 | 20230406174522_CJ1Xm | AU0007 | 2024-01-05T23:56:40.423Z | 2024-01-05T23:56:40.423Z |
2367553 | 2367553 | 20230406174917_n5g5N | AU0007 | 2024-01-05T23:56:40.423Z | 2024-01-05T23:56:40.423Z |
2367495 | 2367495 | 20230406153735_5wRf5 | AU0007 | 2024-01-05T23:56:40.415Z | 2024-01-05T23:56:40.415Z |
2367160 | 2367160 | 20230405212118_8d7ZP | AU0007 | 2024-01-05T23:56:39.270Z | 2024-01-05T23:56:39.270Z |
2367132 | 2367132 | 20230405205351_mhEZy | AU0007 | 2024-01-05T23:56:39.268Z | 2024-01-05T23:56:39.268Z |
2367120 | 2367120 | 20230405204947_Th3cK | AU0007 | 2024-01-05T23:56:39.266Z | 2024-01-05T23:56:39.266Z |
2367055 | 2367055 | 20230405194846_nhfgb | AU0007 | 2024-01-05T23:56:39.259Z | 2024-01-05T23:56:39.259Z |
2367060 | 2367060 | 20230405195112_PUHzS | AU0007 | 2024-01-05T23:56:39.259Z | 2024-01-05T23:56:39.259Z |
2367042 | 2367042 | 20230405194546_A8oy5 | AU0007 | 2024-01-05T23:56:39.258Z | 2024-01-05T23:56:39.258Z |
2366991 | 2366991 | 20230405184525_IHcPM | AU0007 | 2024-01-05T23:56:39.251Z | 2024-01-05T23:56:39.251Z |
2366997 | 2366997 | 20230405185736_uXN2J | AU0007 | 2024-01-05T23:56:39.251Z | 2024-01-05T23:56:39.251Z |
2366980 | 2366980 | 20230405181738_NqNAS | AU0007 | 2024-01-05T23:56:39.249Z | 2024-01-05T23:56:39.249Z |
2366973 | 2366973 | 20230405175828_Gd9qg | AU0007 | 2024-01-05T23:56:39.248Z | 2024-01-05T23:56:39.248Z |
2366975 | 2366975 | 20230405180310_YeecJ | AU0007 | 2024-01-05T23:56:39.248Z | 2024-01-05T23:56:39.248Z |
2366953 | 2366953 | 20230405172315_UkYie | AU0007 | 2024-01-05T23:56:39.246Z | 2024-01-05T23:56:39.246Z |
2366947 | 2366947 | 20230405170501_SboZG | AU0007 | 2024-01-05T23:56:39.245Z | 2024-01-05T23:56:39.245Z |
2366906 | 2366906 | 20230405144728_C3GsS | AU0007 | 2024-01-05T23:56:39.239Z | 2024-01-05T23:56:39.239Z |
2366045 | 2366045 | 20230404212005_V8yCT | AU0007 | 2024-01-05T23:56:38.042Z | 2024-01-05T23:56:38.042Z |
2366037 | 2366037 | 20230404211722_WHy4T | AU0007 | 2024-01-05T23:56:38.041Z | 2024-01-05T23:56:38.041Z |
2366014 | 2366014 | 20230404205052_HY5J5 | AU0007 | 2024-01-05T23:56:38.038Z | 2024-01-05T23:56:38.038Z |
2366020 | 2366020 | 20230404205200_AZ43a | AU0007 | 2024-01-05T23:56:38.038Z | 2024-01-05T23:56:38.038Z |
2365993 | 2365993 | 20230404202624_oFMrU | AU0007 | 2024-01-05T23:56:38.036Z | 2024-01-05T23:56:38.036Z |
2365969 | 2365969 | 20230404194346_SSsoh | AU0007 | 2024-01-05T23:56:38.033Z | 2024-01-05T23:56:38.033Z |
2365957 | 2365957 | 20230404193732_tuaAf | AU0007 | 2024-01-05T23:56:38.032Z | 2024-01-05T23:56:38.032Z |
2365952 | 2365952 | 20230404193346_f73pW | AU0007 | 2024-01-05T23:56:38.031Z | 2024-01-05T23:56:38.031Z |
2365934 | 2365934 | 20230404190545_7ok4G | AU0007 | 2024-01-05T23:56:38.029Z | 2024-01-05T23:56:38.029Z |
2365924 | 2365924 | 20230404185526_Fv5AC | AU0007 | 2024-01-05T23:56:38.028Z | 2024-01-05T23:56:38.028Z |
2365919 | 2365919 | 20230404184253_cLPNa | AU0007 | 2024-01-05T23:56:38.027Z | 2024-01-05T23:56:38.027Z |
2365900 | 2365900 | 20230404181916_pVSDN | AU0007 | 2024-01-05T23:56:38.025Z | 2024-01-05T23:56:38.025Z |
2365903 | 2365903 | 20230404181936_gqT2E | AU0007 | 2024-01-05T23:56:38.025Z | 2024-01-05T23:56:38.025Z |
2365884 | 2365884 | 20230404180058_y8Ovd | AU0007 | 2024-01-05T23:56:38.024Z | 2024-01-05T23:56:38.024Z |
2365891 | 2365891 | 20230404181314_EL8WZ | AU0007 | 2024-01-05T23:56:38.024Z | 2024-01-05T23:56:38.024Z |
2365876 | 2365876 | 20230404175945_zAjcA | AU0007 | 2024-01-05T23:56:38.023Z | 2024-01-05T23:56:38.023Z |
2365880 | 2365880 | 20230404180056_744EI | AU0007 | 2024-01-05T23:56:38.023Z | 2024-01-05T23:56:38.023Z |
2365866 | 2365866 | 20230404174933_99BQg | AU0007 | 2024-01-05T23:56:38.022Z | 2024-01-05T23:56:38.022Z |
2365871 | 2365871 | 20230404175829_mee7O | AU0007 | 2024-01-05T23:56:38.022Z | 2024-01-05T23:56:38.022Z |
2365853 | 2365853 | 20230404173755_Wo3LN | AU0007 | 2024-01-05T23:56:38.020Z | 2024-01-05T23:56:38.020Z |
2365815 | 2365815 | 20230404165148_OjOPO | AU0007 | 2024-01-05T23:56:38.015Z | 2024-01-05T23:56:38.015Z |
2365779 | 2365779 | 20230404161739_Y3kr7 | AU0007 | 2024-01-05T23:56:38.011Z | 2024-01-05T23:56:38.011Z |
2363900 | 2363900 | 20230403184512_7iLEF | AU0007 | 2024-01-05T23:56:36.715Z | 2024-01-05T23:56:36.715Z |
2363886 | 2363886 | 20230403182339_2iTP4 | AU0007 | 2024-01-05T23:56:36.713Z | 2024-01-05T23:56:36.713Z |
2363849 | 2363849 | 20230403172758_IaU6A | AU0007 | 2024-01-05T23:56:36.708Z | 2024-01-05T23:56:36.708Z |
2363796 | 2363796 | 20230403164827_r4OD9 | AU0007 | 2024-01-05T23:56:36.701Z | 2024-01-05T23:56:36.701Z |
2363799 | 2363799 | 20230403165114_322Gx | AU0007 | 2024-01-05T23:56:36.701Z | 2024-01-05T23:56:36.701Z |
2363786 | 2363786 | 20230403164424_TnNwb | AU0007 | 2024-01-05T23:56:36.700Z | 2024-01-05T23:56:36.700Z |
2363691 | 2363691 | 20230403150306_MZGf2 | AU0007 | 2024-01-05T23:56:36.686Z | 2024-01-05T23:56:36.686Z |
2361874 | 2361874 | 20230402210425_nIfXj | AU0007 | 2024-01-05T23:56:35.357Z | 2024-01-05T23:56:35.357Z |
2361836 | 2361836 | 20230402205316_0BX2m | AU0007 | 2024-01-05T23:56:35.352Z | 2024-01-05T23:56:35.352Z |
2361825 | 2361825 | 20230402205041_rv2i3 | AU0007 | 2024-01-05T23:56:35.351Z | 2024-01-05T23:56:35.351Z |
2361812 | 2361812 | 20230402204210_Ulv3v | AU0007 | 2024-01-05T23:56:35.350Z | 2024-01-05T23:56:35.350Z |
2361804 | 2361804 | 20230402204120_XKpcr | AU0007 | 2024-01-05T23:56:35.349Z | 2024-01-05T23:56:35.349Z |
2361793 | 2361793 | 20230402203624_HR3zX | AU0007 | 2024-01-05T23:56:35.348Z | 2024-01-05T23:56:35.348Z |
2361755 | 2361755 | 20230402201310_TyX06 | AU0007 | 2024-01-05T23:56:35.344Z | 2024-01-05T23:56:35.344Z |
2361745 | 2361745 | 20230402200559_uvG0l | AU0007 | 2024-01-05T23:56:35.343Z | 2024-01-05T23:56:35.343Z |
2361700 | 2361700 | 20230402194842_mx4yj | AU0007 | 2024-01-05T23:56:35.339Z | 2024-01-05T23:56:35.339Z |
2361678 | 2361678 | 20230402193332_R2RSQ | AU0007 | 2024-01-05T23:56:35.337Z | 2024-01-05T23:56:35.337Z |
2361665 | 2361665 | 20230402192317_yO9aY | AU0007 | 2024-01-05T23:56:35.336Z | 2024-01-05T23:56:35.336Z |
2361638 | 2361638 | 20230402191703_LDcMo | AU0007 | 2024-01-05T23:56:35.334Z | 2024-01-05T23:56:35.334Z |
2361626 | 2361626 | 20230402190454_gdp1b | AU0007 | 2024-01-05T23:56:35.333Z | 2024-01-05T23:56:35.333Z |
2361612 | 2361612 | 20230402185656_m3wVT | AU0007 | 2024-01-05T23:56:35.332Z | 2024-01-05T23:56:35.332Z |
2361596 | 2361596 | 20230402184135_3haUw | AU0007 | 2024-01-05T23:56:35.329Z | 2024-01-05T23:56:35.329Z |
2361575 | 2361575 | 20230402182448_RBgCg | AU0007 | 2024-01-05T23:56:35.327Z | 2024-01-05T23:56:35.327Z |
2361544 | 2361544 | 20230402180458_Vh623 | AU0007 | 2024-01-05T23:56:35.324Z | 2024-01-05T23:56:35.324Z |
2361512 | 2361512 | 20230402174126_x2LML | AU0007 | 2024-01-05T23:56:35.321Z | 2024-01-05T23:56:35.321Z |
2361513 | 2361513 | 20230402174128_Ez4Q0 | AU0007 | 2024-01-05T23:56:35.321Z | 2024-01-05T23:56:35.321Z |
2361413 | 2361413 | 20230402165829_bORXG | AU0007 | 2024-01-05T23:56:35.309Z | 2024-01-05T23:56:35.309Z |
2361373 | 2361373 | 20230402163554_MFlZA | AU0007 | 2024-01-05T23:56:35.305Z | 2024-01-05T23:56:35.305Z |
2361314 | 2361314 | 20230402155931_i0Lh0 | AU0007 | 2024-01-05T23:56:35.298Z | 2024-01-05T23:56:35.298Z |
2361205 | 2361205 | 20230402145142_zYMQM | AU0007 | 2024-01-05T23:56:35.283Z | 2024-01-05T23:56:35.283Z |
2361163 | 2361163 | 20230402134837_N4WjQ | AU0007 | 2024-01-05T23:56:35.278Z | 2024-01-05T23:56:35.278Z |
2361062 | 2361062 | 20230402120205_rzA5y | AU0007 | 2024-01-05T23:56:35.265Z | 2024-01-05T23:56:35.265Z |
2360235 | 2360235 | 20230401203557_DvYBB | AU0007 | 2024-01-05T23:56:34.010Z | 2024-01-05T23:56:34.010Z |
2360223 | 2360223 | 20230401200953_F8BKm | AU0007 | 2024-01-05T23:56:34.009Z | 2024-01-05T23:56:34.009Z |
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);