names

73 rows where place_id = 611254

✎ 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
3687594 1922293 1922293 defendant Rede Richard mariner 611254 611254 Rede, Richard, of Bedeford, mariner 5
3687595 1922293 1922293 defendant Mawgrege John husbandman 611254 611254 Mawgrege, John, of Bedeford, husbandman 6
3791626 1955222 1955222 defendant Stanley Thomas harper 611254 611254 Stanley, Thomas, of Bedeford, harper 0
3854353 1975001 1975001 defendant Osborne Thomas gent 611254 611254 Osborne, Thomas, of Bedeford, gent 0
3854354 1975001 1975001 defendant Bole William carver 611254 611254 Bole, William, of Bedeford, carver 1
4185601 2090470 2090470 defendant Carye Gabriel gent 611254 611254 Carye, Gabriel, of Bedeford, gent 0
4413355 2169053 2169053 plaintiff Bassot Walter   611254 611254 Bassot, Walter, of Bedeford 0
4414893 2169557 2169557 plaintiff Feroun Nicholas   611254 611254 Feroun, Nicholas, of Bedeford 0
4441814 2182376 2182376 plaintiff Brasyere Simon   611254 611254 Brasyere, Simon, of Bedeford 0
4447222 2184039 2184039 defendant Roger John   611254 611254 Roger, John, of Bedeford 0
4448171 2184348 2184348 defendant Hunte Arnold shoemaker 611254 611254 Hunte, Arnold, of Bedeford, shoemaker 1
4459054 2187876 2187876 defendant Frereman Richard   611254 611254 Frereman, Richard, of Bedeford 0
4459055 2187876 2187876 defendant Rede John   611254 611254 Rede, John, of Bedeford 1
4459219 2187928 2187928 defendant Frereman Richard   611254 611254 Frereman, Richard, of Bedeford 0
4459220 2187928 2187928 defendant Rede John   611254 611254 Rede, John, of Bedeford 1
4459911 2188155 2188155 plaintiff Scot Henry   611254 611254 Scot, Henry, of Bedeford 0
4478445 2193933 2193933 defendant West Henry   611254 611254 West, Henry, of Bedeford 0
4480484 2194559 2194559 defendant Walton Nicholas   611254 611254 Walton, Nicholas, of Bedeford 0
4516232 2205484 2205484 defendant Forster Hugh   611254 611254 Forster, Hugh, of Bedeford 3
4523357 2207626 2207626 defendant Tailour Thomas fisher 611254 611254 Tailour, Thomas, of Bedeford, fisher 1
4530024 2209680 2209680 plaintiff Newebolt John   611254 611254 Newebolt, John, of Bedeford 0
4538832 2212416 2212416 defendant Elmystowe John   611254 611254 Elmystowe, John, of Bedeford 0
4538836 2212417 2212417 defendant Elvestowe John   611254 611254 Elvestowe, John, of Bedeford 0
4543955 2214017 2214017 plaintiff Bakere Walter   611254 611254 Bakere, Walter, of Bedeford 0
4555512 2217655 2217655 plaintiff Hermer Nicholas   611254 611254 Hermer, Nicholas, of Bedeford 0
4555513 2217655 2217655 plaintiff Auborn Henry   611254 611254 Auborn, Henry, of Bedeford 1
4557067 2218137 2218137 defendant Lorde John   611254 611254 Lorde, John, of Bedeford 1
4559623 2218962 2218962 defendant Braybroke Maud   611254 611254 Braybroke, Maud, of Bedeford 0
4561326 2219492 2219492 plaintiff Cook William   611254 611254 Cook, William, of Bedeford 1
4565056 2220640 2220640 defendant Grey John   611254 611254 Grey, John, of Bedeford 0
4571699 2222728 2222728 plaintiff Anborn or Auborn Henry clerk 611254 611254 Anborn or Auborn, Henry, of Bedeford, clerk 0
4571700 2222728 2222728 defendant atte Ree John fuller 611254 611254 atte Ree, John, of Bedeford, fuller 0
4571701 2222728 2222728 defendant Chaloner William   611254 611254 Chaloner, William, of Bedeford 1
4571704 2222728 2222728 defendant Bocher Geoffrey   611254 611254 Bocher, Geoffrey, of Bedeford 4
4572742 2223015 2223015 plaintiff atte Wode Richard   611254 611254 atte Wode, Richard, of Bedeford 0
4573061 2223110 2223110 plaintiff Bakere Walter   611254 611254 Bakere, Walter, of Bedeford 0
4573176 2223146 2223146 defendant Beek Nicholas   611254 611254 Beek, Nicholas, of Bedeford 0
4575901 2223951 2223951 plaintiff Brasyer Simon   611254 611254 Brasyer, Simon, of Bedeford 0
4579912 2225205 2225205 defendant Dunstall Roger   611254 611254 Dunstall, Roger, of Bedeford 0
4582251 2225887 2225887 defendant Hermer John   611254 611254 Hermer, John, of Bedeford 0
4589029 2227945 2227945 defendant Beek Nicholas   611254 611254 Beek, Nicholas, of Bedeford, tallow chandler 0
4592384 2228969 2228969 defendant atte Wode Richard   611254 611254 atte Wode, Richard, of Bedeford 0
4595026 2229702 2229702 defendant Beke Nicholas   611254 611254 Beke, Nicholas, of Bedeford 0
4595027 2229703 2229703 plaintiff Pyrewell Ralph   611254 611254 Pyrewell, Ralph, of Bedeford 0
4595028 2229703 2229703 defendant Kervere William   611254 611254 Kervere, William, of Bedeford 0
4595121 2229729 2229729 defendant Cressale Robert glasier 611254 611254 Cressale, Robert, of Bedeford, glasier 3
4595130 2229730 2229730 defendant Cressale Robert glasier 611254 611254 Cressale, Robert, of Bedeford, glasier 4
4597321 2230401 2230401 defendant Strixton John   611254 611254 Strixton, John, of Bedeford 0
4597322 2230401 2230401 defendant Hermer John   611254 611254 Hermer, John, of Bedeford 1
4597323 2230401 2230401 defendant Smyth Richard   611254 611254 Smyth, Richard, of Bedeford 2
4601532 2231703 2231703 plaintiff Walcheman Ralph   611254 611254 Walcheman, Ralph, of Bedeford 0
4601533 2231703 2231703 defendant Barton John   611254 611254 Barton, John, of Bedeford 0
4603361 2232246 2232246 defendant Fissher Richard   611254 611254 Fissher, Richard, of Bedeford 0
4609469 2234064 2234064 defendant Pope Geoffrey chandler 611254 611254 Pope, Geoffrey, of Bedeford, chandler 0
4612455 2234961 2234961 defendant Fynche John, sen   611254 611254 Fynche, John, sen, of Bedeford 0
4613084 2235148 2235148 defendant Dykon Thomas   611254 611254 Dykon, Thomas, of Bedeford 8
4630325 2240395 2240395 defendant Nowell John   611254 611254 Nowell, John, of Bedeford 1
4630326 2240395 2240395 defendant White John spicer 611254 611254 White, John, of Bedeford, spicer 2
4630329 2240395 2240395 defendant Webbe John   611254 611254 Webbe, John, of Bedeford 5
4630888 2240553 2240553 defendant Cardemaker John   611254 611254 Cardemaker, John, of Bedeford 2
4638952 2242916 2242916 defendant Nowell John   611254 611254 Nowell, John, of Bedeford 0
4640890 2243434 2243434 defendant Wyllyce Simon   611254 611254 Wyllyce, Simon, of Bedeford, brass worker 0
4667002 2255412 2255412 defendant Walsokene John milner 611254 611254 Walsokene, John, of Bedeford, milner 0
4691389 2262831 2262831 defendant Newell John yeoman 611254 611254 Newell, John, of Bedeford, yeoman 0
4743915 2278747 2278747 defendant Robynson Richard husbandman 611254 611254 Robynson, Richard, of Bedeford, husbandman 1
4743916 2278747 2278747 defendant Croft Richard de husbandman 611254 611254 Croft, Richard de, of Bedeford, husbandman 2
4743921 2278748 2278748 defendant Robynson Richard husbandman 611254 611254 Robynson, Richard, of Bedeford, husbandman 1
4743922 2278748 2278748 defendant Croft Richard de husbandman 611254 611254 Croft, Richard de, of Bedeford, husbandman 2
4777805 2289048 2289048 plaintiff Barkeby Robert   611254 611254 Barkeby, Robert, of Bedeford 0
4799670 2296080 2296080 defendant Hardekeyn John yeoman 611254 611254 Hardekeyn, John, of Bedeford, yeoman 1
5592405 2532610 2532610 defendant Powlyn Thomas merchant 611254 611254 Powlyn, Thomas, of Bedeford, merchant 1
5592406 2532610 2532610 defendant Beste John merchant 611254 611254 Beste, John, of Bedeford, merchant 2
5621104 2550482 2550482 defendant Bere John   611254 611254 Bere, John, of Bedeford, cook 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);