participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,565 rows where station_code = "NZ003B" 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 |
---|---|---|---|---|---|
5083743 | 5083743 | 20240911141627_g1s8M | NZ003B | 2024-09-15T12:18:45.866Z | 2024-09-16T12:19:20.413Z |
5083715 | 5083715 | 20240911141336_KuVeU | NZ003B | 2024-09-15T12:18:45.673Z | 2024-09-16T12:19:20.189Z |
5083595 | 5083595 | 20240911135430_wkMtK | NZ003B | 2024-09-15T12:18:44.346Z | 2024-09-16T12:19:19.693Z |
5083439 | 5083439 | 20240911131802_FVRd6 | NZ003B | 2024-09-15T12:18:41.964Z | 2024-09-16T12:19:18.542Z |
5083284 | 5083284 | 20240911124444_r4uGk | NZ003B | 2024-09-15T12:18:38.206Z | 2024-09-16T12:19:17.703Z |
5071508 | 5071508 | 20240911170913_2K413 | NZ003B | 2024-09-15T12:02:44.176Z | 2024-09-16T12:17:28.849Z |
5071357 | 5071357 | 20240911163814_wzfhv | NZ003B | 2024-09-15T12:02:21.578Z | 2024-09-16T12:17:28.791Z |
5071311 | 5071311 | 20240911163148_YH8LX | NZ003B | 2024-09-15T12:02:15.924Z | 2024-09-16T12:17:28.781Z |
5071045 | 5071045 | 20240911154953_6u9pq | NZ003B | 2024-09-15T12:01:29.356Z | 2024-09-16T12:17:28.719Z |
5070889 | 5070889 | 20240911152436_xZhJ2 | NZ003B | 2024-09-15T12:01:04.615Z | 2024-09-16T12:17:28.682Z |
5070830 | 5070830 | 20240911151437_mKQkH | NZ003B | 2024-09-15T12:00:58.175Z | 2024-09-16T12:17:28.672Z |
5070812 | 5070812 | 20240911151204_0YjdS | NZ003B | 2024-09-15T12:00:55.431Z | 2024-09-16T12:17:28.667Z |
5070751 | 5070751 | 20240911150603_c8UZj | NZ003B | 2024-09-15T12:00:45.542Z | 2024-09-16T12:17:28.659Z |
5068111 | 5068111 | 20240910105718_2HpWP | NZ003B | 2024-09-14T12:19:09.109Z | 2024-09-16T12:20:12.912Z |
5066486 | 5066486 | 20240910073917_Q2v2M | NZ003B | 2024-09-14T12:17:58.745Z | 2024-09-16T12:20:03.199Z |
5062453 | 5062453 | 20240909172725_llDCS | NZ003B | 2024-09-14T12:12:23.379Z | 2024-09-16T12:19:37.445Z |
5062222 | 5062222 | 20240909170009_DGW7P | NZ003B | 2024-09-14T12:11:56.619Z | 2024-09-16T12:19:36.554Z |
5061932 | 5061932 | 20240909162408_zWDFm | NZ003B | 2024-09-14T12:11:39.453Z | 2024-09-16T12:19:34.701Z |
5061806 | 5061806 | 20240909160124_yWvqV | NZ003B | 2024-09-14T12:11:26.770Z | 2024-09-16T12:19:33.894Z |
5058658 | 5058658 | 20240910163412_Q7P2s | NZ003B | 2024-09-14T12:04:16.250Z | 2024-09-16T12:17:56.866Z |
5058541 | 5058541 | 20240910162224_utpS2 | NZ003B | 2024-09-14T12:03:54.111Z | 2024-09-16T12:17:55.859Z |
5058443 | 5058443 | 20240910161221_EMs8u | NZ003B | 2024-09-14T12:03:42.568Z | 2024-09-16T12:17:54.447Z |
5057772 | 5057772 | 20240910151140_sftbd | NZ003B | 2024-09-14T12:01:55.731Z | 2024-09-16T12:17:47.304Z |
5056970 | 5056970 | 20240908114800_oecu7 | NZ003B | 2024-09-13T12:17:42.128Z | 2024-09-16T12:21:28.166Z |
5056881 | 5056881 | 20240908113524_DPVB3 | NZ003B | 2024-09-13T12:17:40.410Z | 2024-09-16T12:21:27.636Z |
5056718 | 5056718 | 20240908111232_QzsXE | NZ003B | 2024-09-13T12:17:38.383Z | 2024-09-16T12:21:26.836Z |
5056560 | 5056560 | 20240908104112_d2HQh | NZ003B | 2024-09-13T12:17:34.958Z | 2024-09-16T12:21:25.884Z |
5056302 | 5056302 | 20240908100742_Kkb2V | NZ003B | 2024-09-13T12:17:29.679Z | 2024-09-16T12:21:24.209Z |
5056096 | 5056096 | 20240908094041_f52Zg | NZ003B | 2024-09-13T12:17:27.440Z | 2024-09-16T12:21:23.289Z |
5055900 | 5055900 | 20240908091524_bZElQ | NZ003B | 2024-09-13T12:17:25.358Z | 2024-09-16T12:21:22.551Z |
5051523 | 5051523 | 20240907173848_U1zfH | NZ003B | 2024-09-13T12:14:21.559Z | 2024-09-16T12:21:01.136Z |
5051339 | 5051339 | 20240907171743_GeRQu | NZ003B | 2024-09-13T12:14:11.399Z | 2024-09-16T12:21:00.142Z |
5051201 | 5051201 | 20240907165815_XAB9g | NZ003B | 2024-09-13T12:14:05.853Z | 2024-09-16T12:20:59.796Z |
5051168 | 5051168 | 20240907165648_D8zvQ | NZ003B | 2024-09-13T12:14:04.832Z | 2024-09-16T12:20:59.760Z |
5050985 | 5050985 | 20240907163012_dZ5tG | NZ003B | 2024-09-13T12:13:55.544Z | 2024-09-16T12:20:59.421Z |
5050788 | 5050788 | 20240907160709_WRxVP | NZ003B | 2024-09-13T12:13:46.618Z | 2024-09-16T12:20:58.510Z |
5050560 | 5050560 | 20240907153930_OICgI | NZ003B | 2024-09-13T12:13:36.773Z | 2024-09-16T12:20:58.007Z |
5050550 | 5050550 | 20240907153829_fiGBU | NZ003B | 2024-09-13T12:13:36.449Z | 2024-09-16T12:20:57.988Z |
5050145 | 5050145 | 20240907143835_Xbh9P | NZ003B | 2024-09-13T12:13:11.735Z | 2024-09-16T12:20:56.427Z |
5045021 | 5045021 | 20240908160746_gURlE | NZ003B | 2024-09-13T12:03:24.601Z | 2024-09-16T12:20:24.137Z |
5044963 | 5044963 | 20240908155945_LY2ac | NZ003B | 2024-09-13T12:03:17.904Z | 2024-09-16T12:20:23.936Z |
5044650 | 5044650 | 20240908152628_WI7je | NZ003B | 2024-09-13T12:02:40.411Z | 2024-09-16T12:20:22.910Z |
5043232 | 5043232 | 20240907141014_3V1ZM | NZ003B | 2024-09-12T12:17:25.449Z | 2024-09-16T12:20:55.936Z |
5043168 | 5043168 | 20240907140018_fzjyf | NZ003B | 2024-09-12T12:17:24.288Z | 2024-09-16T12:20:55.701Z |
5043140 | 5043140 | 20240907135645_u3Mxy | NZ003B | 2024-09-12T12:17:23.856Z | 2024-09-16T12:20:55.581Z |
5042817 | 5042817 | 20240907125349_Pn2aO | NZ003B | 2024-09-12T12:17:18.596Z | 2024-09-16T12:20:54.424Z |
5042351 | 5042351 | 20240906104141_lgJ37 | NZ003B | 2024-09-12T12:17:01.269Z | 2024-09-14T12:23:16.981Z |
5042178 | 5042178 | 20240906100613_5ZOch | NZ003B | 2024-09-12T12:16:56.679Z | 2024-09-14T12:23:16.372Z |
5042099 | 5042099 | 20240906095313_x3YDv | NZ003B | 2024-09-12T12:16:55.460Z | 2024-09-14T12:23:16.008Z |
5038195 | 5038195 | 20240905174036_uBkpk | NZ003B | 2024-09-12T12:14:25.463Z | 2024-09-14T12:22:55.255Z |
5038025 | 5038025 | 20240905171607_hQNel | NZ003B | 2024-09-12T12:14:20.226Z | 2024-09-14T12:22:54.922Z |
5037819 | 5037819 | 20240905165334_DFdok | NZ003B | 2024-09-12T12:14:15.738Z | 2024-09-14T12:22:54.644Z |
5037656 | 5037656 | 20240905162910_1sz6D | NZ003B | 2024-09-12T12:14:13.429Z | 2024-09-14T12:22:54.484Z |
5037496 | 5037496 | 20240905160123_LZecp | NZ003B | 2024-09-12T12:14:07.487Z | 2024-09-14T12:22:54.230Z |
5037368 | 5037368 | 20240905154656_QMWJn | NZ003B | 2024-09-12T12:14:05.695Z | 2024-09-14T12:22:54.149Z |
5037298 | 5037298 | 20240905153359_CEvNQ | NZ003B | 2024-09-12T12:14:04.528Z | 2024-09-14T12:22:54.084Z |
5037180 | 5037180 | 20240905151840_oNnHl | NZ003B | 2024-09-12T12:14:02.550Z | 2024-09-14T12:22:53.852Z |
5037091 | 5037091 | 20240905150509_bZwQN | NZ003B | 2024-09-12T12:14:00.786Z | 2024-09-14T12:22:53.702Z |
5037001 | 5037001 | 20240905145325_n1xAb | NZ003B | 2024-09-12T12:13:58.935Z | 2024-09-14T12:22:53.617Z |
5036942 | 5036942 | 20240905144640_gXHII | NZ003B | 2024-09-12T12:13:57.807Z | 2024-09-14T12:22:53.551Z |
5036922 | 5036922 | 20240905144503_0YBHF | NZ003B | 2024-09-12T12:13:57.476Z | 2024-09-14T12:22:53.543Z |
5036684 | 5036684 | 20240905141419_I2snR | NZ003B | 2024-09-12T12:13:51.998Z | 2024-09-14T12:22:53.093Z |
5036650 | 5036650 | 20240905141252_Ag5fU | NZ003B | 2024-09-12T12:13:51.361Z | 2024-09-14T12:22:53.078Z |
5036478 | 5036478 | 20240905133806_ptoJX | NZ003B | 2024-09-12T12:13:43.340Z | 2024-09-14T12:22:52.485Z |
5036392 | 5036392 | 20240905132306_MwBrk | NZ003B | 2024-09-12T12:13:38.860Z | 2024-09-14T12:22:52.395Z |
5036379 | 5036379 | 20240905132132_LeQvI | NZ003B | 2024-09-12T12:13:38.294Z | 2024-09-14T12:22:52.381Z |
5036198 | 5036198 | 20240905125457_Tl4X3 | NZ003B | 2024-09-12T12:13:28.450Z | 2024-09-14T12:22:51.990Z |
5029767 | 5029767 | 20240906112326_IOn6J | NZ003B | 2024-09-12T12:00:29.474Z | 2024-09-15T12:21:17.124Z |
5029669 | 5029669 | 20240906110224_Namn6 | NZ003B | 2024-09-12T12:00:17.600Z | 2024-09-15T12:21:16.849Z |
5029311 | 5029311 | 20240905115427_FoNwk | NZ003B | 2024-09-11T12:16:26.021Z | 2024-09-14T12:22:51.375Z |
5029255 | 5029255 | 20240905114539_B7Rxl | NZ003B | 2024-09-11T12:16:20.809Z | 2024-09-14T12:22:51.302Z |
5028589 | 5028589 | 20240905102421_qgNVd | NZ003B | 2024-09-11T12:15:36.138Z | 2024-09-14T12:22:48.400Z |
5028581 | 5028581 | 20240905102358_Kc0kF | NZ003B | 2024-09-11T12:15:35.735Z | 2024-09-14T12:22:48.375Z |
5028203 | 5028203 | 20240905091329_bes5d | NZ003B | 2024-09-11T12:15:00.244Z | 2024-09-13T12:20:05.740Z |
5028198 | 5028198 | 20240905091221_pfa2Z | NZ003B | 2024-09-11T12:14:59.873Z | 2024-09-13T12:20:05.737Z |
5027909 | 5027909 | 20240905083731_uK80x | NZ003B | 2024-09-11T12:14:38.179Z | 2024-09-13T12:20:05.008Z |
5024011 | 5024011 | 20240905174036_UuoYh | NZ003B | 2024-09-11T12:02:17.835Z | 2024-09-11T12:16:31.885Z |
5023866 | 5023866 | 20240905171607_djKNu | NZ003B | 2024-09-10T12:16:51.168Z | 2024-09-11T12:16:31.821Z |
5023666 | 5023666 | 20240905165334_5aiF7 | NZ003B | 2024-09-10T12:16:48.963Z | 2024-09-11T12:16:31.737Z |
5023514 | 5023514 | 20240905162910_TlhAJ | NZ003B | 2024-09-10T12:16:46.887Z | 2024-09-11T12:16:31.687Z |
5023371 | 5023371 | 20240905160123_l8nQW | NZ003B | 2024-09-10T12:16:43.977Z | 2024-09-11T12:16:31.636Z |
5023251 | 5023251 | 20240905154656_W2zT6 | NZ003B | 2024-09-10T12:16:41.195Z | 2024-09-11T12:16:31.600Z |
5023179 | 5023179 | 20240905153359_3C64P | NZ003B | 2024-09-10T12:16:40.133Z | 2024-09-11T12:16:31.565Z |
5023068 | 5023068 | 20240905151840_3CRAt | NZ003B | 2024-09-10T12:16:38.549Z | 2024-09-11T12:16:31.520Z |
5022639 | 5022639 | 20240905091329_r2f7S | NZ003B | 2024-09-10T12:16:25.713Z | 2024-09-10T12:16:55.587Z |
5022634 | 5022634 | 20240905091221_cOGkL | NZ003B | 2024-09-10T12:16:25.539Z | 2024-09-13T12:20:05.739Z |
5022354 | 5022354 | 20240905083731_Ek2La | NZ003B | 2024-09-10T12:16:15.862Z | 2024-09-13T12:20:05.010Z |
5018325 | 5018325 | 20240904174146_pmZ3i | NZ003B | 2024-09-10T12:10:27.986Z | 2024-09-13T12:19:47.571Z |
5018149 | 5018149 | 20240904171448_oI7HS | NZ003B | 2024-09-10T12:10:04.053Z | 2024-09-13T12:19:47.324Z |
5018121 | 5018121 | 20240904171239_2eLbr | NZ003B | 2024-09-10T12:10:01.502Z | 2024-09-13T12:19:47.212Z |
5017818 | 5017818 | 20240904164355_c8gwR | NZ003B | 2024-09-10T12:09:36.178Z | 2024-09-13T12:19:47.093Z |
5017496 | 5017496 | 20240904161229_ekv4B | NZ003B | 2024-09-10T12:09:12.333Z | 2024-09-13T12:19:46.894Z |
5017415 | 5017415 | 20240904160630_fJFA3 | NZ003B | 2024-09-10T12:09:09.336Z | 2024-09-13T12:19:46.866Z |
5017188 | 5017188 | 20240904153853_TQyYO | NZ003B | 2024-09-10T12:08:54.845Z | 2024-09-13T12:19:46.631Z |
5016988 | 5016988 | 20240904151943_NQYqM | NZ003B | 2024-09-10T12:08:37.548Z | 2024-09-13T12:19:46.487Z |
5016919 | 5016919 | 20240904151104_9d22M | NZ003B | 2024-09-10T12:08:30.974Z | 2024-09-13T12:19:46.446Z |
5016826 | 5016826 | 20240904150041_owaiF | NZ003B | 2024-09-10T12:08:22.211Z | 2024-09-13T12:19:46.351Z |
5016597 | 5016597 | 20240904142957_B3hNY | NZ003B | 2024-09-10T12:07:59.521Z | 2024-09-13T12:19:45.878Z |
5016433 | 5016433 | 20240904141431_BSAGp | NZ003B | 2024-09-10T12:07:49.326Z | 2024-09-13T12:19:45.716Z |
5016405 | 5016405 | 20240904141246_hcY4D | NZ003B | 2024-09-10T12:07:47.273Z | 2024-09-13T12:19:45.679Z |
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);