names

37 rows where place_id = 594944

✎ 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
3618219 1873322 1873322 defendant Lewen Simon laborer 594944 594944 Lewen, Simon, of Bromeley, laborer 0
3656811 1912385 1912385 defendant Sympson (illegible) laborer 594944 594944 Sympson, ----, of Bromeley, laborer 3
3656815 1912386 1912386 defendant Symson Robert laborer 594944 594944 Symson, Robert, of Bromeley, laborer 0
3656817 1912387 1912387 defendant Symson Robert laborer 594944 594944 Symson, Robert, of Bromeley, laborer 0
3812593 1961826 1961826 defendant Robynson William tailor 594944 594944 Robynson, William, of Bromeley, tailor 1
3812594 1961826 1961826 defendant Wyllyams Thomas porter 594944 594944 Wyllyams, Thomas, of Bromeley, porter 2
3949075 2006743 2006743 defendant Love Simon gent 594944 594944 Love, Simon, of Bromeley, gent 0
3949076 2006743 2006743 defendant Welles Rowland laborer 594944 594944 Welles, Rowland, of Bromeley, laborer 1
3999200 2024468 2024468 defendant Frenche Stephen husbandman 594944 594944 Frenche, Stephen, of Bromeley, husbandman 0
3999201 2024468 2024468 defendant Frenche Thomas husbandman 594944 594944 Frenche, Thomas, of Bromeley, husbandman 1
4651209 2246384 2246384 defendant Kere John husbandman 594944 594944 Kere, John, of Bromeley, husbandman 0
4651210 2246384 2246384 defendant Kere William husbandman 594944 594944 Kere, William, of Bromeley, husbandman 1
4651211 2246384 2246384 defendant Kere Thomas husbandman 594944 594944 Kere, Thomas, of Bromeley, husbandman 2
4651213 2246385 2246385 defendant Kere John husbandman 594944 594944 Kere, John, of Bromeley, husbandman 0
4651214 2246385 2246385 defendant Kere William husbandman 594944 594944 Kere, William, of Bromeley, husbandman 1
4651215 2246385 2246385 defendant Kere Thomas husbandman 594944 594944 Kere, Thomas, of Bromeley, husbandman 2
4695856 2264188 2264188 defendant Hampton Geoffrey gent 594944 594944 Hampton, Geoffrey, of Bromeley, gent 0
4701652 2265908 2265908 defendant Mathewe Thomas husbandman 594944 594944 Mathewe, Thomas, of Bromeley, husbandman 0
4916244 2331585 2331585 defendant Aleyn John mercer 594944 594944 Aleyn, John, of Bromeley, mercer 3
5229477 2424234 2424234 defendant Tynton William   594944 594944 Tynton, William, of Bromeley, servant 0
5442561 2487692 2487692 defendant Bothe Randolf gent 594944 594944 Bothe, Randolf, of Bromeley, gent 1
5455272 2491495 2491495 defendant Bothe Randolf gent 594944 594944 Bothe, Randolf, of Bromeley, gent 1
5482260 2499638 2499638 defendant Shotte Robert yeoman 594944 594944 Shotte, Robert, of Bromeley, yeoman 1
5482261 2499638 2499638 defendant Bedell Henry yeoman 594944 594944 Bedell, Henry, of Bromeley, yeoman 2
5482433 2499685 2499685 defendant Shotte Robert yeoman 594944 594944 Shotte, Robert, of Bromeley, yeoman 1
5482434 2499685 2499685 defendant Bedell Henry yeoman 594944 594944 Bedell, Henry, of Bromeley, yeoman 2
5502691 2505759 2505759 defendant Miller William gent 594944 594944 Miller, William, of Bromeley, gent 1
5519353 2510900 2510900 defendant A Dene Thomas husbandman 594944 594944 A Dene, Thomas, of Bromeley, husbandman 1
5529078 2513612 2513612 defendant Strode William husbandman 594944 594944 Strode, William, of Bromeley, husbandman 0
5529079 2513612 2513612 defendant Elys William   594944 594944 Elys, William, of Bromeley, book maker 1
5531807 2514490 2514490 defendant Saverey William husbandman 594944 594944 Saverey, William, of Bromeley, husbandman 0
5531809 2514491 2514491 defendant Savery William husbandman 594944 594944 Savery, William, of Bromeley, husbandman 0
5534985 2515473 2515473 defendant Bedyll Thomas yeoman 594944 594944 Bedyll, Thomas, of Bromeley, yeoman 2
5534987 2515473 2515473 defendant Bradshawe Roger (legal representative) 594944 594944 Bradshawe, Roger, of Bromeley, yeoman, executrix of 4
5534988 2515473 2515473 defendant Bradshawe Katherine widow 594944 594944 Bradshawe, Katherine, of Bromeley, widow 5
5578064 2528209 2528209 defendant Croxston William yeoman 594944 594944 Croxston, William, of Bromeley, yeoman 1
5578071 2528211 2528211 defendant Croxston William yeoman 594944 594944 Croxston, William, of Bromeley, yeoman 2

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);