names

28 rows where place_id = 592169

✎ 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
3606814 1869801 1869801 defendant Maryot John mariner 592169 592169 Maryot, John, of Burnham Depdale, mariner 13
3715207 1931050 1931050 defendant Beele Thomas clerk 592169 592169 Beele, Thomas, of Burnham Depdale, clerk 0
3820440 1964276 1964276 defendant Meryell John mariner 592169 592169 Meryell, John, of Burnham Depdale, mariner 0
4276382 2121684 2121684 defendant Yong Henry carpenter 592169 592169 Yong, Henry, of Burnham Depdale, carpenter 0
4331924 2140972 2140972 defendant Stone Ralph yeoman 592169 592169 Stone, Ralph, of Burnham Depdale, yeoman 0
5104435 2387723 2387723 defendant Herman John shipman 592169 592169 Herman, John, of Burnham Depdale, shipman 2
5157060 2403204 2403204 defendant Overman Thomas husbandman 592169 592169 Overman, Thomas, of Burnham Depdale, husbandman 0
5173124 2407848 2407848 defendant Overman Thomas husbandman 592169 592169 Overman, Thomas, of Burnham Depdale, husbandman 0
5261290 2433641 2433641 defendant Overman William mariner 592169 592169 Overman, William, of Burnham Depdale, mariner 3
5261291 2433641 2433641 defendant Overman Thomas husbandman 592169 592169 Overman, Thomas, of Burnham Depdale, husbandman 4
5286401 2441024 2441024 defendant Kentston Thomas mariner 592169 592169 Kentston, Thomas, of Burnham Depdale, mariner 0
5286402 2441024 2441024 defendant Overman Thomas husbandman 592169 592169 Overman, Thomas, of Burnham Depdale, husbandman 1
5313112 2448955 2448955 defendant Kenston Thomas husbandman 592169 592169 Kenston, Thomas, of Burnham Depdale, husbandman 2
5321278 2451459 2451459 defendant Kenston Thomas husbandman 592169 592169 Kenston, Thomas, of Burnham Depdale, husbandman 0
5323200 2452020 2452020 defendant Kenston Thomas husbandman 592169 592169 Kenston, Thomas, of Burnham Depdale, husbandman 1
5338834 2456719 2456719 defendant Kentston Thomas yeoman 592169 592169 Kentston, Thomas, of Burnham Depdale, yeoman 2
5338841 2456722 2456722 defendant Kenston Thomas yeoman 592169 592169 Kenston, Thomas, of Burnham Depdale, yeoman 0
5338843 2456723 2456723 defendant Kenston Thomas yeoman 592169 592169 Kenston, Thomas, of Burnham Depdale, yeoman 0
5344766 2458531 2458531 defendant Kenston Thomas yeoman 592169 592169 Kenston, Thomas, of Burnham Depdale, yeoman 0
5362824 2464015 2464015 defendant Kenston Thomas yeoman 592169 592169 Kenston, Thomas, of Burnham Depdale, yeoman 0
5402739 2475860 2475860 defendant Kenstow Thomas yeoman 592169 592169 Kenstow, Thomas, of Burnham Depdale, yeoman 0
5410165 2477992 2477992 defendant Kenston Thomas yeoman 592169 592169 Kenston, Thomas, of Burnham Depdale, yeoman 0
5419289 2480695 2480695 defendant Rentston Thomas yeoman 592169 592169 Rentston, Thomas, of Burnham Depdale, yeoman 0
5423848 2482088 2482088 defendant Kenston Thomas yeoman 592169 592169 Kenston, Thomas, of Burnham Depdale, yeoman 0
5432095 2484568 2484568 defendant Kenston Thomas yeoman 592169 592169 Kenston, Thomas, of Burnham Depdale, yeoman 0
5432327 2484641 2484641 defendant Roper John mariner 592169 592169 Roper, John, of Burnham Depdale, mariner 1
5448480 2489441 2489441 defendant Roper John, junior mariner 592169 592169 Roper, John, junior, of Burnham Depdale, mariner 1
5483648 2500060 2500060 defendant Kenston Thomas yeoman 592169 592169 Kenston, Thomas, of Burnham Depdale, yeoman 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);