names

29 rows where place_id = 593526

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612248 1871465 1871465 defendant Chaundeler John husbandman 593526 593526 Chaundeler, John, of Kelshale, husbandman 1
3887987 1986233 1986233 defendant Shank Robert husbandman 593526 593526 Shank, Robert, of Kelshale, husbandman 1
4216439 2101244 2101244 defendant Sheppard John husbandman 593526 593526 Sheppard, John, of Kelshale, husbandman 0
4225741 2104468 2104468 defendant Sheppard John husbandman 593526 593526 Sheppard, John, of Kelshale, husbandman 0
4459294 2187956 2187956 plaintiff Roys Robert (legal representative) 593526 593526 Roys, Robert, of Kelshale, executors of 0
4522628 2207416 2207416 defendant Wryght John   593526 593526 Wryght, John, of Kelshale 1
4522633 2207417 2207417 defendant Wryght John   593526 593526 Wryght, John, of Kelshale 1
4548914 2215593 2215593 defendant Colvyle John   593526 593526 Colvyle, John, of Kelshale, son of John 2
4548915 2215593 2215593 defendant Colvyle Robert butcher 593526 593526 Colvyle, Robert, of Kelshale, butcher 3
4548920 2215594 2215594 defendant Colvyle John   593526 593526 Colvyle, John, of Kelshale, son of John 3
4548921 2215594 2215594 defendant Colvyle Robert butcher 593526 593526 Colvyle, Robert, of Kelshale, butcher 4
4657877 2248350 2248350 plaintiff Colvyle John   593526 593526 Colvyle, John, of Kelshale 0
4657882 2248351 2248351 plaintiff Colvyle John   593526 593526 Colvyle, John, of Kelshale 0
4679404 2259174 2259174 defendant Colvyll John husbandman 593526 593526 Colvyll, John, of Kelshale, husbandman 1
4679408 2259175 2259175 defendant Colvyll John husbandman 593526 593526 Colvyll, John, of Kelshale, husbandman 1
4679713 2259272 2259272 defendant Colvyle John butcher 593526 593526 Colvyle, John, of Kelshale, butcher 1
4686972 2261533 2261533 defendant Colvyll John butcher 593526 593526 Colvyll, John, of Kelshale, butcher 0
4887141 2322823 2322823 defendant Colvyll Thomas yeoman 593526 593526 Colvyll, Thomas, of Kelshale, yeoman 0
4998376 2356389 2356389 defendant Michell Robert husbandman 593526 593526 Michell, Robert, of Kelshale, husbandman 0
5071227 2377892 2377892 defendant Braunche alias Lynde Nicholas husbandman 593526 593526 Braunche alias Lynde, Nicholas, of Kelshale, husbandman 0
5071228 2377892 2377892 defendant Antilby William weaver 593526 593526 Antilby, William, of Kelshale, weaver 1
5154175 2402378 2402378 defendant Johnson Peter yeoman 593526 593526 Johnson, Peter, of Kelshale, yeoman 0
5154176 2402378 2402378 defendant Pynteney Clement tailor 593526 593526 Pynteney, Clement, of Kelshale, tailor 1
5171328 2407340 2407340 defendant Johnson Peter yeoman 593526 593526 Johnson, Peter, of Kelshale, yeoman 0
5171329 2407340 2407340 defendant Pynteney Clement tailor 593526 593526 Pynteney, Clement, of Kelshale, tailor 1
5340692 2457289 2457289 defendant Bolnesse Waren husbandman 593526 593526 Bolnesse, Waren, of Kelshale, husbandman 0
5340693 2457289 2457289 defendant Wyllyams William husbandman 593526 593526 Wyllyams, William, of Kelshale, husbandman 1
5360520 2463319 2463319 defendant Kempe William (legal representative) 593526 593526 Kempe, William, of Kelshale, chapman, executor of 0
5568831 2525435 2525435 defendant Bysshop John yeoman 593526 593526 Bysshop, John, of Kelshale, 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);