names

40 rows where place_id = 593228

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610987 1871114 1871114 defendant Holme William yeoman 593228 593228 Holme, William, of Saxby, yeoman 1
3610988 1871114 1871114 defendant Harnes Richard husbandman 593228 593228 Harnes, Richard, of Saxby, husbandman 2
3798843 1957553 1957553 plaintiff Holme Robert   593228 593228 Holme, Robert, of Saxby 0
3798845 1957554 1957554 plaintiff Holme Robert   593228 593228 Holme, Robert, of Saxby 0
3999983 2024758 2024758 defendant Blandsherd Thomas gent 593228 593228 Blandsherd, Thomas, of Saxby, gent 0
4056313 2044643 2044643 defendant Browne Thomas laborer 593228 593228 Browne, Thomas, of Saxby, laborer 0
4056314 2044643 2044643 defendant Moyses Nicholas laborer 593228 593228 Moyses, Nicholas, of Saxby, laborer 1
4056315 2044643 2044643 defendant Kelsey William husbandman 593228 593228 Kelsey, William, of Saxby, husbandman 2
4058671 2045492 2045492 defendant Saunderson Robert esq 593228 593228 Saunderson, Robert, of Saxby, esq 0
4470903 2191550 2191550 defendant Barnesby William   593228 593228 Barnesby, William, of Saxby, parson 0
4492620 2198394 2198394 defendant Martyn Henry   593228 593228 Martyn, Henry, of Saxby 0
4495372 2199232 2199232 defendant Rose William   593228 593228 Rose, William, of Saxby 0
4501980 2201217 2201217 defendant Baghton John   593228 593228 Baghton, John, of Saxby 0
4507600 2202838 2202838 defendant Tomson John   593228 593228 Tomson, John, of Saxby 0
4528604 2209226 2209226 defendant Martyn Henry   593228 593228 Martyn, Henry, of Saxby 0
4548209 2215382 2215382 defendant Shephird Thomas   593228 593228 Shephird, Thomas, of Saxby 0
4548211 2215382 2215382 defendant Payn John   593228 593228 Payn, John, of Saxby 2
4548212 2215382 2215382 defendant Jackesson John   593228 593228 Jackesson, John, of Saxby 3
4551829 2216518 2216518 defendant Epworth John   593228 593228 Epworth, John, of Saxby 0
4599327 2231007 2231007 defendant Stak William   593228 593228 Stak, William, of Saxby 0
4601462 2231693 2231693 defendant Bercotes John   593228 593228 Bercotes, John, of Saxby 4
4613702 2235297 2235297 defendant Arundell John   593228 593228 Arundell, John, of Saxby 0
4774402 2287977 2287977 defendant Wadworth John husbandman 593228 593228 Wadworth, John, of Saxby, husbandman 1
4850635 2311657 2311657 defendant Moryell John husbandman 593228 593228 Moryell, John, of Saxby, husbandman 3
4954282 2343253 2343253 defendant Holme William husbandman 593228 593228 Holme, William, of Saxby, husbandman 0
5122642 2393054 2393054 defendant Glade John clerk 593228 593228 Glade, John, of Saxby, clerk 2
5139255 2397971 2397971 defendant Westemere John husbandman 593228 593228 Westemere, John, of Saxby, husbandman 2
5160166 2404074 2404074 defendant Westentere John husbandman 593228 593228 Westentere, John, of Saxby, husbandman 2
5175043 2408394 2408394 defendant Westemere John husbandman 593228 593228 Westemere, John, of Saxby, husbandman 2
5196035 2414588 2414588 defendant Westemere John husbandman 593228 593228 Westemere, John, of Saxby, husbandman 2
5222465 2422284 2422284 defendant Martyn John husbandman 593228 593228 Martyn, John, of Saxby, husbandman 1
5222466 2422284 2422284 defendant Waterhous William husbandman 593228 593228 Waterhous, William, of Saxby, husbandman 2
5238331 2426798 2426798 defendant Broke Robert husbandman 593228 593228 Broke, Robert, of Saxby, husbandman 0
5247549 2429438 2429438 defendant Browe Richard yeoman 593228 593228 Browe, Richard, of Saxby, yeoman 1
5278404 2438791 2438791 defendant Baker Robert yeoman 593228 593228 Baker, Robert, of Saxby, yeoman 0
5391040 2472507 2472507 defendant Williamson John husbandman 593228 593228 Williamson, John, of Saxby, husbandman 2
5527263 2513104 2513104 defendant Smyth John husbandman 593228 593228 Smyth, John, of Saxby, husbandman 0
5555684 2521657 2521657 defendant Redysh Richard chaplain 593228 593228 Redysh, Richard, of Saxby, chaplain 2
5609866 2546791 2546791 defendant Bate William   593228 593228 Bate, William, of Saxby 0
5609867 2546791 2546791 defendant Cartyn John   593228 593228 Cartyn, John, of Saxby 1

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