names

42 rows where place_id = 593306

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611288 1871205 1871205 defendant Wady John husbandman 593306 593306 Wady, John, of Bramham, husbandman 1
3611289 1871205 1871205 defendant Wilde Thomas husbandman 593306 593306 Wilde, Thomas, of Bramham, husbandman 2
3619061 1873565 1873565 defendant Taillour Thomas husbandman 593306 593306 Taillour, Thomas, of Bramham, husbandman 0
3619062 1873565 1873565 defendant Scot John husbandman 593306 593306 Scot, John, of Bramham, husbandman 1
3619063 1873565 1873565 defendant tasker William husbandman 593306 593306 tasker, William, of Bramham, husbandman 2
3619064 1873565 1873565 defendant Lorymer Robert laborer 593306 593306 Lorymer, Robert, of Bramham, laborer 3
3619065 1873565 1873565 defendant Corbrig Miles tailor 593306 593306 Corbrig, Miles, of Bramham, tailor 4
3619066 1873565 1873565 defendant Wwanley William husbandman 593306 593306 Wwanley, William, of Bramham, husbandman 5
3619067 1873565 1873565 defendant Wilde William husbandman 593306 593306 Wilde, William, of Bramham, husbandman 6
3619068 1873565 1873565 defendant Leche John laborer 593306 593306 Leche, John, of Bramham, laborer 7
3640402 1907428 1907428 defendant Pygard Thomas yeoman 593306 593306 Pygard, Thomas, of Bramham, yeoman 0
3647840 1909720 1909720 defendant Pygard Thomas yeoman 593306 593306 Pygard, Thomas, of Bramham, yeoman 0
3819582 1964000 1964000 defendant Nettelton Thomas miller 593306 593306 Nettelton, Thomas, of Bramham, miller 0
3867749 1979445 1979445 defendant Brahame Christopher miller 593306 593306 Brahame, Christopher, of Bramham, miller 0
3867750 1979445 1979445 defendant Burgh William yeoman 593306 593306 Burgh, William, of Bramham, yeoman 1
3867752 1979445 1979445 defendant Clogh George yeoman 593306 593306 Clogh, George, of Bramham, yeoman 3
4139156 2074370 2074370 defendant Paver William gent 593306 593306 Paver, William, of Bramham, gent 0
4163890 2082898 2082898 defendant Paver William gent 593306 593306 Paver, William, of Bramham, gent 0
4170450 2085157 2085157 defendant Webster William husbandman 593306 593306 Webster, William, of Bramham, husbandman 2
4230629 2106209 2106209 defendant Whitton Christopher yeoman 593306 593306 Whitton, Christopher, of Bramham, yeoman 0
4230630 2106209 2106209 defendant Whitton William yeoman 593306 593306 Whitton, William, of Bramham, yeoman 1
4309735 2133559 2133559 defendant Whitton Christopher yeoman 593306 593306 Whitton, Christopher, of Bramham, yeoman 2
4312237 2134417 2134417 defendant Cloughe Thomas yeoman 593306 593306 Cloughe, Thomas, of Bramham, yeoman 1
4383423 2159167 2159167 defendant Whitton William yeoman 593306 593306 Whitton, William, of Bramham, yeoman 3
4499127 2200369 2200369 defendant Darlyng John chaplain 593306 593306 Darlyng, John, of Bramham, chaplain 0
4518262 2206086 2206086 defendant Derlyng John chaplain 593306 593306 (Derlyng, John, of Bramham, chaplain 1
4525442 2208291 2208291 defendant Clerk Richard   593306 593306 Clerk, Richard, of Bramham 3
4534343 2211007 2211007 defendant Bergh John   593306 593306 Bergh, John, of Bramham 0
4534345 2211008 2211008 defendant Bergh John   593306 593306 Bergh, John, of Bramham 0
4578729 2224836 2224836 defendant Clerk Richard   593306 593306 Clerk, Richard, of Bramham 0
4746624 2279503 2279503 defendant Lyle John yeoman 593306 593306 Lyle, John, of Bramham, yeoman 0
4763464 2284558 2284558 defendant Vaus Richard yeoman 593306 593306 Vaus, Richard, of Bramham, yeoman 1
4827730 2304722 2304722 defendant Grene John laborer 593306 593306 Grene, John, of Bramham, laborer 0
4865619 2316212 2316212 defendant Brandon Robert husbandman 593306 593306 Brandon, Robert, of Bramham, husbandman 8
4865621 2316212 2316212 defendant Maclake William husbandman 593306 593306 Maclake, William, of Bramham, husbandman 10
4883124 2321646 2321646 defendant Grenehode Robert husbandman 593306 593306 Grenehode, Robert, of Bramham, husbandman 2
5312212 2448686 2448686 defendant Grenehode John yeoman 593306 593306 Grenehode, John, of Bramham, yeoman 0
5364083 2464424 2464424 defendant Wylde William husbandman 593306 593306 Wylde, William, of Bramham, husbandman 2
5528388 2513419 2513419 defendant Netilton William yeoman 593306 593306 Netilton, William, of Bramham, yeoman 0
5556813 2521952 2521952 defendant Curle Richard husbandman 593306 593306 Curle, Richard, of Bramham, husbandman 0
5556823 2521956 2521956 defendant Nettilton William gent 593306 593306 Nettilton, William, of Bramham, gent 0
5611392 2547295 2547295 defendant del West John   593306 593306 del West, John, of Bramham 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);