names

28 rows where place_id = 778099

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4651910 2246536 2246536 defendant Bocher Geoffrey butcher 778099 778099 Bocher, Geoffrey, of Neweport, Isle of Wight, butcher 0
4685640 2261100 2261100 defendant Passewere Thomas gent 778099 778099 Passewere, Thomas, of Neweport, Isle of Wight, gent 0
4693389 2263435 2263435 defendant Bylby Richard chapman 778099 778099 Bylby, Richard, of Neweport, Isle of Wight, chapman 1
4693394 2263436 2263436 defendant Bylby Richard chapman 778099 778099 Bylby, Richard, of Neweport, Isle of Wight, chapman 1
4745260 2279123 2279123 defendant Furse John chapman 778099 778099 Furse, John, of Neweport, Isle of Wight, chapman 0
4789715 2292852 2292852 defendant Bursted John tanner 778099 778099 Bursted, John, of Neweport, Isle of Wight, tanner 0
4794220 2294330 2294330 defendant Farry William yeoman 778099 778099 Farry, William, of Neweport, Isle of Wight, yeoman 0
4864827 2315973 2315973 defendant Farcy William merchant 778099 778099 Farcy, William, of Neweport, Isle of Wight, merchant 2
4874391 2318933 2318933 defendant Souter William shoemaker 778099 778099 Souter, William, of Neweport, Isle of Wight, shoemaker 0
4874392 2318933 2318933 defendant West John carpenter 778099 778099 West, John, of Neweport, Isle of Wight, carpenter 1
5034335 2366901 2366901 defendant Barbour John chapman 778099 778099 Barbour, John, of Neweport, Isle of Wight, chapman 1
5043552 2369690 2369690 defendant Coupelond Richard   778099 778099 Coupelond, Richard, of Neweport, Isle of Wight, surgeon 0
5077749 2379839 2379839 defendant Haynes John chapman 778099 778099 Haynes, John, of Neweport, Isle of Wight, chapman 4
5077755 2379840 2379840 defendant Haynes John chapman 778099 778099 Haynes, John, of Neweport, Isle of Wight, chapman 4
5096458 2385397 2385397 defendant Barbour John chapman 778099 778099 Barbour, John, of Neweport, Isle of Wight, chapman 0
5126518 2394231 2394231 defendant Dagvile Simon   778099 778099 Dagvile, Simon, of Neweport, Isle of Wight, shoe maker 0
5128787 2394903 2394903 defendant Wylde Richard weaver 778099 778099 Wylde, Richard, of Neweport, Isle of Wight, weaver 3
5145175 2399734 2399734 defendant Dagviel Simon shoemaker 778099 778099 Dagviel, Simon, of Neweport, Isle of Wight, shoemaker 0
5165739 2405725 2405725 defendant Dagvile Simon shoemaker 778099 778099 Dagvile, Simon, of Neweport, Isle of Wight, shoemaker 0
5180171 2409942 2409942 defendant Dagvyle Simon   778099 778099 Dagvyle, Simon, of Neweport, Isle of Wight, shoe maker 0
5182954 2410760 2410760 defendant Wilde Richard weaver 778099 778099 Wilde, Richard, of Neweport, Isle of Wight, weaver 3
5238273 2426778 2426778 defendant Knyght William tailor 778099 778099 Knyght, William, of Neweport, Isle of Wight, tailor 0
5244927 2428689 2428689 defendant Gest John (legal representative) 778099 778099 Gest, John, of Neweport, Isle of Wight, smith, executor of 0
5244930 2428690 2428690 defendant Gest John (legal representative) 778099 778099 Gest, John, of Neweport, Isle of Wight, smith, executor of 0
5247983 2429546 2429546 defendant Waverley William chapman 778099 778099 Waverley, William, of Neweport, Isle of Wight, chapman 1
5263747 2434414 2434414 defendant Dagvyle Simon cordwainer 778099 778099 Dagvyle, Simon, of Neweport, Isle of Wight, cordwainer 1
5289838 2442034 2442034 defendant Porter Nicholas mercer 778099 778099 Porter, Nicholas, of Neweport, Isle of Wight, mercer 0
5307321 2447195 2447195 defendant Pawelyn William tanner 778099 778099 Pawelyn, William, of Neweport, Isle of Wight, tanner 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);