names

40 rows where place_id = 595869

✎ 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
3592286 1865200 1865200 plaintiff Fyssh John   595869 595869 Fyssh, John, of South Lynne, bachelor of law 0
3622182 1874472 1874472 defendant Smetone William husbandman 595869 595869 Smetone, William, of South Lynne, husbandman 1
3853029 1974566 1974566 defendant Brendall William yeoman 595869 595869 Brendall, William, of South Lynne, yeoman 1
3854516 1975052 1975052 defendant Knape Thomas laborer 595869 595869 Knape, Thomas, of South Lynne, laborer 0
3875045 1981882 1981882 defendant Knape John butcher 595869 595869 Knape, John, of South Lynne, butcher 0
3998536 2024215 2024215 defendant Lemynge Robert husbandman 595869 595869 Lemynge, Robert, of South Lynne, husbandman 1
4539932 2212756 2212756 defendant Taillour Ralph   595869 595869 Taillour, Ralph, of South Lynne 0
4561239 2219476 2219476 defendant Doune John   595869 595869 Doune, John, of South Lynne, chaplain, son of Thomas 2
4561240 2219476 2219476 defendant Doune Thomas   595869 595869 Doune, Thomas, of South Lynne 3
4563475 2220147 2220147 defendant Baker John   595869 595869 Baker, John, of South Lynne 0
4563477 2220148 2220148 defendant Bakere John   595869 595869 Bakere, John, of South Lynne 0
4567675 2221453 2221453 defendant Hobbesson Bartholomew tailor 595869 595869 Hobbesson, Bartholomew, of South Lynne, tailor 0
4617417 2236459 2236459 plaintiff Goudwene John   595869 595869 Goudwene, John, of South Lynne 0
4740649 2277782 2277782 defendant Rose William weaver 595869 595869 Rose, William, of South Lynne, weaver 0
4830617 2305598 2305598 defendant Squye Robert smith 595869 595869 Squye, Robert, of of South Lynne, smith 0
4856759 2313488 2313488 defendant Squyre Robert smith 595869 595869 Squyre, Robert, of South Lynne, smith 0
4876318 2319556 2319556 plaintiff Sithe John   595869 595869 Sithe, John, of South Lynne 0
4882312 2321378 2321378 defendant Weller John yeoman 595869 595869 Weller, John, of South Lynne, yeoman 0
4905018 2328176 2328176 defendant Steven Simon baker 595869 595869 Steven, Simon, of South Lynne, baker 0
4990266 2353995 2353995 defendant Woddesende John yeoman 595869 595869 Woddesende, John, of South Lynne, yeoman 1
5008026 2359238 2359238 defendant Carpenere Robert tanner 595869 595869 Carpenere, Robert, of South Lynne, tanner 0
5009542 2359670 2359670 defendant Baxter Simon brewer 595869 595869 Baxter, Simon, of South Lynne, brewer 0
5009544 2359671 2359671 defendant Baxter Simon brewer 595869 595869 Baxter, Simon, of South Lynne, brewer 0
5073212 2378476 2378476 plaintiff Ylff John   595869 595869 Ylff, John, of South Lynne 1
5112545 2390049 2390049 defendant Jangil Richard yeoman 595869 595869 Jangil, Richard, of South Lynne, yeoman 0
5119436 2392111 2392111 defendant Fraunsham Nicholas brewer 595869 595869 Fraunsham, Nicholas, of South Lynne, brewer 1
5186759 2411874 2411874 defendant Jekson John (legal representative) 595869 595869 Jekson, John, of South Lynne, executors of 0
5186760 2411874 2411874 defendant Norys John clerk 595869 595869 (Norys, John, of South Lynne, clerk 1
5205355 2417320 2417320 defendant Jekson John (legal representative) 595869 595869 Jekson, John, of South Lynne, executors of 0
5205356 2417320 2417320 defendant Norys John clerk 595869 595869 (Norys, John, of South Lynne, clerk 1
5218824 2421230 2421230 defendant White William yeoman 595869 595869 White, William, of South Lynne, yeoman 3
5219985 2421555 2421555 defendant Braunche Thomas yeoman 595869 595869 Braunche, Thomas, of South Lynne, yeoman 3
5250441 2430247 2430247 defendant Fraunsham Nicholas husbandman 595869 595869 Fraunsham, Nicholas, of South Lynne, husbandman 0
5274870 2437734 2437734 defendant Palmer William shoemaker 595869 595869 Palmer, William, of South Lynne, shoemaker 0
5274871 2437734 2437734 defendant Sharp Hugh shoemaker 595869 595869 Sharp, Hugh, of South Lynne, shoemaker 1
5282834 2440040 2440040 defendant Houghton Robert yeoman 595869 595869 Houghton, Robert, of South Lynne, yeoman 3
5282842 2440041 2440041 defendant Hougham Robert yeoman 595869 595869 Hougham, Robert, of South Lynne, yeoman 4
5374518 2467634 2467634 defendant Nytegale John yeoman 595869 595869 Nytegale, John, of South Lynne, yeoman 0
5409304 2477752 2477752 defendant Sampson Nicholas   595869 595869 Sampson, Nicholas, of South Lynne, wax chandler 0
5509303 2507762 2507762 defendant Bolton Gabriel innholder 595869 595869 Bolton, Gabriel, of South Lynne, innholder 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);