names

81 rows where place_id = 600529

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590166 1864564 1864564 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
3641398 1907763 1907763 defendant Coket John esq 600529 600529 Coket, John, of Ampton, esq 0
3844226 1971742 1971742 defendant Ive Thomas husbandman 600529 600529 Ive, Thomas, of Ampton, husbandman 1
3851592 1974085 1974085 defendant Ive Thomas husbandman 600529 600529 Ive, Thomas, of Ampton, husbandman 2
4147119 2077136 2077136 plaintiff Cooke Richard (legal representative) 600529 600529 Cooke, Richard, of Ampton, yeoman, executrix of 0
4147127 2077137 2077137 plaintiff Cooke Richard (legal representative) 600529 600529 Cooke, Richard, of Ampton, yeoman, executrix of 0
4771934 2287194 2287194 defendant Huxster John husbandman 600529 600529 Huxster, John, of Ampton, husbandman 4
4906468 2328608 2328608 defendant Coket John yeoman 600529 600529 Coket, John, of Ampton, yeoman 8
4938958 2338576 2338576 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
4938960 2338577 2338577 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
4938963 2338578 2338578 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
4958118 2344396 2344396 plaintiff Coket John   600529 600529 Coket, John, of Ampton 1
4964691 2346347 2346347 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5018064 2362168 2362168 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5064075 2375790 2375790 plaintiff Koket John   600529 600529 Koket, John, of Ampton 0
5105493 2388052 2388052 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5105495 2388053 2388053 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5128524 2394817 2394817 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5128526 2394818 2394818 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5182614 2410672 2410672 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5203498 2416777 2416777 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5215503 2420259 2420259 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5215508 2420260 2420260 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5233914 2425508 2425508 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5255193 2431741 2431741 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5256164 2432052 2432052 defendant Coket John merchant 600529 600529 Coket, John, of Ampton, merchant 0
5269734 2436258 2436258 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5269740 2436259 2436259 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5281151 2439561 2439561 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5281154 2439562 2439562 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5281156 2439563 2439563 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5300694 2445172 2445172 plaintiff Coket John   600529 600529 Coket, John, of Ampton 0
5332562 2454806 2454806 plaintiff Coket John, junior   600529 600529 Coket, John, junior, of Ampton 0
5350244 2460197 2460197 plaintiff Coket John, senior merchant 600529 600529 Coket, John, senior, of Ampton, merchant 0
5367560 2465501 2465501 plaintiff Cokett John   600529 600529 Cokett, John, of Ampton 0
5367564 2465502 2465502 plaintiff Cokett John   600529 600529 Cokett, John, of Ampton 0
5386056 2471083 2471083 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5386061 2471084 2471084 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
5386067 2471085 2471085 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
5389798 2472144 2472144 defendant Dyke Geoffrey   600529 600529 Dyke, Geoffrey, of Ampton 1
5398285 2474579 2474579 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5398294 2474580 2474580 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5398303 2474581 2474581 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
5398310 2474582 2474582 plaintiff Coket John, senior   600529 600529 Coket, John, senior, of Ampton 0
5411420 2478376 2478376 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5411427 2478377 2478377 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5411434 2478378 2478378 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5411445 2478380 2478380 plaintiff Coket John, sen (legal representative) 600529 600529 Coket, John, sen, of Ampton, executors of 0
5415527 2479584 2479584 defendant Dykes Geoffrey woolman 600529 600529 Dykes, Geoffrey, of Ampton, woolman 1
5425637 2482652 2482652 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5425644 2482653 2482653 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
5425706 2482660 2482660 plaintiff Cokette John (legal representative) 600529 600529 Cokette, John, of Ampton, merchant, executors of 0
5431874 2484500 2484500 defendant Dykes Geoffrey woolman 600529 600529 Dykes, Geoffrey, of Ampton, woolman 1
5444061 2488140 2488140 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of (Coket, Alice, formerly wife of John Coket 0
5444067 2488141 2488141 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5444076 2488142 2488142 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5444081 2488143 2488143 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
5444082 2488143 2488143 plaintiff Coket Alice   600529 600529 (Coket, Alice, of Ampton, formerly wife of John 1
5444091 2488144 2488144 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
5444092 2488144 2488144 plaintiff Coket Alice   600529 600529 (Coket, Alice, of Ampton, formerly wife of John 1
5444101 2488145 2488145 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
5444102 2488145 2488145 plaintiff Coket Alice   600529 600529 (Coket, Alice, of Ampton, formerly wife of John 1
5444121 2488147 2488147 plaintiff Coket John   600529 600529 Coket, John, of Ampton 3
5456785 2491949 2491949 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5456795 2491950 2491950 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5456802 2491951 2491951 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, merchant, executors of 0
5456812 2491952 2491952 plaintiff Coket John, sen (legal representative) 600529 600529 Coket, John, sen, of Ampton, merchant, executors of 0
5456823 2491954 2491954 plaintiff Cokette John (legal representative) 600529 600529 Cokette, John, of Ampton, merchant, executors of 0
5456833 2491955 2491955 plaintiff Cokette John, sen (legal representative) 600529 600529 Cokette, John, sen, of Ampton, merchant, executors of 0
5456843 2491956 2491956 plaintiff Cokette John, sen (legal representative) 600529 600529 Cokette, John, sen, of Ampton, merchant, executors of 0
5456853 2491957 2491957 plaintiff Cokette John, sen (legal representative) 600529 600529 Cokette, John, sen, of Ampton, merchant, executors of 0
5468690 2495568 2495568 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5468700 2495569 2495569 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5492159 2502567 2502567 plaintiff Coket John, senior (legal representative) 600529 600529 Coket, John, senior, of Ampton, merchant, executors of 0
5492166 2502568 2502568 plaintiff Coket John, senior (legal representative) 600529 600529 Coket, John, senior, of Ampton, merchant, executors of 0
5521585 2511568 2511568 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executor of 0
5521588 2511569 2511569 plaintiff Coket John (legal representative) 600529 600529 Coket, John, of Ampton, executors of 0
5521592 2511570 2511570 plaintiff Coket John gent 600529 600529 Coket, John, of Ampton, gent 0
5521594 2511571 2511571 plaintiff Coket John gent 600529 600529 Coket, John, of Ampton, gent 0
5521596 2511572 2511572 plaintiff Coket John gent 600529 600529 Coket, John, of Ampton, gent 0
5564431 2524216 2524216 defendant Coket John gent 600529 600529 Coket, John, of Ampton, gent 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);