participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
13,198 rows where station_code = "AU000G" 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 |
---|---|---|---|---|---|
5097120 | 5097120 | 20240912144441_yCVmT | AU000G | 2024-09-16T12:16:45.641Z | 2024-09-16T12:17:32.039Z |
5097012 | 5097012 | 20240912133850_Xn4Ko | AU000G | 2024-09-16T12:16:42.288Z | 2024-09-16T12:17:31.997Z |
5096989 | 5096989 | 20240912132228_bqMqv | AU000G | 2024-09-16T12:16:41.757Z | 2024-09-16T12:17:31.990Z |
5096982 | 5096982 | 20240912132218_jV61T | AU000G | 2024-09-16T12:16:41.477Z | 2024-09-16T12:17:31.988Z |
5096966 | 5096966 | 20240912131246_uwaJa | AU000G | 2024-09-16T12:16:40.842Z | 2024-09-16T12:17:31.982Z |
5096917 | 5096917 | 20240912121926_LXJDZ | AU000G | 2024-09-16T12:16:37.623Z | 2024-09-16T12:17:31.962Z |
5096904 | 5096904 | 20240912120939_NJ1va | AU000G | 2024-09-16T12:16:37.072Z | 2024-09-16T12:17:31.956Z |
5096678 | 5096678 | 20240912112947_o1835 | AU000G | 2024-09-16T12:16:31.422Z | 2024-09-16T12:17:31.849Z |
5085391 | 5085391 | 20240912211831_AUdda | AU000G | 2024-09-16T12:04:12.940Z | 2024-09-16T12:17:04.725Z |
5085311 | 5085311 | 20240912210731_X9IBG | AU000G | 2024-09-16T12:03:56.485Z | 2024-09-16T12:17:04.682Z |
5085241 | 5085241 | 20240912210225_qfvmI | AU000G | 2024-09-16T12:03:47.073Z | 2024-09-16T12:17:04.662Z |
5085190 | 5085190 | 20240912205626_wbg3j | AU000G | 2024-09-16T12:03:40.887Z | 2024-09-16T12:17:04.637Z |
5085098 | 5085098 | 20240912204520_sLpHu | AU000G | 2024-09-16T12:03:31.653Z | 2024-09-16T12:17:04.584Z |
5084877 | 5084877 | 20240912202918_H9jMP | AU000G | 2024-09-16T12:03:07.940Z | 2024-09-16T12:17:04.508Z |
5084874 | 5084874 | 20240912202911_L32D2 | AU000G | 2024-09-16T12:03:07.532Z | 2024-09-16T12:17:04.507Z |
5084588 | 5084588 | 20240912195345_BNGcS | AU000G | 2024-09-16T12:02:35.298Z | 2024-09-16T12:17:04.370Z |
5084578 | 5084578 | 20240912195236_kx3hP | AU000G | 2024-09-16T12:02:31.970Z | 2024-09-16T12:17:04.366Z |
5084548 | 5084548 | 20240912194945_zp60T | AU000G | 2024-09-16T12:02:22.645Z | 2024-09-16T12:17:04.356Z |
5084461 | 5084461 | 20240912194028_9GuSc | AU000G | 2024-09-16T12:02:06.349Z | 2024-09-16T12:17:04.315Z |
5084359 | 5084359 | 20240912192726_IedtR | AU000G | 2024-09-16T12:01:57.019Z | 2024-09-16T12:17:04.265Z |
5084307 | 5084307 | 20240912191433_Qi0NM | AU000G | 2024-09-16T12:01:50.674Z | 2024-09-16T12:17:04.240Z |
5084255 | 5084255 | 20240912190333_ema46 | AU000G | 2024-09-16T12:01:42.582Z | 2024-09-16T12:17:04.205Z |
5084195 | 5084195 | 20240912185402_o7qDT | AU000G | 2024-09-16T12:01:33.432Z | 2024-09-16T12:17:04.170Z |
5084140 | 5084140 | 20240912182900_lNlIW | AU000G | 2024-09-16T12:01:15.147Z | 2024-09-16T12:17:04.117Z |
5084051 | 5084051 | 20240912175408_fKtAf | AU000G | 2024-09-16T12:01:00.660Z | 2024-09-16T12:17:04.064Z |
5084044 | 5084044 | 20240912174749_rmw2p | AU000G | 2024-09-16T12:00:59.502Z | 2024-09-16T12:17:04.059Z |
5084000 | 5084000 | 20240912173228_ssPwE | AU000G | 2024-09-16T12:00:53.693Z | 2024-09-16T12:17:04.024Z |
5083929 | 5083929 | 20240912165151_Xk6S1 | AU000G | 2024-09-16T12:00:40.474Z | 2024-09-16T12:17:03.987Z |
5083893 | 5083893 | 20240912163902_Xs5Q8 | AU000G | 2024-09-16T12:00:36.647Z | 2024-09-16T12:17:03.967Z |
5083852 | 5083852 | 20240912161455_WUj47 | AU000G | 2024-09-16T12:00:31.596Z | 2024-09-16T12:17:03.947Z |
5083836 | 5083836 | 20240912160954_BAouD | AU000G | 2024-09-16T12:00:29.192Z | 2024-09-16T12:17:03.934Z |
5083828 | 5083828 | 20240912160359_r3fYX | AU000G | 2024-09-16T12:00:27.684Z | 2024-09-16T12:17:03.930Z |
5083815 | 5083815 | 20240912155424_liNvU | AU000G | 2024-09-16T12:00:26.239Z | 2024-09-16T12:17:03.923Z |
5083800 | 5083800 | 20240912154434_x4iz0 | AU000G | 2024-09-16T12:00:24.266Z | 2024-09-16T12:17:03.916Z |
5083780 | 5083780 | 20240912152710_WkmdH | AU000G | 2024-09-16T12:00:21.146Z | 2024-09-16T12:17:03.903Z |
5083773 | 5083773 | 20240912152514_LThZO | AU000G | 2024-09-16T12:00:19.240Z | 2024-09-16T12:17:03.895Z |
5083755 | 5083755 | 20240912150857_dfcNX | AU000G | 2024-09-16T12:00:15.870Z | 2024-09-16T12:17:03.875Z |
5083239 | 5083239 | 20240911123538_CymLF | AU000G | 2024-09-15T12:18:37.402Z | 2024-09-16T12:19:17.450Z |
5083113 | 5083113 | 20240911120554_3lWIp | AU000G | 2024-09-15T12:18:35.886Z | 2024-09-16T12:19:16.727Z |
5073598 | 5073598 | 20240911213212_3wUr0 | AU000G | 2024-09-15T12:07:21.448Z | 2024-09-16T12:17:29.262Z |
5073369 | 5073369 | 20240911211729_YWTk7 | AU000G | 2024-09-15T12:07:06.471Z | 2024-09-16T12:17:29.238Z |
5073248 | 5073248 | 20240911210957_ngDX0 | AU000G | 2024-09-15T12:06:58.642Z | 2024-09-16T12:17:29.220Z |
5073221 | 5073221 | 20240911210639_G1Bt4 | AU000G | 2024-09-15T12:06:56.029Z | 2024-09-16T12:17:29.215Z |
5073136 | 5073136 | 20240911210211_2kssA | AU000G | 2024-09-15T12:06:48.765Z | 2024-09-16T12:17:29.201Z |
5073026 | 5073026 | 20240911205307_FrN4M | AU000G | 2024-09-15T12:06:28.734Z | 2024-09-16T12:17:29.187Z |
5072990 | 5072990 | 20240911205133_XeGXg | AU000G | 2024-09-15T12:06:25.213Z | 2024-09-16T12:17:29.182Z |
5072877 | 5072877 | 20240911204503_tiA3r | AU000G | 2024-09-15T12:06:14.893Z | 2024-09-16T12:17:29.165Z |
5072341 | 5072341 | 20240911195624_w520t | AU000G | 2024-09-15T12:05:12.839Z | 2024-09-16T12:17:29.065Z |
5072092 | 5072092 | 20240911193300_w9SH5 | AU000G | 2024-09-15T12:04:38.405Z | 2024-09-16T12:17:29.023Z |
5072024 | 5072024 | 20240911192356_5JVro | AU000G | 2024-09-15T12:04:24.568Z | 2024-09-16T12:17:29.007Z |
5072019 | 5072019 | 20240911192326_RPjgC | AU000G | 2024-09-15T12:04:23.035Z | 2024-09-16T12:17:29.006Z |
5071918 | 5071918 | 20240911190245_81KPK | AU000G | 2024-09-15T12:04:01.165Z | 2024-09-16T12:17:28.978Z |
5071911 | 5071911 | 20240911185710_I9VuS | AU000G | 2024-09-15T12:04:00.376Z | 2024-09-16T12:17:28.977Z |
5071822 | 5071822 | 20240911182925_hBJa2 | AU000G | 2024-09-15T12:03:46.960Z | 2024-09-16T12:17:28.951Z |
5071633 | 5071633 | 20240911173211_apCqf | AU000G | 2024-09-15T12:03:07.456Z | 2024-09-16T12:17:28.881Z |
5071618 | 5071618 | 20240911172957_Xm4be | AU000G | 2024-09-15T12:03:05.375Z | 2024-09-16T12:17:28.878Z |
5071510 | 5071510 | 20240911170945_A9HWi | AU000G | 2024-09-15T12:02:44.869Z | 2024-09-16T12:17:28.850Z |
5071396 | 5071396 | 20240911164556_yZ7Nj | AU000G | 2024-09-15T12:02:27.190Z | 2024-09-16T12:17:28.801Z |
5071386 | 5071386 | 20240911164507_P7KLz | AU000G | 2024-09-15T12:02:25.855Z | 2024-09-16T12:17:28.798Z |
5071382 | 5071382 | 20240911164503_x6ozK | AU000G | 2024-09-15T12:02:25.392Z | 2024-09-16T12:17:28.798Z |
5071295 | 5071295 | 20240911163014_jEswr | AU000G | 2024-09-15T12:02:11.806Z | 2024-09-16T12:17:28.779Z |
5071292 | 5071292 | 20240911162959_BvMHF | AU000G | 2024-09-15T12:02:11.204Z | 2024-09-16T12:17:28.778Z |
5071241 | 5071241 | 20240911162125_Q55rB | AU000G | 2024-09-15T12:02:00.110Z | 2024-09-16T12:17:28.766Z |
5071117 | 5071117 | 20240911160142_fjFHX | AU000G | 2024-09-15T12:01:44.320Z | 2024-09-16T12:17:28.740Z |
5070987 | 5070987 | 20240911153904_23PzJ | AU000G | 2024-09-15T12:01:18.750Z | 2024-09-16T12:17:28.707Z |
5070970 | 5070970 | 20240911153623_kKJdz | AU000G | 2024-09-15T12:01:16.614Z | 2024-09-16T12:17:28.703Z |
5070773 | 5070773 | 20240911151032_R1EtO | AU000G | 2024-09-15T12:00:47.640Z | 2024-09-16T12:17:28.663Z |
5070471 | 5070471 | 20240909125821_QQqd3 | AU000G | 2024-09-14T12:21:21.990Z | 2024-09-16T12:20:45.831Z |
5062816 | 5062816 | 20240909183140_5Xm2k | AU000G | 2024-09-14T12:12:53.976Z | 2024-09-16T12:19:39.654Z |
5062791 | 5062791 | 20240909182521_fsAyr | AU000G | 2024-09-14T12:12:51.898Z | 2024-09-16T12:19:39.600Z |
5062686 | 5062686 | 20240909180035_NY2kI | AU000G | 2024-09-14T12:12:43.059Z | 2024-09-16T12:19:38.790Z |
5062448 | 5062448 | 20240909172708_XkQzw | AU000G | 2024-09-14T12:12:23.003Z | 2024-09-16T12:19:37.441Z |
5062378 | 5062378 | 20240909171702_tRN8p | AU000G | 2024-09-14T12:12:14.991Z | 2024-09-16T12:19:37.126Z |
5061769 | 5061769 | 20240909155712_ktS9F | AU000G | 2024-09-14T12:11:23.245Z | 2024-09-16T12:19:33.827Z |
5061744 | 5061744 | 20240909154951_XL0IV | AU000G | 2024-09-14T12:11:18.439Z | 2024-09-16T12:19:33.459Z |
5061742 | 5061742 | 20240909154949_0Ur35 | AU000G | 2024-09-14T12:11:18.233Z | 2024-09-16T12:19:33.291Z |
5061521 | 5061521 | 20240909151920_1Y90n | AU000G | 2024-09-14T12:10:55.195Z | 2024-09-16T12:19:32.036Z |
5061486 | 5061486 | 20240909151403_mNmqS | AU000G | 2024-09-14T12:10:52.630Z | 2024-09-16T12:19:31.762Z |
5061478 | 5061478 | 20240909151217_T7M2e | AU000G | 2024-09-14T12:10:52.267Z | 2024-09-16T12:19:31.749Z |
5061308 | 5061308 | 20240909144434_6Axzc | AU000G | 2024-09-14T12:10:41.198Z | 2024-09-16T12:19:30.457Z |
5061300 | 5061300 | 20240909144323_HJXYK | AU000G | 2024-09-14T12:10:40.846Z | 2024-09-16T12:19:30.411Z |
5061248 | 5061248 | 20240909143747_052Hx | AU000G | 2024-09-14T12:10:37.508Z | 2024-09-16T12:19:29.938Z |
5061207 | 5061207 | 20240909143323_SJcqp | AU000G | 2024-09-14T12:10:34.909Z | 2024-09-16T12:19:29.870Z |
5061162 | 5061162 | 20240909142357_3F0i5 | AU000G | 2024-09-14T12:10:24.060Z | 2024-09-16T12:19:29.444Z |
5061024 | 5061024 | 20240909135338_2QIZI | AU000G | 2024-09-14T12:10:06.689Z | 2024-09-16T12:19:28.668Z |
5060825 | 5060825 | 20240910212157_m71zn | AU000G | 2024-09-14T12:09:38.669Z | 2024-09-16T12:18:20.262Z |
5060823 | 5060823 | 20240910211858_kn1kz | AU000G | 2024-09-14T12:09:38.338Z | 2024-09-16T12:18:20.141Z |
5060659 | 5060659 | 20240910204959_OgPXH | AU000G | 2024-09-14T12:09:19.061Z | 2024-09-16T12:18:17.321Z |
5060230 | 5060230 | 20240910200850_yrEQa | AU000G | 2024-09-14T12:08:30.469Z | 2024-09-16T12:18:14.000Z |
5060167 | 5060167 | 20240910200042_Jn8AP | AU000G | 2024-09-14T12:08:25.893Z | 2024-09-16T12:18:13.773Z |
5059894 | 5059894 | 20240910191500_EAncF | AU000G | 2024-09-14T12:07:34.155Z | 2024-09-16T12:18:09.914Z |
5059825 | 5059825 | 20240910190041_bLwex | AU000G | 2024-09-14T12:07:21.145Z | 2024-09-16T12:18:09.057Z |
5059714 | 5059714 | 20240910183503_3KeTu | AU000G | 2024-09-14T12:06:50.544Z | 2024-09-16T12:18:07.812Z |
5059699 | 5059699 | 20240910183342_ojwup | AU000G | 2024-09-14T12:06:47.533Z | 2024-09-16T12:18:07.713Z |
5059677 | 5059677 | 20240910182947_xGKaA | AU000G | 2024-09-14T12:06:44.512Z | 2024-09-16T12:18:07.459Z |
5059596 | 5059596 | 20240910181519_KFfTc | AU000G | 2024-09-14T12:06:33.551Z | 2024-09-16T12:18:06.438Z |
5059510 | 5059510 | 20240910175430_4eu3l | AU000G | 2024-09-14T12:06:14.888Z | 2024-09-16T12:18:05.601Z |
5059380 | 5059380 | 20240910173528_OLilH | AU000G | 2024-09-14T12:05:49.688Z | 2024-09-16T12:18:04.273Z |
5059329 | 5059329 | 20240910173159_nR9rA | AU000G | 2024-09-14T12:05:45.884Z | 2024-09-16T12:18:03.997Z |
5059251 | 5059251 | 20240910172629_3i2uE | AU000G | 2024-09-14T12:05:31.516Z | 2024-09-16T12:18:03.072Z |
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);