names

44 rows where place_id = 689591

✎ 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
4081144 2053567 2053567 plaintiff Wetheryngton Robert gent 689591 689591 Wetheryngton, Robert, of Spofford, gent 0
4487527 2196816 2196816 plaintiff Smyth Robert   689591 689591 Smyth, Robert, of Spofford 0
4487530 2196816 2196816 defendant Helwys Roger   689591 689591 Helwys, Roger, of Spofford 0
4689833 2262377 2262377 defendant Coghill William butcher 689591 689591 Coghill, William, of Spofford, butcher 4
4801240 2296572 2296572 defendant Thuresby Richard yeoman 689591 689591 Thuresby, Richard, of Spofford, yeoman 0
4812474 2300014 2300014 defendant Pan John tanner 689591 689591 Pan, John, of Spofford, tanner 0
4860415 2314622 2314622 plaintiff Clerk John   689591 689591 Clerk, John, of Spofford 0
4860419 2314623 2314623 plaintiff Clerk John   689591 689591 Clerk, John, of Spofford 0
4877087 2319803 2319803 defendant Blase Roger yeoman 689591 689591 Blase, Roger, of Spofford, yeoman 1
4877088 2319803 2319803 defendant White Richard yeoman 689591 689591 White, Richard, of Spofford, yeoman 2
4878715 2320282 2320282 defendant Galaway William barker 689591 689591 Galaway, William, of Spofford, barker 4
4880912 2320937 2320937 defendant Tiplyng Robert husbandman 689591 689591 Tiplyng, Robert, of Spofford, husbandman 0
4913381 2330684 2330684 plaintiff Clerk Nicholas   689591 689591 Clerk, Nicholas, of Spofford, parson, on his own account 0
4913383 2330685 2330685 plaintiff Clerk Nicholas   689591 689591 Clerk, Nicholas, of Spofford, parson, on his own account 0
4930501 2335941 2335941 defendant Doweson John shoemaker 689591 689591 Doweson, John, of Spofford, shoemaker 1
4956626 2343938 2343938 defendant Clerk John yeoman 689591 689591 Clerk, John, of Spofford, yeoman 2
4956631 2343939 2343939 defendant Tiplyng Robert husbandman 689591 689591 Tiplyng, Robert, of Spofford, husbandman 3
4956632 2343939 2343939 defendant Coke Henry husbandman 689591 689591 Coke, Henry, of Spofford, husbandman 4
4964382 2346263 2346263 defendant Blase Roger (legal representative) 689591 689591 Blase, Roger, of Spofford, yeoman, executor of 0
4964930 2346425 2346425 defendant Lawerens John   689591 689591 Lawerens, John, of Spofford, servant 0
4977122 2350111 2350111 defendant Clerk John yeoman 689591 689591 Clerk, John, of Spofford, yeoman 0
4992051 2354512 2354512 defendant Lytton John miller 689591 689591 Lytton, John, of Spofford, miller 0
4992055 2354513 2354513 defendant Lytton John miller 689591 689591 together with Lytton, John, of Spofford, miller 1
5017819 2362092 2362092 plaintiff Clerk John parker 689591 689591 Clerk, John, of Spofford, parker 0
5018266 2362226 2362226 defendant Clerk John yeoman 689591 689591 Clerk, John, of Spofford, yeoman 0
5032199 2366296 2366296 defendant Fletcher William chapman 689591 689591 Fletcher, William, of Spofford, chapman 1
5081699 2381031 2381031 defendant Ive John collier 689591 689591 Ive, John, of Spofford, collier 1
5081708 2381031 2381031 defendant Taillour John laborer 689591 689591 Taillour, John, of Spofford, laborer 10
5112145 2389938 2389938 defendant Rande Robert yeoman 689591 689591 Rande, Robert, of Spofford, yeoman 0
5112146 2389938 2389938 defendant Walker Thomas yeoman 689591 689591 Walker, Thomas, of Spofford, yeoman 1
5148835 2400781 2400781 defendant Walker Thomas yeoman 689591 689591 Walker, Thomas, of Spofford, yeoman 2
5148836 2400781 2400781 defendant Rande Robert yeoman 689591 689591 Rande, Robert, of Spofford, yeoman 3
5227512 2423672 2423672 defendant Saxston Richard yeoman 689591 689591 Saxston, Richard, of Spofford, yeoman 0
5265854 2435072 2435072 defendant Paner or Paver Henry husbandman 689591 689591 Paner or Paver, Henry, of Spofford, husbandman 4
5297817 2444369 2444369 defendant Saxton Edward yeoman 689591 689591 Saxton, Edward, of Spofford, yeoman 0
5297822 2444370 2444370 defendant Saxton Edward yeoman 689591 689591 Saxton, Edward, of Spofford, yeoman 0
5352775 2460955 2460955 defendant Bykerton John yeoman 689591 689591 Bykerton, John, of Spofford, yeoman 2
5352776 2460955 2460955 defendant Malton John yeoman 689591 689591 Malton, John, of Spofford, yeoman 3
5377776 2468632 2468632 defendant Thorneton Robert laborer 689591 689591 Thorneton, Robert, of Spofford, laborer 6
5391707 2472702 2472702 defendant Gyll Bernard yeoman 689591 689591 Gyll, Bernard, of Spofford, yeoman 2
5416920 2479975 2479975 defendant Ramson William   689591 689591 Ramson, William, of Spofford 3
5523862 2512286 2512286 defendant Vauser John   689591 689591 Vauser, John, of Spofford, mason 1
5542492 2517774 2517774 defendant Sexten Thomas yeoman 689591 689591 Sexten, Thomas, of Spofford, yeoman 0
5542494 2517774 2517774 defendant Saxton Richard, senior yeoman 689591 689591 Saxton, Richard, senior, of Spofford, 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);