names

55 rows where place_id = 598644

✎ 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
3633398 1905259 1905259 defendant Tappynden Robert yeoman 598644 598644 Tappynden, Robert, of Rokynge, yeoman 0
3718841 1932173 1932173 defendant Everell William husbandman 598644 598644 Everell, William, of Rokynge, husbandman 0
3718848 1932173 1932173 defendant Moyse Nicholas husbandman 598644 598644 Moyse, Nicholas, of Rokynge, husbandman 7
3718849 1932173 1932173 defendant Sharpe John husbandman 598644 598644 Sharpe, John, of Rokynge, husbandman 8
3718850 1932173 1932173 defendant Adryan John husbandman 598644 598644 Adryan, John, of Rokynge, husbandman 9
3718851 1932173 1932173 defendant Rose John husbandman 598644 598644 Rose, John, of Rokynge, husbandman 10
3718852 1932173 1932173 defendant Shalner John husbandman 598644 598644 Shalner, John, of Rokynge, husbandmanM Shalner, Stephen, of Rokynge, husbandman 11
3718853 1932173 1932173 defendant Mychell Thomas husbandman 598644 598644 Mychell, Thomas, of Rokynge, husbandman 12
4497974 2200014 2200014 defendant Galden Thomas of the   598644 598644 Galden, Thomas of the, of Rokynge 6
4497982 2200015 2200015 defendant Gelden Thomas of the   598644 598644 Gelden, Thomas of the, of Rokynge 6
4504551 2201980 2201980 defendant Westbery Robert   598644 598644 Westbery, Robert, of Rokynge 2
4557213 2218190 2218190 plaintiff Knoldare John   598644 598644 Knoldare, John, of Rokynge 0
4569136 2221935 2221935 plaintiff Wate John   598644 598644 Wate, John, of Rokynge 0
4569168 2221948 2221948 plaintiff Watte John   598644 598644 Watte, John, of Rokynge 0
4576552 2224177 2224177 plaintiff Brykyndenne John   598644 598644 Brykyndenne, John, of Rokynge 0
4587004 2227338 2227338 defendant Knoldane John, sen   598644 598644 Knoldane, John, sen, of Rokynge 0
4652069 2246583 2246583 defendant Brykendenne John   598644 598644 Brykendenne, John, of Rokynge 0
4695203 2263983 2263983 defendant Adryan Nicholas butcher 598644 598644 Adryan, Nicholas, of Rokynge, butcher 1
4705212 2267000 2267000 plaintiff Knoldane John, sen   598644 598644 Knoldane, John, sen, of Rokynge 0
4721166 2271954 2271954 defendant Knodane Thomas husbandman 598644 598644 Knodane, Thomas, of Rokynge, husbandman 2
4721863 2272172 2272172 defendant Knoldane Thomas laborer 598644 598644 Knoldane, Thomas, of Rokynge, laborer 0
4781511 2290227 2290227 defendant Colyn Walter yeoman 598644 598644 Colyn, Walter, of Rokynge, yeoman 0
4824850 2303809 2303809 defendant Wyndey Stepyen yeoman 598644 598644 Wyndey, Stepyen, of Rokynge, yeoman 0
4824851 2303809 2303809 defendant Colyn or Cobyn Walter   598644 598644 Colyn or Cobyn, Walter, of Rokynge, yeoman, King's bailiff of Redlevet 1
4824866 2303814 2303814 defendant Hochon Roger   598644 598644 Hochon, Roger, of Rokynge, wheel wright 0
4860960 2314787 2314787 defendant Brome Alice widow 598644 598644 Brome, Alice, of Rokynge, widow 0
4882431 2321419 2321419 defendant Croucheman William laborer 598644 598644 Croucheman, William, of Rokynge, laborer 1
4894125 2324858 2324858 defendant Knoldane George husbandman 598644 598644 Knoldane, George, of Rokynge, husbandman 0
4894126 2324858 2324858 defendant Symond William husbandman 598644 598644 Symond, William, of Rokynge, husbandman 1
4894506 2324955 2324955 defendant Hochoun Roger wheeler 598644 598644 Hochoun, Roger, of Rokynge, wheeler 2
4915947 2331484 2331484 defendant Knoldane George husbandman 598644 598644 Knoldane, George, of Rokynge, husbandman 0
4915948 2331484 2331484 defendant Symond William husbandman 598644 598644 Symond, William, of Rokynge, husbandman 1
4930003 2335792 2335792 defendant Hochoun Roger wheeler 598644 598644 Hochoun, Roger, of Rokynge, wheeler 1
4966997 2347061 2347061 defendant Knoldane George husbandman 598644 598644 Knoldane, George, of Rokynge, husbandman 0
4971414 2348378 2348378 defendant Knoldane George husbandman 598644 598644 Knoldane, George, of Rokynge, husbandman 0
4984136 2352187 2352187 defendant Waldysshe William husbandman 598644 598644 Waldysshe, William, of Rokynge, husbandman 0
5052534 2372349 2372349 defendant Halsnoth Richard laborer 598644 598644 Halsnoth, Richard, of Rokynge, laborer 0
5072786 2378345 2378345 defendant Frost Thomas husbandman 598644 598644 Frost, Thomas, of Rokynge, husbandman 0
5097695 2385751 2385751 defendant Frost Thomas husbandman 598644 598644 Frost, Thomas, of Rokynge, husbandman 0
5127599 2394557 2394557 defendant Martyn Richard husbandman 598644 598644 Martyn, Richard, of Rokynge, husbandman 2
5139013 2397902 2397902 defendant Kucldane George yeoman 598644 598644 Kucldane, George, of Rokynge, yeoman 0
5146609 2400145 2400145 defendant Martyn Richard husbandman 598644 598644 Martyn, Richard, of Rokynge, husbandman 2
5159877 2403985 2403985 defendant Knoldane George yeoman 598644 598644 Knoldane, George, of Rokynge, yeoman 0
5166672 2405976 2405976 defendant Martyn Richard husbandman 598644 598644 Martyn, Richard, of Rokynge, husbandman 2
5181639 2410371 2410371 defendant Martyn Richard husbandman 598644 598644 Martyn, Richard, of Rokynge, husbandman 2
5181810 2410424 2410424 defendant Froste Thomas yeoman 598644 598644 Froste, Thomas, of Rokynge, yeoman 0
5233516 2425395 2425395 defendant Knoldan George yeoman 598644 598644 Knoldan, George, of Rokynge, yeoman 0
5269417 2436150 2436150 defendant Symond Thomas husbandman 598644 598644 Symond, Thomas, of Rokynge, husbandman 0
5277256 2438426 2438426 defendant Knoldan George yeoman 598644 598644 Knoldan, George, of Rokynge, yeoman 0
5387776 2471566 2471566 defendant Knoldan Thomas yeoman 598644 598644 Knoldan, Thomas, of Rokynge, yeoman 0
5387777 2471566 2471566 defendant Enoldan Thomas yeoman 598644 598644 Enoldan, Thomas, of Rokynge, yeoman 1
5430189 2483967 2483967 defendant Godard Richard husbandman 598644 598644 Godard, Richard, of Rokynge, husbandman 1
5451046 2490205 2490205 defendant Gore Richard mercer 598644 598644 Gore, Richard, of Rokynge, mercer 0
5611864 2547447 2547447 defendant Colyn John   598644 598644 Colyn, John, of Rokynge 1
5634906 2554910 2554910 plaintiff Walter William   598644 598644 Walter, William, of Rokynge 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);