names

38 rows where place_id = 605350

✎ 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
3661276 1913804 1913804 defendant Durbutte John mariner 605350 605350 Durbutte, John, of Snodlond, mariner 0
4980016 2350977 2350977 defendant Crowe Bartholomew butcher 605350 605350 Crowe, Bartholomew, of Snodlond, butcher 1
5042650 2369406 2369406 defendant Goseler John husbandman 605350 605350 Goseler, John, of Snodlond, husbandman 0
5066271 2376439 2376439 defendant Crowe Barthomew butcher 605350 605350 Crowe, Barthomew, of Snodlond, butcher 0
5200381 2415873 2415873 defendant Canon Walter husbandman 605350 605350 Canon, Walter, of Snodlond, husbandman 0
5200382 2415873 2415873 defendant Ussh_ Thomas husbandman 605350 605350 Ussh_, Thomas, of Snodlond, husbandman 1
5211469 2419089 2419089 defendant Canon Walter husbandman 605350 605350 Canon, Walter, of Snodlond, husbandman 0
5211470 2419089 2419089 defendant Ussher Thomas husbandman 605350 605350 Ussher, Thomas, of Snodlond, husbandman 1
5211472 2419089 2419089 defendant Canon Roger husbandman 605350 605350 Canon, Roger, of Snodlond, husbandman 3
5311276 2448401 2448401 defendant Person John husbandman 605350 605350 Person, John, of Snodlond, husbandman 0
5347262 2459311 2459311 defendant Merkelyn Henry husbandman 605350 605350 Merkelyn, Henry, of Snodlond, husbandman 1
5361064 2463486 2463486 defendant Stonyng John   605350 605350 Stonyng, John, of Snodlond, shipwright 0
5364684 2464618 2464618 defendant Nycholet John husbandman 605350 605350 Nycholet, John, of Snodlond, husbandman 1
5392240 2472869 2472869 defendant Barnard John beer brewer 605350 605350 Barnard, John, of Snodlond, beer brewer 2
5392241 2472869 2472869 defendant Frange George clerk 605350 605350 Frange, George, of Snodlond, clerk 3
5405288 2476597 2476597 defendant Frenche George clerk 605350 605350 Frenche, George, of Snodlond, clerk 3
5418367 2480419 2480419 defendant Frenche George clerk 605350 605350 Frenche, George, of Snodlond, clerk 2
5445471 2488543 2488543 defendant Stalworth Robert yeoman 605350 605350 Stalworth, Robert, of Snodlond, yeoman 2
5458243 2492366 2492366 defendant Stalworth Robert yeoman 605350 605350 Stalworth, Robert, of Snodlond, yeoman 2
5471204 2496322 2496322 defendant Waterlade Thomas clerk 605350 605350 Waterlade, Thomas, of Snodlond, clerk 0
5471205 2496322 2496322 defendant Broun John laborer 605350 605350 Broun, John, of Snodlond, laborer 1
5482191 2499615 2499615 defendant Glegon or Elegon John waterman 605350 605350 Glegon or Elegon, John, of Snodlond, waterman 1
5482454 2499691 2499691 defendant Waterlade Thomas clerk 605350 605350 Waterlade, Thomas, of Snodlond, clerk 0
5482455 2499691 2499691 defendant Broun John laborer 605350 605350 Broun, John, of Snodlond, laborer 1
5482457 2499692 2499692 defendant Waterlade Thomas clerk 605350 605350 Waterlade, Thomas, of Snodlond, clerk 0
5482458 2499692 2499692 defendant Broun John laborer 605350 605350 Broun, John, of Snodlond, laborer 1
5482473 2499698 2499698 defendant Stalworth Robert husbandman 605350 605350 Stalworth, Robert, of Snodlond, husbandman 0
5482475 2499699 2499699 defendant Stalworth Robert husbandman 605350 605350 Stalworth, Robert, of Snodlond, husbandman 0
5484271 2500220 2500220 defendant Stonyng John   605350 605350 Stonyng, John, of Snodlond, shipwright 2
5488013 2501305 2501305 defendant Cooke Roger yeoman 605350 605350 Cooke, Roger, of Snodlond, yeoman 0
5488048 2501315 2501315 defendant Waterlade Thomas clerk 605350 605350 Waterlade, Thomas, of Snodlond, clerk 0
5488049 2501315 2501315 defendant Broun John laborer 605350 605350 Broun, John, of Snodlond, laborer 1
5503340 2505954 2505954 defendant Canon William husbabdman 605350 605350 Canon, William, of Snodlond, husbabdman 2
5505453 2506623 2506623 defendant Lancaster William yeoman 605350 605350 Lancaster, William, of Snodlond, yeoman 0
5505455 2506623 2506623 defendant Rous Roger sawyer 605350 605350 Rous, Roger, of Snodlond, sawyer 2
5505459 2506624 2506624 defendant Braunston Thomas laborer 605350 605350 Braunston, Thomas, of Snodlond, laborer 1
5520673 2511289 2511289 defendant Lancastre William yeoman 605350 605350 Lancastre, William, of Snodlond, yeoman 0
5557581 2522172 2522172 defendant Tebold Stephen miller 605350 605350 Tebold, Stephen, of Snodlond, miller 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);