participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,029 rows where station_code = "AU003H" 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 |
---|---|---|---|---|---|
5097123 | 5097123 | 20240912144441_yCVmT | AU003H | 2024-09-16T12:16:45.641Z | 2024-09-16T12:17:32.039Z |
5097041 | 5097041 | 20240912140100_H6192 | AU003H | 2024-09-16T12:16:43.194Z | 2024-09-16T12:17:32.009Z |
5097024 | 5097024 | 20240912134720_kGw5p | AU003H | 2024-09-16T12:16:42.516Z | 2024-09-16T12:17:32.002Z |
5097015 | 5097015 | 20240912133850_Xn4Ko | AU003H | 2024-09-16T12:16:42.288Z | 2024-09-16T12:17:31.997Z |
5096993 | 5096993 | 20240912132228_bqMqv | AU003H | 2024-09-16T12:16:41.757Z | 2024-09-16T12:17:31.990Z |
5096906 | 5096906 | 20240912120939_NJ1va | AU003H | 2024-09-16T12:16:37.072Z | 2024-09-16T12:17:31.956Z |
5096682 | 5096682 | 20240912112947_o1835 | AU003H | 2024-09-16T12:16:31.422Z | 2024-09-16T12:17:31.849Z |
5085197 | 5085197 | 20240912205659_4LVrx | AU003H | 2024-09-16T12:03:41.942Z | 2024-09-16T12:17:04.640Z |
5085192 | 5085192 | 20240912205626_wbg3j | AU003H | 2024-09-16T12:03:40.887Z | 2024-09-16T12:17:04.637Z |
5085111 | 5085111 | 20240912204642_2UXEC | AU003H | 2024-09-16T12:03:33.047Z | 2024-09-16T12:17:04.590Z |
5085100 | 5085100 | 20240912204520_sLpHu | AU003H | 2024-09-16T12:03:31.653Z | 2024-09-16T12:17:04.584Z |
5084881 | 5084881 | 20240912202918_H9jMP | AU003H | 2024-09-16T12:03:07.940Z | 2024-09-16T12:17:04.508Z |
5084660 | 5084660 | 20240912200141_hapEJ | AU003H | 2024-09-16T12:02:44.311Z | 2024-09-16T12:17:04.408Z |
5084618 | 5084618 | 20240912195709_n2XmW | AU003H | 2024-09-16T12:02:39.247Z | 2024-09-16T12:17:04.391Z |
5084592 | 5084592 | 20240912195345_BNGcS | AU003H | 2024-09-16T12:02:35.298Z | 2024-09-16T12:17:04.370Z |
5084422 | 5084422 | 20240912193712_1Xx3V | AU003H | 2024-09-16T12:02:03.650Z | 2024-09-16T12:17:04.299Z |
5084355 | 5084355 | 20240912192632_eATSL | AU003H | 2024-09-16T12:01:56.255Z | 2024-09-16T12:17:04.262Z |
5084309 | 5084309 | 20240912191433_Qi0NM | AU003H | 2024-09-16T12:01:50.674Z | 2024-09-16T12:17:04.240Z |
5084258 | 5084258 | 20240912190333_ema46 | AU003H | 2024-09-16T12:01:42.582Z | 2024-09-16T12:17:04.205Z |
5084240 | 5084240 | 20240912190208_efzHY | AU003H | 2024-09-16T12:01:38.333Z | 2024-09-16T12:17:04.196Z |
5084216 | 5084216 | 20240912185914_cy1FI | AU003H | 2024-09-16T12:01:35.492Z | 2024-09-16T12:17:04.184Z |
5084142 | 5084142 | 20240912182900_lNlIW | AU003H | 2024-09-16T12:01:15.147Z | 2024-09-16T12:17:04.117Z |
5084111 | 5084111 | 20240912181420_FEIbw | AU003H | 2024-09-16T12:01:10.628Z | 2024-09-16T12:17:04.101Z |
5084001 | 5084001 | 20240912173228_ssPwE | AU003H | 2024-09-16T12:00:53.693Z | 2024-09-16T12:17:04.024Z |
5083930 | 5083930 | 20240912165151_Xk6S1 | AU003H | 2024-09-16T12:00:40.474Z | 2024-09-16T12:17:03.987Z |
5083918 | 5083918 | 20240912164339_pYSqV | AU003H | 2024-09-16T12:00:38.767Z | 2024-09-16T12:17:03.975Z |
5083912 | 5083912 | 20240912164102_mkZ1Z | AU003H | 2024-09-16T12:00:38.006Z | 2024-09-16T12:17:03.972Z |
5083817 | 5083817 | 20240912155424_liNvU | AU003H | 2024-09-16T12:00:26.250Z | 2024-09-16T12:17:03.923Z |
5083803 | 5083803 | 20240912154434_x4iz0 | AU003H | 2024-09-16T12:00:24.266Z | 2024-09-16T12:17:03.916Z |
5083782 | 5083782 | 20240912152710_WkmdH | AU003H | 2024-09-16T12:00:21.146Z | 2024-09-16T12:17:03.903Z |
5083156 | 5083156 | 20240911121526_czfOD | AU003H | 2024-09-15T12:18:36.235Z | 2024-09-16T12:19:16.943Z |
5082876 | 5082876 | 20240911111802_LD30M | AU003H | 2024-09-15T12:18:28.493Z | 2024-09-16T12:19:15.323Z |
5073423 | 5073423 | 20240911212255_3WlFK | AU003H | 2024-09-15T12:07:09.498Z | 2024-09-16T12:17:29.244Z |
5073373 | 5073373 | 20240911211729_YWTk7 | AU003H | 2024-09-15T12:07:06.471Z | 2024-09-16T12:17:29.238Z |
5073310 | 5073310 | 20240911211437_FHOEY | AU003H | 2024-09-15T12:07:02.921Z | 2024-09-16T12:17:29.229Z |
5073218 | 5073218 | 20240911210613_n5maE | AU003H | 2024-09-15T12:06:55.406Z | 2024-09-16T12:17:29.214Z |
5072626 | 5072626 | 20240911203015_xq43E | AU003H | 2024-09-15T12:05:51.523Z | 2024-09-16T12:17:29.122Z |
5072563 | 5072563 | 20240911202339_SHxg3 | AU003H | 2024-09-15T12:05:38.103Z | 2024-09-16T12:17:29.110Z |
5072506 | 5072506 | 20240911201628_07yOB | AU003H | 2024-09-15T12:05:31.295Z | 2024-09-16T12:17:29.099Z |
5072441 | 5072441 | 20240911201005_LOCV7 | AU003H | 2024-09-15T12:05:23.263Z | 2024-09-16T12:17:29.085Z |
5072360 | 5072360 | 20240911195836_9cBDA | AU003H | 2024-09-15T12:05:14.712Z | 2024-09-16T12:17:29.068Z |
5072344 | 5072344 | 20240911195624_w520t | AU003H | 2024-09-15T12:05:12.839Z | 2024-09-16T12:17:29.065Z |
5072094 | 5072094 | 20240911193300_w9SH5 | AU003H | 2024-09-15T12:04:38.405Z | 2024-09-16T12:17:29.023Z |
5072056 | 5072056 | 20240911192708_yWXM9 | AU003H | 2024-09-15T12:04:33.163Z | 2024-09-16T12:17:29.013Z |
5072049 | 5072049 | 20240911192703_qYSIo | AU003H | 2024-09-15T12:04:32.234Z | 2024-09-16T12:17:29.012Z |
5072027 | 5072027 | 20240911192356_5JVro | AU003H | 2024-09-15T12:04:24.568Z | 2024-09-16T12:17:29.007Z |
5072021 | 5072021 | 20240911192326_RPjgC | AU003H | 2024-09-15T12:04:23.035Z | 2024-09-16T12:17:29.006Z |
5071996 | 5071996 | 20240911191749_D6zIF | AU003H | 2024-09-15T12:04:15.421Z | 2024-09-16T12:17:28.999Z |
5071977 | 5071977 | 20240911191355_dpvY7 | AU003H | 2024-09-15T12:04:10.836Z | 2024-09-16T12:17:28.994Z |
5071919 | 5071919 | 20240911190245_81KPK | AU003H | 2024-09-15T12:04:01.166Z | 2024-09-16T12:17:28.978Z |
5071832 | 5071832 | 20240911183227_HWxQz | AU003H | 2024-09-15T12:03:47.930Z | 2024-09-16T12:17:28.953Z |
5071826 | 5071826 | 20240911182945_OW4Mp | AU003H | 2024-09-15T12:03:47.378Z | 2024-09-16T12:17:28.951Z |
5071773 | 5071773 | 20240911181504_eOV0U | AU003H | 2024-09-15T12:03:29.561Z | 2024-09-16T12:17:28.936Z |
5071746 | 5071746 | 20240911181019_0dZNS | AU003H | 2024-09-15T12:03:23.515Z | 2024-09-16T12:17:28.919Z |
5071705 | 5071705 | 20240911175525_PjHEK | AU003H | 2024-09-15T12:03:17.418Z | 2024-09-16T12:17:28.900Z |
5071702 | 5071702 | 20240911175431_Ocphq | AU003H | 2024-09-15T12:03:17.069Z | 2024-09-16T12:17:28.900Z |
5071658 | 5071658 | 20240911173703_WZGHT | AU003H | 2024-09-15T12:03:11.275Z | 2024-09-16T12:17:28.889Z |
5071638 | 5071638 | 20240911173309_7Xasu | AU003H | 2024-09-15T12:03:08.308Z | 2024-09-16T12:17:28.883Z |
5071634 | 5071634 | 20240911173211_apCqf | AU003H | 2024-09-15T12:03:07.456Z | 2024-09-16T12:17:28.881Z |
5071384 | 5071384 | 20240911164503_x6ozK | AU003H | 2024-09-15T12:02:25.392Z | 2024-09-16T12:17:28.798Z |
5071299 | 5071299 | 20240911163014_jEswr | AU003H | 2024-09-15T12:02:11.806Z | 2024-09-16T12:17:28.779Z |
5071265 | 5071265 | 20240911162332_MGOie | AU003H | 2024-09-15T12:02:04.992Z | 2024-09-16T12:17:28.772Z |
5071223 | 5071223 | 20240911161746_rS5V0 | AU003H | 2024-09-15T12:01:57.187Z | 2024-09-16T12:17:28.761Z |
5071136 | 5071136 | 20240911160243_c0hKK | AU003H | 2024-09-15T12:01:45.631Z | 2024-09-16T12:17:28.743Z |
5071119 | 5071119 | 20240911160142_fjFHX | AU003H | 2024-09-15T12:01:44.320Z | 2024-09-16T12:17:28.740Z |
5070973 | 5070973 | 20240911153623_kKJdz | AU003H | 2024-09-15T12:01:16.672Z | 2024-09-16T12:17:28.703Z |
5070968 | 5070968 | 20240911153611_6HzsZ | AU003H | 2024-09-15T12:01:15.565Z | 2024-09-16T12:17:28.702Z |
5070777 | 5070777 | 20240911151032_R1EtO | AU003H | 2024-09-15T12:00:47.672Z | 2024-09-16T12:17:28.663Z |
5070473 | 5070473 | 20240909125821_QQqd3 | AU003H | 2024-09-14T12:21:21.990Z | 2024-09-16T12:20:45.831Z |
5068853 | 5068853 | 20240910124838_jDopk | AU003H | 2024-09-14T12:19:22.140Z | 2024-09-16T12:20:15.452Z |
5068772 | 5068772 | 20240910122127_NqXe3 | AU003H | 2024-09-14T12:19:21.198Z | 2024-09-16T12:20:14.994Z |
5068329 | 5068329 | 20240910112053_xMyxt | AU003H | 2024-09-14T12:19:12.272Z | 2024-09-16T12:20:13.477Z |
5063141 | 5063141 | 20240909200329_8FouI | AU003H | 2024-09-14T12:13:34.122Z | 2024-09-16T12:19:42.235Z |
5062937 | 5062937 | 20240909191533_YKNup | AU003H | 2024-09-14T12:13:05.497Z | 2024-09-16T12:19:40.486Z |
5062890 | 5062890 | 20240909185426_x4jpR | AU003H | 2024-09-14T12:13:01.048Z | 2024-09-16T12:19:39.997Z |
5062819 | 5062819 | 20240909183140_5Xm2k | AU003H | 2024-09-14T12:12:53.977Z | 2024-09-16T12:19:39.654Z |
5062779 | 5062779 | 20240909182319_su3a5 | AU003H | 2024-09-14T12:12:50.306Z | 2024-09-16T12:19:39.560Z |
5062598 | 5062598 | 20240909174501_Dkoib | AU003H | 2024-09-14T12:12:35.849Z | 2024-09-16T12:19:37.985Z |
5062513 | 5062513 | 20240909173426_RGk35 | AU003H | 2024-09-14T12:12:30.331Z | 2024-09-16T12:19:37.635Z |
5062450 | 5062450 | 20240909172708_XkQzw | AU003H | 2024-09-14T12:12:23.003Z | 2024-09-16T12:19:37.441Z |
5062379 | 5062379 | 20240909171702_tRN8p | AU003H | 2024-09-14T12:12:14.991Z | 2024-09-16T12:19:37.126Z |
5062376 | 5062376 | 20240909171655_L6qJw | AU003H | 2024-09-14T12:12:14.467Z | 2024-09-16T12:19:37.125Z |
5061888 | 5061888 | 20240909161820_957zu | AU003H | 2024-09-14T12:11:35.906Z | 2024-09-16T12:19:34.452Z |
5061873 | 5061873 | 20240909161617_BzjHz | AU003H | 2024-09-14T12:11:34.785Z | 2024-09-16T12:19:34.416Z |
5061743 | 5061743 | 20240909154949_0Ur35 | AU003H | 2024-09-14T12:11:18.233Z | 2024-09-16T12:19:33.291Z |
5061665 | 5061665 | 20240909153858_MOMYk | AU003H | 2024-09-14T12:11:08.327Z | 2024-09-16T12:19:32.963Z |
5061540 | 5061540 | 20240909152146_DCu5L | AU003H | 2024-09-14T12:10:56.710Z | 2024-09-16T12:19:32.072Z |
5061522 | 5061522 | 20240909151920_1Y90n | AU003H | 2024-09-14T12:10:55.195Z | 2024-09-16T12:19:32.036Z |
5061481 | 5061481 | 20240909151217_T7M2e | AU003H | 2024-09-14T12:10:52.267Z | 2024-09-16T12:19:31.749Z |
5061309 | 5061309 | 20240909144434_6Axzc | AU003H | 2024-09-14T12:10:41.199Z | 2024-09-16T12:19:30.457Z |
5061304 | 5061304 | 20240909144323_HJXYK | AU003H | 2024-09-14T12:10:40.846Z | 2024-09-16T12:19:30.411Z |
5061289 | 5061289 | 20240909144150_LOaOG | AU003H | 2024-09-14T12:10:40.203Z | 2024-09-16T12:19:30.308Z |
5061283 | 5061283 | 20240909144037_HZvP7 | AU003H | 2024-09-14T12:10:39.970Z | 2024-09-16T12:19:30.291Z |
5061249 | 5061249 | 20240909143747_052Hx | AU003H | 2024-09-14T12:10:37.508Z | 2024-09-16T12:19:29.938Z |
5061209 | 5061209 | 20240909143323_SJcqp | AU003H | 2024-09-14T12:10:34.909Z | 2024-09-16T12:19:29.870Z |
5061200 | 5061200 | 20240909143149_hN1SS | AU003H | 2024-09-14T12:10:34.024Z | 2024-09-16T12:19:29.723Z |
5061165 | 5061165 | 20240909142357_3F0i5 | AU003H | 2024-09-14T12:10:24.061Z | 2024-09-16T12:19:29.444Z |
5061160 | 5061160 | 20240909142351_Tt80d | AU003H | 2024-09-14T12:10:23.740Z | 2024-09-16T12:19:29.436Z |
5061091 | 5061091 | 20240909141417_7vvf0 | AU003H | 2024-09-14T12:10:15.191Z | 2024-09-16T12:19:29.284Z |
5060829 | 5060829 | 20240910212437_8m7Xa | AU003H | 2024-09-14T12:09:39.168Z | 2024-09-16T12:18:20.586Z |
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);