-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathgame_move_dump.sql
1466 lines (1137 loc) · 166 KB
/
game_move_dump.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: boards; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE boards (
id integer NOT NULL,
title character varying(255) NOT NULL,
number_of_players integer NOT NULL,
creator_id integer,
updator_id integer,
created_at timestamp without time zone,
updated_at timestamp without time zone,
nodes_attributes json DEFAULT '[{"round": 0}]'::json NOT NULL,
links_attributes json DEFAULT '[]'::json NOT NULL
);
ALTER TABLE public.boards OWNER TO narinda;
--
-- Name: boards_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE boards_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.boards_id_seq OWNER TO narinda;
--
-- Name: boards_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE boards_id_seq OWNED BY boards.id;
--
-- Name: games; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE games (
id integer NOT NULL,
board_id integer,
title character varying(255) NOT NULL,
description text,
creator_id integer,
updator_id integer,
created_at timestamp without time zone,
updated_at timestamp without time zone,
invite_only boolean DEFAULT false,
uploads_allowed boolean DEFAULT false,
theme character varying(255),
allow_keyword_search boolean DEFAULT false,
state character varying(255) DEFAULT NULL::character varying,
current_round integer DEFAULT 1,
random_seed integer,
number_of_players integer,
filter_content_by json
);
ALTER TABLE public.games OWNER TO narinda;
--
-- Name: games_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE games_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.games_id_seq OWNER TO narinda;
--
-- Name: games_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE games_id_seq OWNED BY games.id;
--
-- Name: links; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE links (
id integer NOT NULL,
source_id integer,
target_id integer,
game_id integer,
created_at timestamp without time zone,
updated_at timestamp without time zone
);
ALTER TABLE public.links OWNER TO narinda;
--
-- Name: links_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE links_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.links_id_seq OWNER TO narinda;
--
-- Name: links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE links_id_seq OWNED BY links.id;
--
-- Name: nodes; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE nodes (
id integer NOT NULL,
game_id integer,
round integer,
state character varying(255),
allocated_to_id integer,
created_at timestamp without time zone,
updated_at timestamp without time zone,
x integer DEFAULT 0 NOT NULL,
y integer DEFAULT 0 NOT NULL
);
ALTER TABLE public.nodes OWNER TO narinda;
--
-- Name: nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE nodes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.nodes_id_seq OWNER TO narinda;
--
-- Name: nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE nodes_id_seq OWNED BY nodes.id;
--
-- Name: placements; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE placements (
id integer NOT NULL,
state character varying(255) NOT NULL,
thing_id integer,
node_id integer,
creator_id integer,
created_at timestamp without time zone,
updated_at timestamp without time zone,
title character varying(255),
score double precision
);
ALTER TABLE public.placements OWNER TO narinda;
--
-- Name: placements_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE placements_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.placements_id_seq OWNER TO narinda;
--
-- Name: placements_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE placements_id_seq OWNED BY placements.id;
--
-- Name: players; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE players (
id integer NOT NULL,
game_id integer,
user_id integer,
score double precision DEFAULT 0 NOT NULL,
created_at timestamp without time zone,
updated_at timestamp without time zone,
state character varying(255) DEFAULT NULL::character varying NOT NULL,
email character varying(255),
move_state character varying(255)
);
ALTER TABLE public.players OWNER TO narinda;
--
-- Name: players_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE players_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.players_id_seq OWNER TO narinda;
--
-- Name: players_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE players_id_seq OWNED BY players.id;
--
-- Name: profiles; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE profiles (
id integer NOT NULL,
user_id integer,
name character varying(255),
bio text,
avatar character varying(255)
);
ALTER TABLE public.profiles OWNER TO narinda;
--
-- Name: profiles_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE profiles_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.profiles_id_seq OWNER TO narinda;
--
-- Name: profiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE profiles_id_seq OWNED BY profiles.id;
--
-- Name: ratings; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE ratings (
id integer NOT NULL,
rating double precision,
resemblance_id integer,
creator_id integer,
created_at timestamp without time zone,
updated_at timestamp without time zone
);
ALTER TABLE public.ratings OWNER TO narinda;
--
-- Name: ratings_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE ratings_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.ratings_id_seq OWNER TO narinda;
--
-- Name: ratings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE ratings_id_seq OWNED BY ratings.id;
--
-- Name: resemblances; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE resemblances (
id integer NOT NULL,
description text NOT NULL,
state character varying(255) NOT NULL,
score double precision,
link_id integer,
creator_id integer,
created_at timestamp without time zone,
updated_at timestamp without time zone,
source_id integer,
target_id integer
);
ALTER TABLE public.resemblances OWNER TO narinda;
--
-- Name: resemblances_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE resemblances_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.resemblances_id_seq OWNER TO narinda;
--
-- Name: resemblances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE resemblances_id_seq OWNED BY resemblances.id;
--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE schema_migrations (
version character varying(255) NOT NULL
);
ALTER TABLE public.schema_migrations OWNER TO narinda;
--
-- Name: things; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE things (
id integer NOT NULL,
title character varying(255),
description text DEFAULT ''::text,
creator_id integer,
updator_id integer,
created_at timestamp without time zone,
updated_at timestamp without time zone,
image character varying(255),
attribution character varying(255),
item_url character varying(255),
copyright character varying(255),
general_attributes json DEFAULT '[]'::json NOT NULL,
import_row_id character varying(255),
access_via character varying(255),
random_seed integer,
suggested_seed boolean DEFAULT false
);
ALTER TABLE public.things OWNER TO narinda;
--
-- Name: things_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE things_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.things_id_seq OWNER TO narinda;
--
-- Name: things_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE things_id_seq OWNED BY things.id;
--
-- Name: users; Type: TABLE; Schema: public; Owner: narinda; Tablespace:
--
CREATE TABLE users (
id integer NOT NULL,
email character varying(255) DEFAULT ''::character varying NOT NULL,
encrypted_password character varying(255) DEFAULT ''::character varying NOT NULL,
reset_password_token character varying(255),
reset_password_sent_at timestamp without time zone,
remember_created_at timestamp without time zone,
sign_in_count integer DEFAULT 0 NOT NULL,
current_sign_in_at timestamp without time zone,
last_sign_in_at timestamp without time zone,
current_sign_in_ip character varying(255),
last_sign_in_ip character varying(255),
created_at timestamp without time zone,
updated_at timestamp without time zone,
role integer DEFAULT 1 NOT NULL
);
ALTER TABLE public.users OWNER TO narinda;
--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: narinda
--
CREATE SEQUENCE users_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.users_id_seq OWNER TO narinda;
--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: narinda
--
ALTER SEQUENCE users_id_seq OWNED BY users.id;
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY boards ALTER COLUMN id SET DEFAULT nextval('boards_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY games ALTER COLUMN id SET DEFAULT nextval('games_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY links ALTER COLUMN id SET DEFAULT nextval('links_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY nodes ALTER COLUMN id SET DEFAULT nextval('nodes_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY placements ALTER COLUMN id SET DEFAULT nextval('placements_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY players ALTER COLUMN id SET DEFAULT nextval('players_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY profiles ALTER COLUMN id SET DEFAULT nextval('profiles_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY ratings ALTER COLUMN id SET DEFAULT nextval('ratings_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY resemblances ALTER COLUMN id SET DEFAULT nextval('resemblances_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY things ALTER COLUMN id SET DEFAULT nextval('things_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: narinda
--
ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
--
-- Data for Name: boards; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY boards (id, title, number_of_players, creator_id, updator_id, created_at, updated_at, nodes_attributes, links_attributes) FROM stdin;
2 Lotus 4 4 3 \N 2013-10-22 05:39:20.507982 2013-10-22 05:39:20.507982 [{"round": 0}] []
3 Lotus 5 4 3 \N 2013-10-22 05:39:20.510088 2013-10-22 05:39:20.510088 [{"round": 0}] []
4 Lotus 6 4 3 \N 2013-10-22 05:39:20.511643 2013-10-22 05:39:20.511643 [{"round": 0}] []
1 Lotus 3 3 3 \N 2013-10-22 05:39:20.504136 2014-03-12 03:23:50.303252 [{"y":600.0,"x":412.4031007751938,"fixed":1,"round":0},{"y":424.03846153846155,"x":800.0,"fixed":1,"round":1},{"y":288.46153846153845,"x":257.36434108527135,"fixed":1,"round":1},{"y":400.96153846153845,"x":0.0,"fixed":1,"round":1},{"y":0.0,"x":741.0852713178296,"fixed":1,"round":2},{"y":14.423076923076923,"x":120.93023255813954,"fixed":1,"round":2},{"y":279.8076923076923,"x":579.8449612403101,"fixed":1,"round":3}] [{"source":0,"target":1},{"source":0,"target":2},{"source":0,"target":3},{"source":1,"target":4},{"source":2,"target":4},{"source":2,"target":5},{"source":3,"target":5},{"source":4,"target":6},{"source":5,"target":6},{"source":6,"target":0}]
\.
--
-- Name: boards_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('boards_id_seq', 4, true);
--
-- Data for Name: games; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY games (id, board_id, title, description, creator_id, updator_id, created_at, updated_at, invite_only, uploads_allowed, theme, allow_keyword_search, state, current_round, random_seed, number_of_players, filter_content_by) FROM stdin;
2 2 Test 3 3 2014-01-15 23:18:52.685891 2014-01-15 23:18:52.685891 f f f draft 1 109731733 4 \N
3 1 Michael's test game \N 6 6 2014-01-15 23:38:45.996985 2014-03-04 22:21:32.30389 f f \N f joining 1 720276317 3 \N
4 1 Test Rating 3 3 2014-03-12 01:19:23.198701 2014-03-26 05:01:53.33909 f f \N f playing 3 2129148400 3 \N
6 1 New test 9 9 2014-03-27 06:49:12.610206 2014-04-01 01:09:31.299271 f f \N f playing 2 622590554 3 \N
7 1 Test joining dasdsad 3 3 2014-04-03 04:37:15.857607 2014-04-03 04:51:33.628574 f f \N f joining 1 940369394 3 \N
8 1 Tooltips 10 10 2014-04-15 04:54:58.499402 2014-04-22 01:57:41.842208 f f \N f playing 1 1426908242 3 \N
9 1 Terrified 12 12 2014-04-22 02:03:27.29708 2014-04-22 03:32:20.53935 t f \N f draft 1 1866213587 3 \N
\.
--
-- Name: games_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('games_id_seq', 9, true);
--
-- Data for Name: links; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY links (id, source_id, target_id, game_id, created_at, updated_at) FROM stdin;
1 2 3 3 2014-01-15 23:38:46.32979 2014-01-15 23:38:46.32979
2 2 4 3 2014-01-15 23:38:46.410298 2014-01-15 23:38:46.410298
3 2 5 3 2014-01-15 23:38:46.440673 2014-01-15 23:38:46.440673
4 3 6 3 2014-01-15 23:38:46.475681 2014-01-15 23:38:46.475681
5 4 6 3 2014-01-15 23:38:46.505428 2014-01-15 23:38:46.505428
6 4 7 3 2014-01-15 23:38:46.561101 2014-01-15 23:38:46.561101
7 5 7 3 2014-01-15 23:38:46.593913 2014-01-15 23:38:46.593913
8 6 8 3 2014-01-15 23:38:46.616202 2014-01-15 23:38:46.616202
9 7 8 3 2014-01-15 23:38:46.693715 2014-01-15 23:38:46.693715
10 8 2 3 2014-01-15 23:38:46.750942 2014-01-15 23:38:46.750942
11 9 10 4 2014-03-12 01:19:23.222421 2014-03-12 01:19:23.222421
12 9 11 4 2014-03-12 01:19:23.228245 2014-03-12 01:19:23.228245
13 9 12 4 2014-03-12 01:19:23.229951 2014-03-12 01:19:23.229951
14 10 13 4 2014-03-12 01:19:23.231589 2014-03-12 01:19:23.231589
15 11 13 4 2014-03-12 01:19:23.233251 2014-03-12 01:19:23.233251
16 11 14 4 2014-03-12 01:19:23.234913 2014-03-12 01:19:23.234913
17 12 14 4 2014-03-12 01:19:23.236619 2014-03-12 01:19:23.236619
18 13 15 4 2014-03-12 01:19:23.238191 2014-03-12 01:19:23.238191
19 14 15 4 2014-03-12 01:19:23.239793 2014-03-12 01:19:23.239793
20 15 9 4 2014-03-12 01:19:23.241367 2014-03-12 01:19:23.241367
31 23 24 6 2014-03-27 06:49:12.649886 2014-03-27 06:49:12.649886
32 23 25 6 2014-03-27 06:49:12.654352 2014-03-27 06:49:12.654352
33 23 26 6 2014-03-27 06:49:12.656178 2014-03-27 06:49:12.656178
34 24 27 6 2014-03-27 06:49:12.657938 2014-03-27 06:49:12.657938
35 25 27 6 2014-03-27 06:49:12.659696 2014-03-27 06:49:12.659696
36 25 28 6 2014-03-27 06:49:12.661602 2014-03-27 06:49:12.661602
37 26 28 6 2014-03-27 06:49:12.663339 2014-03-27 06:49:12.663339
38 27 29 6 2014-03-27 06:49:12.665069 2014-03-27 06:49:12.665069
39 28 29 6 2014-03-27 06:49:12.666714 2014-03-27 06:49:12.666714
40 29 23 6 2014-03-27 06:49:12.668203 2014-03-27 06:49:12.668203
41 30 31 7 2014-04-03 04:37:15.919107 2014-04-03 04:37:15.919107
42 30 32 7 2014-04-03 04:37:15.923823 2014-04-03 04:37:15.923823
43 30 33 7 2014-04-03 04:37:15.926752 2014-04-03 04:37:15.926752
44 31 34 7 2014-04-03 04:37:15.929494 2014-04-03 04:37:15.929494
45 32 34 7 2014-04-03 04:37:15.996214 2014-04-03 04:37:15.996214
46 32 35 7 2014-04-03 04:37:15.999215 2014-04-03 04:37:15.999215
47 33 35 7 2014-04-03 04:37:16.00136 2014-04-03 04:37:16.00136
48 34 36 7 2014-04-03 04:37:16.003826 2014-04-03 04:37:16.003826
49 35 36 7 2014-04-03 04:37:16.006087 2014-04-03 04:37:16.006087
50 36 30 7 2014-04-03 04:37:16.007652 2014-04-03 04:37:16.007652
51 37 38 8 2014-04-15 04:54:58.5468 2014-04-15 04:54:58.5468
52 37 39 8 2014-04-15 04:54:58.552461 2014-04-15 04:54:58.552461
53 37 40 8 2014-04-15 04:54:58.554903 2014-04-15 04:54:58.554903
54 38 41 8 2014-04-15 04:54:58.557596 2014-04-15 04:54:58.557596
55 39 41 8 2014-04-15 04:54:58.560184 2014-04-15 04:54:58.560184
56 39 42 8 2014-04-15 04:54:58.562354 2014-04-15 04:54:58.562354
57 40 42 8 2014-04-15 04:54:58.564572 2014-04-15 04:54:58.564572
58 41 43 8 2014-04-15 04:54:58.566825 2014-04-15 04:54:58.566825
59 42 43 8 2014-04-15 04:54:58.568443 2014-04-15 04:54:58.568443
60 43 37 8 2014-04-15 04:54:58.570157 2014-04-15 04:54:58.570157
61 44 45 9 2014-04-22 02:03:27.348083 2014-04-22 02:03:27.348083
62 44 46 9 2014-04-22 02:03:27.352574 2014-04-22 02:03:27.352574
63 44 47 9 2014-04-22 02:03:27.354739 2014-04-22 02:03:27.354739
64 45 48 9 2014-04-22 02:03:27.356779 2014-04-22 02:03:27.356779
65 46 48 9 2014-04-22 02:03:27.358654 2014-04-22 02:03:27.358654
66 46 49 9 2014-04-22 02:03:27.360386 2014-04-22 02:03:27.360386
67 47 49 9 2014-04-22 02:03:27.361912 2014-04-22 02:03:27.361912
68 48 50 9 2014-04-22 02:03:27.363854 2014-04-22 02:03:27.363854
69 49 50 9 2014-04-22 02:03:27.365981 2014-04-22 02:03:27.365981
70 50 44 9 2014-04-22 02:03:27.368181 2014-04-22 02:03:27.368181
\.
--
-- Name: links_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('links_id_seq', 70, true);
--
-- Data for Name: nodes; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY nodes (id, game_id, round, state, allocated_to_id, created_at, updated_at, x, y) FROM stdin;
1 2 0 filled \N 2014-01-15 23:18:52.701162 2014-01-15 23:18:52.701162 0 0
2 3 0 filled \N 2014-01-15 23:38:46.029111 2014-01-15 23:38:46.029111 348 341
4 3 1 in_play \N 2014-01-15 23:38:46.215709 2014-01-15 23:38:46.215709 298 233
5 3 1 in_play \N 2014-01-15 23:38:46.273538 2014-01-15 23:38:46.273538 215 272
6 3 2 locked \N 2014-01-15 23:38:46.27734 2014-01-15 23:38:46.27734 454 133
7 3 2 locked \N 2014-01-15 23:38:46.305453 2014-01-15 23:38:46.305453 254 138
8 3 3 locked \N 2014-01-15 23:38:46.324406 2014-01-15 23:38:46.324406 402 230
3 3 1 in_play 8 2014-01-15 23:38:46.166031 2014-03-04 22:21:32.28965 473 280
9 4 0 filled \N 2014-03-12 01:19:23.207286 2014-03-12 01:19:23.207286 348 341
10 4 1 filled 10 2014-03-12 01:19:23.210873 2014-03-26 00:18:15.569428 473 280
11 4 1 filled 9 2014-03-12 01:19:23.21277 2014-03-26 00:18:15.589828 298 233
12 4 1 filled 11 2014-03-12 01:19:23.214675 2014-03-26 00:18:15.608929 215 272
13 4 2 filled \N 2014-03-12 01:19:23.216527 2014-03-26 05:01:53.217564 454 133
14 4 2 filled \N 2014-03-12 01:19:23.21827 2014-03-26 05:01:53.269266 254 138
15 4 3 in_play \N 2014-03-12 01:19:23.220175 2014-03-26 05:01:53.35108 402 230
23 6 0 filled \N 2014-03-27 06:49:12.618944 2014-03-27 06:49:12.618944 412 600
29 6 3 locked \N 2014-03-27 06:49:12.647383 2014-03-27 06:49:12.647383 579 279
24 6 1 filled 10 2014-03-27 06:49:12.637169 2014-04-01 01:09:31.120334 800 424
25 6 1 filled 11 2014-03-27 06:49:12.639424 2014-04-01 01:09:31.15322 257 288
26 6 1 filled 12 2014-03-27 06:49:12.641401 2014-04-01 01:09:31.176655 0 400
27 6 2 in_play \N 2014-03-27 06:49:12.643522 2014-04-01 01:09:31.31207 741 0
28 6 2 in_play \N 2014-03-27 06:49:12.645446 2014-04-01 01:09:31.320274 120 14
30 7 0 filled \N 2014-04-03 04:37:15.870477 2014-04-03 04:37:15.870477 412 600
34 7 2 locked \N 2014-04-03 04:37:15.905586 2014-04-03 04:37:15.905586 741 0
35 7 2 locked \N 2014-04-03 04:37:15.90902 2014-04-03 04:37:15.90902 120 14
36 7 3 locked \N 2014-04-03 04:37:15.913822 2014-04-03 04:37:15.913822 579 279
31 7 1 in_play \N 2014-04-03 04:37:15.895933 2014-04-14 03:51:27.941137 800 424
32 7 1 in_play \N 2014-04-03 04:37:15.899421 2014-04-14 03:52:44.31761 257 288
33 7 1 in_play 10 2014-04-03 04:37:15.902519 2014-04-14 03:53:01.754411 0 400
37 8 0 filled \N 2014-04-15 04:54:58.510934 2014-04-15 04:54:58.510934 412 600
41 8 2 locked \N 2014-04-15 04:54:58.538172 2014-04-15 04:54:58.538172 741 0
42 8 2 locked \N 2014-04-15 04:54:58.540527 2014-04-15 04:54:58.540527 120 14
43 8 3 locked \N 2014-04-15 04:54:58.543183 2014-04-15 04:54:58.543183 579 279
38 8 1 in_play 11 2014-04-15 04:54:58.53036 2014-04-15 04:58:28.373588 800 424
39 8 1 in_play 10 2014-04-15 04:54:58.533517 2014-04-17 03:56:19.853545 257 288
40 8 1 in_play 12 2014-04-15 04:54:58.535735 2014-04-22 01:57:41.833896 0 400
44 9 0 filled \N 2014-04-22 02:03:27.307646 2014-04-22 02:03:27.307646 412 600
45 9 1 in_play \N 2014-04-22 02:03:27.332429 2014-04-22 02:03:27.332429 800 424
46 9 1 in_play \N 2014-04-22 02:03:27.33487 2014-04-22 02:03:27.33487 257 288
47 9 1 in_play \N 2014-04-22 02:03:27.336663 2014-04-22 02:03:27.336663 0 400
48 9 2 locked \N 2014-04-22 02:03:27.338698 2014-04-22 02:03:27.338698 741 0
49 9 2 locked \N 2014-04-22 02:03:27.342477 2014-04-22 02:03:27.342477 120 14
50 9 3 locked \N 2014-04-22 02:03:27.345036 2014-04-22 02:03:27.345036 579 279
\.
--
-- Name: nodes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('nodes_id_seq', 50, true);
--
-- Data for Name: placements; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY placements (id, state, thing_id, node_id, creator_id, created_at, updated_at, title, score) FROM stdin;
1 final 386 1 3 2014-01-15 23:18:52.715309 2014-01-15 23:18:52.715309 \N \N
2 final 516 2 6 2014-01-15 23:38:46.054192 2014-01-15 23:38:46.054192 \N \N
3 final 446 9 3 2014-03-12 03:12:27.849051 2014-03-12 03:14:05.944742 \N \N
6 final 362 10 10 2014-03-12 03:39:49.071707 2014-03-26 00:18:15.563639 \N 0.317500000000000004
5 final 340 11 9 2014-03-12 03:38:03.197529 2014-03-26 00:18:15.587667 \N 0.408333333333333492
7 final 340 12 11 2014-03-25 04:44:54.335146 2014-03-26 00:18:15.606024 \N 0.241666666666666502
9 proposed 386 13 10 2014-03-26 00:32:54.609556 2014-03-26 05:01:53.210272 \N 0.270000000000000018
8 final 355 13 11 2014-03-26 00:21:57.514308 2014-03-26 05:01:53.213318 \N 0.335833333333333539
11 proposed 341 14 10 2014-03-26 00:38:30.226245 2014-03-26 05:01:53.260771 \N 0.307499999999999274
10 final 343 14 9 2014-03-26 00:36:19.942071 2014-03-26 05:01:53.264452 \N 0.608333333333333282
12 proposed 372 15 11 2014-03-26 05:07:18.33602 2014-03-26 05:07:18.33602 \N \N
13 proposed 342 15 10 2014-03-27 03:29:42.428356 2014-03-27 03:29:42.428356 \N \N
14 proposed 361 15 9 2014-03-27 05:18:09.22922 2014-03-27 05:18:09.22922 \N \N
15 final 366 23 9 2014-03-27 06:49:12.624004 2014-03-27 06:49:12.624004 \N \N
21 final 376 24 10 2014-04-01 00:41:11.495473 2014-04-01 01:09:31.115862 \N 0.311666666666666481
17 final 343 25 11 2014-04-01 00:02:31.940708 2014-04-01 01:09:31.149726 \N 0.484999999999999987
18 final 385 26 12 2014-04-01 00:09:27.923293 2014-04-01 01:09:31.173199 \N 0.328333333333333477
22 proposed 355 27 12 2014-04-01 04:44:29.424369 2014-04-01 04:44:29.424369 \N \N
23 proposed 362 27 10 2014-04-01 04:54:39.962311 2014-04-01 04:54:39.962311 \N \N
24 proposed 343 28 10 2014-04-01 04:59:59.797398 2014-04-01 04:59:59.797398 \N \N
28 final 378 37 10 2014-04-15 04:54:58.515779 2014-04-15 04:54:58.515779 \N \N
31 proposed 361 38 11 2014-04-15 06:08:00.556792 2014-04-15 06:08:00.556792 \N \N
32 proposed 343 39 10 2014-04-17 04:11:55.810181 2014-04-17 04:11:55.810181 \N \N
33 final 466 44 12 2014-04-22 02:03:27.313705 2014-04-22 03:32:20.54265 \N \N
\.
--
-- Name: placements_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('placements_id_seq', 33, true);
--
-- Data for Name: players; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY players (id, game_id, user_id, score, created_at, updated_at, state, email, move_state) FROM stdin;
1 3 8 0 2014-03-04 22:21:32.261587 2014-03-12 00:43:35.115143 playing_turn \N open
6 6 11 0.484999999999999987 2014-04-01 00:00:58.481985 2014-04-01 01:09:31.335124 playing_turn \N open
7 6 12 0.328333333333332977 2014-04-01 00:05:47.536172 2014-04-01 04:44:35.623289 waiting \N created
5 6 10 0.311666666666665981 2014-03-31 23:59:04.158522 2014-04-02 04:07:55.376892 waiting \N created
3 4 9 0.508333333333332971 2014-03-12 03:26:25.438642 2014-04-03 05:56:09.403104 waiting \N created
8 7 9 0 2014-04-03 04:51:33.580045 2014-04-10 05:20:38.558115 playing_turn \N created
4 4 11 0.288750000000000007 2014-03-18 01:43:58.817487 2014-03-26 05:07:33.164093 waiting \N created
2 4 10 0.298333333333333006 2014-03-12 03:24:20.674382 2014-03-27 00:59:06.528613 playing_turn \N created
20 8 11 0 2014-04-15 06:06:55.573492 2014-04-15 06:09:26.458533 waiting \N created
21 8 10 0 2014-04-17 03:56:19.830146 2014-04-22 01:55:51.293991 waiting \N created
22 8 12 0 2014-04-22 01:57:41.817969 2014-04-22 01:57:41.817969 playing_turn \N open
\.
--
-- Name: players_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('players_id_seq', 22, true);
--
-- Data for Name: profiles; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY profiles (id, user_id, name, bio, avatar) FROM stdin;
1 1 hi \N \N
2 2 user \N \N
3 3 admin \N \N
4 4 narinda \N \N
5 5 cath.styles \N \N
6 6 michael \N \N
7 7 trsell \N \N
8 8 andy \N \N
9 9 rating_test \N \N
11 11 rating_test3 \N \N
12 12 rating_test4 \N \N
13 13 test_sign \N \N
14 14 test_sign2 \N \N
15 15 test_sign5 \N \N
16 16 test_sign4 \N \N
10 10 Testing Rating \N
\.
--
-- Name: profiles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('profiles_id_seq', 16, true);
--
-- Data for Name: ratings; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY ratings (id, rating, resemblance_id, creator_id, created_at, updated_at) FROM stdin;
22 0.280000000000000027 7 11 2014-03-26 05:01:32.369038 2014-03-26 05:01:32.369038
23 0.223333333333333328 6 11 2014-03-26 05:01:36.480415 2014-03-26 05:01:36.480415
24 0.806666666666666643 9 11 2014-03-26 05:01:40.894262 2014-03-26 05:01:40.894262
25 0.813333333333333353 8 11 2014-03-26 05:01:44.544442 2014-03-26 05:01:44.544442
26 0.606666666666666687 11 11 2014-03-26 05:01:47.407449 2014-03-26 05:01:47.407449
27 0.16333333333333333 10 11 2014-03-26 05:01:50.421471 2014-03-26 05:01:52.221344
28 0.103333333333333333 33 10 2014-04-01 00:43:50.191899 2014-04-01 00:43:50.191899
29 0.446666666666666656 34 10 2014-04-01 00:43:57.641191 2014-04-01 00:43:57.641191
30 0.209999999999999992 34 11 2014-04-01 01:07:06.300147 2014-04-01 01:07:06.300147
31 0.160000000000000003 37 11 2014-04-01 01:07:15.388545 2014-04-01 01:07:15.388545
32 0.866666666666666696 33 12 2014-04-01 01:07:56.25898 2014-04-01 01:07:56.25898
33 0.463333333333333319 37 12 2014-04-01 01:08:01.675686 2014-04-01 01:08:01.675686
34 0.365300000000000014 39 10 2014-04-02 03:54:23.185083 2014-04-02 03:55:32.179071
35 0.483999999999999986 38 10 2014-04-02 04:07:15.243576 2014-04-02 04:07:15.243576
37 0.397299999999999986 40 12 2014-04-02 23:28:09.33023 2014-04-02 23:28:09.33023
38 0.536599999999999966 43 12 2014-04-02 23:28:46.303489 2014-04-03 03:42:42.959935
8 0.153333333333333321 2 9 2014-03-18 01:15:49.605464 2014-03-18 01:35:57.838567
9 0.445000000000000007 1 11 2014-03-18 01:45:46.830006 2014-03-19 03:01:17.892754
10 0.481666666666666687 2 11 2014-03-18 03:10:19.765387 2014-03-19 04:39:49.767624
11 0.458333333333333315 3 9 2014-03-25 05:46:26.58795 2014-03-25 05:46:26.58795
12 0.371666666666666645 1 10 2014-03-25 05:47:18.185731 2014-03-25 05:47:18.185731
13 0.0250000000000000014 3 10 2014-03-25 05:47:22.378925 2014-03-25 05:47:23.691584
36 0.648499999999999965 41 12 2014-04-02 23:27:14.660636 2014-04-03 03:57:58.854015
39 0.513699999999999934 42 12 2014-04-03 03:58:13.441571 2014-04-03 03:58:13.441571
14 \N 5 10 2014-03-26 00:39:59.872941 2014-03-26 04:21:25.003623
15 \N 9 10 2014-03-26 00:40:27.994741 2014-03-26 04:21:25.024069
19 0.130000000000000004 5 9 2014-03-26 04:52:06.869137 2014-03-26 04:52:06.869137
16 0.606666666666666687 4 9 2014-03-26 03:40:49.037151 2014-03-26 04:52:48.233972
20 0.316666666666666652 7 9 2014-03-26 04:53:06.988387 2014-03-26 04:53:06.988387
17 0.260000000000000009 6 9 2014-03-26 03:50:46.633507 2014-03-26 04:53:20.305335
21 0.396666666666666667 11 9 2014-03-26 04:53:24.967543 2014-03-26 04:53:24.967543
18 0.0633333333333333387 10 9 2014-03-26 03:52:55.450442 2014-03-26 04:53:30.020811
\.
--
-- Name: ratings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('ratings_id_seq', 39, true);
--
-- Data for Name: resemblances; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY resemblances (id, description, state, score, link_id, creator_id, created_at, updated_at, source_id, target_id) FROM stdin;
12 Old school proposed \N 18 11 2014-03-26 05:07:18.344395 2014-03-26 05:07:18.344395 8 12
13 Dunno proposed \N 19 11 2014-03-26 05:07:18.348255 2014-03-26 05:07:18.348255 10 12
28 as proposed \N 18 10 2014-03-27 03:47:50.287597 2014-03-27 03:47:50.287597 8 13
29 as proposed \N 19 10 2014-03-27 03:47:50.293267 2014-03-27 03:47:50.293267 10 13
30 Babes proposed \N 18 9 2014-03-27 05:18:09.2338 2014-03-27 05:18:09.2338 8 14
31 Babes proposed \N 19 9 2014-03-27 05:18:09.241803 2014-03-27 05:18:09.241803 10 14
41 asd proposed 0.648499999999999965 35 10 2014-04-01 04:54:39.966877 2014-04-03 03:57:58.863808 17 23
42 asd proposed 0.513700000000000045 36 10 2014-04-01 04:59:59.800248 2014-04-03 03:58:13.453515 17 24
2 Floral final 0.317500000000000004 11 10 2014-03-12 03:39:49.082221 2014-04-03 02:29:54.843352 3 6
1 Pets and fruits final 0.408333333333332993 12 9 2014-03-12 03:38:03.211297 2014-04-03 02:29:54.852399 3 5
3 Not even sure final 0.241666666666667002 13 11 2014-03-25 04:46:22.669852 2014-04-03 02:29:54.867393 3 7
6 Environmental understanding proposed 0.241666666666667002 14 10 2014-03-26 00:32:54.61739 2014-04-03 02:29:54.872066 6 9
7 Where is that possum? proposed 0.298333333333333006 15 10 2014-03-26 00:32:54.621785 2014-04-03 02:29:54.876716 5 9
10 Carrying proposed 0.113333333333332995 16 10 2014-03-26 00:38:30.22942 2014-04-03 02:29:54.881268 5 11
11 Caring proposed 0.501666666666667038 17 10 2014-03-26 00:38:30.232392 2014-04-03 02:29:54.885441 7 11
4 Pretty final 0.60666666666666702 14 11 2014-03-26 00:21:57.521129 2014-04-03 02:29:54.889553 6 8
5 Boy with nature final 0.130000000000000004 15 11 2014-03-26 00:21:57.525945 2014-04-03 02:29:54.893856 5 8
8 Heavy load final 0.81333333333333302 16 9 2014-03-26 00:36:19.950235 2014-04-03 02:29:54.899167 5 10
9 Native pets final 0.806666666666666976 17 9 2014-03-26 00:36:19.953562 2014-04-03 02:29:54.906653 7 10
37 Thirsty final 0.31166666666666698 31 10 2014-04-01 00:41:11.498307 2014-04-03 02:29:54.978162 15 21
33 Cuddles final 0.484999999999999987 32 11 2014-04-01 00:02:31.943578 2014-04-03 02:29:54.983989 15 17
34 Boys club final 0.328333333333332977 33 12 2014-04-01 00:09:27.925772 2014-04-03 02:29:54.989977 15 18
38 asd proposed 0.483999999999999986 34 12 2014-04-01 04:44:29.429342 2014-04-03 02:29:54.995588 21 22
39 asd proposed 0.365300000000000014 35 12 2014-04-01 04:44:29.433131 2014-04-03 02:29:55.001056 17 22
40 asd proposed 0.397299999999999986 34 10 2014-04-01 04:54:39.964739 2014-04-03 02:29:55.034887 21 23
43 asd proposed 0.0434000000000000011 37 10 2014-04-01 04:59:59.802578 2014-04-03 02:29:55.049367 18 24
48 Boomerang babies proposed \N 51 11 2014-04-15 06:08:00.560328 2014-04-15 06:08:00.560328 28 31
49 Something proposed \N 52 10 2014-04-17 04:11:55.816998 2014-04-17 04:11:55.816998 28 32
\.
--
-- Name: resemblances_id_seq; Type: SEQUENCE SET; Schema: public; Owner: narinda
--
SELECT pg_catalog.setval('resemblances_id_seq', 49, true);
--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY schema_migrations (version) FROM stdin;
20131014050440
20131015002355
20131015025606
20131015051929
20131015070339
20131017044414
20131017044432
20131017044440
20131017044451
20131029040046
20131030040144
20131017045438
20131017045458
20131017231832
20131018043025
20131018051741
20131017060345
20131022055830
20131120045222
20131120045237
20131121002730
20131121032603
20131121040600
20131127020914
20131127020944
20131127045113
20131127230252
20131204035049
20131204052618
20131204234506
20131205035026
20131210034401
20131212030054
20131217042024
20140205010520
20140211225733
20140224031647
20140226011705
20140318231306
20140415064148
\.
--
-- Data for Name: things; Type: TABLE DATA; Schema: public; Owner: narinda
--
COPY things (id, title, description, creator_id, updator_id, created_at, updated_at, image, attribution, item_url, copyright, general_attributes, import_row_id, access_via, random_seed, suggested_seed) FROM stdin;
340 Pet possum A woman from the shoulders up. A taut string rope is visible behind her ears, suggesting she is carrying a bag, and a baby possum is sitting on her head. \N 3 2014-01-08 00:23:53.656982 2014-02-25 21:44:22.970934 800d7b2f.jpg Herbert Basedow http://www.nma.gov.au/collections-search/display?app=tlf&irn=11728 CC BY-NC-SA {"Date/s":["1922"],"Places":["Australia","Northern Territory","Victoria River"],"Node type":["photograph"],"Keywords":["possum","woman","Indigenous"]} NMA1 National Museum of Australia 1870541549 t
341 Week-old baby asleep in a wooden container A very young baby, sleeping in a wooden bowl resting on sandy ground. A foot is visible, suggesting the baby is being gently rocked. \N \N 2014-01-08 00:24:00.82912 2014-02-25 21:44:22.987097 daaf6b31.jpg Herbert Basedow http://www.nma.gov.au/collections-search/display?app=tlf&irn=12543 CC BY-NC-SA {"Date/s":["1919"],"Places":["Australia","South Australia"],"Node type":["photograph"],"Keywords":["baby","Indigenous","sleeping","family"]} NMA2 National Museum of Australia 305779120 f
342 Young man on a raft A young man sits cross-legged, holding a paddle, on a wooden raft in a body of water with trees and other vegetation. \N \N 2014-01-08 00:24:08.365429 2014-02-25 21:44:22.993576 e3b5abc8.jpg Herbert Basedow http://www.nma.gov.au/collections-search/display?app=tlf&irn=11791 CC BY-NC-SA {"Date/s":["1916"],"Places":["Australia","Western Australia","Kimberley"],"Node type":["photograph"],"Keywords":["man","raft","mangrove","Indigenous"]} NMA3 National Museum of Australia 1733600035 f
343 Women carrying large baskets and a child Two thin young women stand, each carrying a woven basket with the strap around their head. One also carries a child. To the right of the frame a thin dog stands, alert, facing away from the camera. \N \N 2014-01-08 00:24:16.767316 2014-02-25 21:44:23.001492 7883ec94.jpg Herbert Basedow http://www.nma.gov.au/collections-search/display?app=tlf&irn=12829 CC BY-NC-SA {"Date/s":["1928"],"Places":["Australia","Northern Territory","Arnhem Land"],"Node type":["photograph"],"Keywords":["women","baskets","baby","dog","dingo","Indigenous","family"]} NMA4 National Museum of Australia 1273702373 f
355 Invincible sailor Bust of a sailor boy with "Invincible" printed on his hat band. Sourrounding is an underwater scene of fish, shells and coral. Printed at the base: Manufactured by Heinecke & Fox, Melbourne. \N \N 2014-01-08 00:28:25.004684 2014-02-25 21:44:23.090161 115ade2c.jpg Heinecke & Fox http://handle.slv.vic.gov.au/10381/53335 public domain {"Date/s":["1884"],"Places":["Australia","Victoria"],"Node type":["print"],"Keywords":["sailor","boy","invincible","advertisement","lithograph","propaganda"]} SLV009 State Library of Victoria 1760644444 f
361 Three women, nine babies The first nursery group at the Australian Greek Welfare Society Child Care and Community Centre \N \N 2014-01-08 00:29:17.731852 2014-02-25 21:44:23.136282 ff5cade2.jpg Australia, Victoria, Richmond, 8 Corsair St, Australian Greek Welfare Society Child Care and Community Centre, Greece http://handle.slv.vic.gov.au/10381/122506 public domain {"Date/s":["1988"],"Places":["Australia","Victoria","Richmond"],"Node type":["photograph"],"Keywords":["babies","nursery","Greek","community"]} SLV016 State Library of Victoria 832819423 f
362 Two drawings of a passion flower A drawing of two passionfruit flowers \N \N 2014-01-08 00:29:24.360133 2014-02-25 21:44:23.14552 0f8a1afb.jpg Christian Marjory Emily Carlyle Waller http://handle.slv.vic.gov.au/10381/114008 public domain {"Date/s":["1920"],"Places":["Australia","Victoria"],"Node type":["drawing"],"Keywords":["passionfruit","flowers","botany"]} SLV017 State Library of Victoria 626532591 f
363 Woman holding baby in front of a house Free-standing weatherboard house with corrugated iron roof and porch, woman standing on front path, wearing an apron, holding a baby, picket fence in front (possibly Wederburn) \N \N 2014-01-08 00:29:30.905913 2014-02-25 21:44:23.157503 73c14f60.jpg \N http://handle.slv.vic.gov.au/10381/45639 public domain {"Date/s":["c1880-1890"],"Places":["Australia","Victoria","Wederburn"],"Node type":["photograph"],"Keywords":["weatherboard","house","picket fence","mother","baby","woman","holding","home","family"]} SLV018 State Library of Victoria 1716933903 f
364 Bath war hospital, ward no.4 Shows a hospital ward with a line of beds on right and left, patients, some sitting up, nurses standing beside some of the beds. \N \N 2014-01-08 00:29:38.275351 2014-02-25 21:44:23.166045 2a526337.jpg \N http://handle.slv.vic.gov.au/10381/16420 public domain {"Date/s":["1918"],"Places":["England","Bath"],"Node type":["photograph"],"Keywords":["hospital","war","wounded","nurses","beds","ward","men","aftermath","World War I"]} SLV019 State Library of Victoria 901583244 f
365 Bush grave Bush grave – the headstone reads "In loving memory of out dear father James Hamilton, died 8th May 1865 aged 50 years" \N \N 2014-01-08 00:29:45.353972 2014-02-25 21:44:23.175611 94a4aa13.jpg James Hamilton http://handle.slv.vic.gov.au/10381/41281 public domain {"Date/s":["c1914���1937"],"Places":["Australia","Victoria"],"Node type":["photograph"],"Keywords":["grave","gravestone","fence","bush","James Hamilton","death"]} SLV020 State Library of Victoria 361091783 f
376 Anatomy of a horse Original drawing of the anatomy of the horse. Some areas of the horse are highlighted with numbered pointers, but there is no key to the numbers. \N \N 2014-01-08 00:31:16.190325 2014-02-25 21:44:23.255096 0acf731d.jpg David Brown http://handle.slv.vic.gov.au/10381/53302 public domain {"Date/s":["1879"],"Places":["Australia","Victoria"],"Node type":["print"],"Keywords":["horse","illustration","anatomy","animals"]} SLV031 State Library of Victoria 208194531 f
372 Empty exhibition building interior Interior of an empty exhibition building, with detailed patterning. \N \N 2014-01-08 00:30:41.896918 2014-02-25 21:44:23.228976 fbaaad98.jpg \N http://handle.slv.vic.gov.au/10381/54833 public domain {"Date/s":["1871"],"Places":["Australia","Victoria","Melbourne"],"Node type":["photograph"],"Keywords":["exhibition","building","empty","ornate","interior"]} SLV027 State Library of Victoria 1042898762 f
373 The Melbourne and Hobson's Bay Limited Railway Company's pier A busy wharf scene with many sailing ships tied up at the wharf. \N 3 2014-01-08 00:30:51.232268 2014-02-25 21:44:23.235407 513a26b7.jpg Charles Nettleton http://handle.slv.vic.gov.au/10381/29509 public domain {"Date/s":["c1900���1954"],"Places":["Australia","Victoria","Melbourne"],"Node type":["photograph"],"Keywords":["railway","pier","steamboats","boats","travel"]} SLV028 State Library of Victoria 2097705110 t
374 Dead shot worm candy Advertisement for childrens' worm treatment. Text reads: Safe, sure & simple, Dead shot worm candy, 25 cents, registered, for children, directions inside, specially adapted for domestic convenience, by J Kendrick, Brooklyn, New York. \N \N 2014-01-08 00:30:58.348188 2014-02-25 21:44:23.241386 91ef6035.jpg \N http://handle.slv.vic.gov.au/10381/53054 public domain {"Date/s":["1880"],"Places":["Australia","Victoria","United States of America","New York","Brooklyn"],"Node type":["print"],"Keywords":["candy","children","worms","treatment","lithograph","parasites","medicine","health"]} SLV029 State Library of Victoria 1249528450 f
375 Replica of Ned Kelly’s armour Studio photograph of a replica of Ned Kelly's suit of armour made by photographer, William Burman, for his own publication purposes. \N \N 2014-01-08 00:31:06.772303 2014-02-25 21:44:23.247242 e29b991a.jpg WIlliam J Burman http://handle.slv.vic.gov.au/10381/52783 public domain {"Date/s":["1880"],"Places":["Australia","Victoria"],"Node type":["photograph"],"Keywords":["armour","Kelly gang","bushrangers","studio"]} SLV030 State Library of Victoria 344845755 f
378 Boomerang brand Encircled image of an Australian Aboriginal man against a background of lake and mountains, spear and shield in hand, about to throw a boomerang. \N \N 2014-01-08 00:31:29.556695 2014-02-25 21:44:23.270439 8f47d3a8.jpg Troedel & Co http://handle.slv.vic.gov.au/10381/54222 public domain {"Date/s":["1881"],"Places":["Australia","Victoria"],"Node type":["print"],"Keywords":["man","shield","boomerang","Indigenous","label","advertisement","symbol","emblem"]} SLV033 State Library of Victoria 2118003381 f
384 Bush surgeon Shows bushland in background, a woman, two men and a child outside a bark hut. One man is seated and reading a book below a sign reading: "Dr Smith / Surgeon" \N \N 2014-01-08 00:32:15.099096 2014-02-25 21:44:23.311251 c7afa9b8.jpg Thomas J Washbourne http://handle.slv.vic.gov.au/10381/54106 public domain {"Date/s":["1870"],"Places":["Australia","Victoria"],"Node type":["photograph"],"Keywords":["building","surgeon","bushland","bark hut","Dr Smith"]} SLV040 State Library of Victoria 270999684 f