names

43 rows where place_id = 599419

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626449 1903127 1903127 defendant Nonne Simon   599419 599419 Nonne, Simon, of Sprowton, gent, son of Nonne, John, of Sprowton 0
3636701 1906271 1906271 defendant Felgate John husbandman 599419 599419 Felgate, John, of Sprowton, husbandman 1
3638231 1906778 1906778 defendant Dan William husbandman 599419 599419 Dan, William, of Sprowton, husbandman 0
3742454 1939511 1939511 plaintiff Turnour John   599419 599419 Turnour, John, of Sprowton 0
3742455 1939511 1939511 plaintiff Bull John   599419 599419 Bull, John, of Sprowton 1
3742458 1939511 1939511 plaintiff Crismas William   599419 599419 Crismas, William, of Sprowton 4
3773875 1949540 1949540 defendant Woode Robert laborer 599419 599419 Woode, Robert, of Sprowton, laborer 0
3813810 1962233 1962233 plaintiff Felgate Thomas   599419 599419 Felgate, Thomas, of Sprowton 0
3890800 1987190 1987190 defendant Wright Robert husbandman 599419 599419 Wright, Robert, of Sprowton, husbandman 2
3890803 1987191 1987191 defendant Wryght Robert husbandman 599419 599419 Wryght, Robert, of Sprowton, husbandman 1
3891093 1987288 1987288 defendant Yong John yeoman 599419 599419 Yong, John, of Sprowton, yeoman 0
3944615 2005213 2005213 defendant Bull John yeoman 599419 599419 Bull, John, of Sprowton, yeoman 0
4017051 2030803 2030803 defendant Laurens Thomas yeoman 599419 599419 Laurens, Thomas, of Sprowton, yeoman 0
4080069 2053177 2053177 defendant Pulforde Robert smith 599419 599419 Pulforde, Robert, of Sprowton, smith 1
4104221 2061785 2061785 defendant Rosier James clerk 599419 599419 Rosier, James, of Sprowton, clerk 0
4115116 2065694 2065694 defendant Talmage William gent 599419 599419 Talmage, William, of Sprowton, gent 1
4241870 2110273 2110273 defendant Bunne William husbandman 599419 599419 Bunne, William, of Sprowton, husbandman 1
4243459 2110805 2110805 defendant Sage Thomas yeoman 599419 599419 Sage, Thomas, of Sprowton, yeoman 0
4277557 2122075 2122075 defendant Sage Thomas yeoman 599419 599419 Sage, Thomas, of Sprowton, yeoman 0
4303152 2131228 2131228 defendant Smyth Edward gent 599419 599419 Smyth, Edward, of Sprowton, gent 8
4303157 2131229 2131229 defendant Sage Thomas yeoman 599419 599419 Sage, Thomas, of Sprowton, yeoman 0
4305715 2132136 2132136 defendant Blakye Walter yeoman 599419 599419 Blakye, Walter, of Sprowton, yeoman 0
4305716 2132136 2132136 defendant Saye Thomas yeoman 599419 599419 Saye, Thomas, of Sprowton, yeoman 1
4326276 2139154 2139154 defendant Noble John tailor 599419 599419 Noble, John, of Sprowton, tailor 3
4326789 2139311 2139311 defendant Bland John clothier 599419 599419 Bland, John, of Sprowton, clothier 3
4392859 2162227 2162227 defendant Sage Thomas yeoman 599419 599419 Sage, Thomas, of Sprowton, yeoman 0
5016758 2361792 2361792 defendant Oode Thomas husbandman 599419 599419 Oode, Thomas, of Sprowton, husbandman 0
5376197 2468146 2468146 defendant Parker John husbandman 599419 599419 Parker, John, of Sprowton, husbandman 0
5376991 2468397 2468397 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5376992 2468397 2468397 defendant Ketyll Michael yeoman 599419 599419 Ketyll, Michael, of Sprowton, yeoman 1
5382736 2470125 2470125 defendant Ketyll Mathew yeoman 599419 599419 Ketyll, Mathew, of Sprowton, yeoman 1
5392022 2472798 2472798 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5405051 2476519 2476519 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5419236 2480681 2480681 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5419237 2480681 2480681 defendant Ketyll Michael   599419 599419 Ketyll, Michael, of Sprowton 1
5419723 2480812 2480812 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5435883 2485676 2485676 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5450780 2490123 2490123 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5462899 2493814 2493814 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5463162 2493897 2493897 defendant Felgate William yeoman 599419 599419 Felgate, William, of Sprowton, yeoman 0
5594842 2533355 2533355 defendant Felgate Thomas husbandman 599419 599419 Felgate, Thomas, of Sprowton, husbandman 4
5604419 2536247 2536247 plaintiff Rever John   599419 599419 Rever, John, of Sprowton 1
5607173 2537133 2537133 defendant Martyn Richard gent 599419 599419 Martyn, Richard, of Sprowton, gent 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);