names

62 rows where place_id = 593217

✎ 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
3610953 1871099 1871099 defendant Kettyll Thomas yeoman 593217 593217 Kettyll, Thomas, of Wysebeche, yeoman 1
4467729 2190584 2190584 defendant Roddyk William   593217 593217 Roddyk, William, of Wysebeche 0
4490943 2197861 2197861 defendant Taverner Alexander   593217 593217 Taverner, Alexander, of Wysebeche 0
4491283 2197963 2197963 defendant Rytelond Robert   593217 593217 Rytelond, Robert, of Wysebeche 0
4495660 2199321 2199321 plaintiff Caunvyle John   593217 593217 Caunvyle, John, of Wysebeche 0
4495664 2199322 2199322 plaintiff Caunvyle John   593217 593217 Caunvyle, John, of Wysebeche, on his own account 0
4496800 2199667 2199667 plaintiff Dacoun John   593217 593217 Dacoun, John, of Wysebeche, on his own account 0
4496801 2199667 2199667 defendant Smyth Richard   593217 593217 Smyth, Richard, of Wysebeche 0
4513617 2204685 2204685 plaintiff Broustere Hugh (legal representative) 593217 593217 Broustere, Hugh, of Wysebeche, executors of 0
4556918 2218095 2218095 plaintiff Keep William (legal representative) 593217 593217 Keep, William, of Wysebeche, executors of 0
4556923 2218096 2218096 plaintiff Keep William (legal representative) 593217 593217 Keep, William, of Wysebeche, executors of 0
4556928 2218096 2218096 defendant Taillour Thomas   593217 593217 Taillour, Thomas, of Wysebeche 2
4558195 2218504 2218504 defendant Listere Geoffrey   593217 593217 Listere, Geoffrey, of Wysebeche 0
4560821 2219342 2219342 defendant Halman John   593217 593217 Halman, John, of Wysebeche 1
4575127 2223743 2223743 defendant Bolle Thomas   593217 593217 Bolle, Thomas, of Wysebeche 0
4578293 2224704 2224704 plaintiff Tulyet Roger   593217 593217 Tulyet, Roger, of Wysebeche 1
4582939 2226092 2226092 plaintiff Fisshere Thomas   593217 593217 Fisshere, Thomas, of Wysebeche 0
4582945 2226092 2226092 defendant Kyng Thomas   593217 593217 Kyng, Thomas, of Wysebeche 5
4616700 2236225 2236225 defendant Baret Robert   593217 593217 Baret, Robert, of Wysebeche 0
4640829 2243417 2243417 defendant Fissher Thomas   593217 593217 Fissher, Thomas, of Wysebeche 0
4650968 2246301 2246301 defendant Blower Thomas husbandman 593217 593217 Blower, Thomas, of Wysebeche, husbandman 2
4650969 2246301 2246301 defendant Averell Simon husbandman 593217 593217 Averell, Simon, of Wysebeche, husbandman 3
4698127 2264902 2264902 defendant Judde John clerk & perpetual vicar 593217 593217 Judde, John, of Wysebeche, clerk & perpetual vicar 0
4698129 2264903 2264903 defendant Judde John clerk & perpetual vicar 593217 593217 Judde, John, of Wysebeche, clerk & perpetual vicar 0
4701276 2265800 2265800 plaintiff Fyssher Thomas   593217 593217 Fyssher, Thomas, of Wysebeche 0
4701278 2265801 2265801 plaintiff Fyssher Thomas   593217 593217 Fyssher, Thomas, of Wysebeche 0
4721244 2271974 2271974 defendant Spellowe Adam fishmonger 593217 593217 Spellowe, Adam, of Wysebeche, fishmonger 0
4724199 2272862 2272862 defendant Fyssher Thomas husbandman 593217 593217 Fyssher, Thomas, of Wysebeche, husbandman 0
4731350 2275006 2275006 defendant Broun Peter husbandman 593217 593217 Broun, Peter, of Wysebeche, husbandman 1
4731351 2275006 2275006 defendant Simonesson Walter husbandman 593217 593217 Simonesson, Walter, of Wysebeche, husbandman 2
4743193 2278535 2278535 defendant Fyssher Thoas husbandman 593217 593217 Fyssher, Thoas, of Wysebeche, husbandman 0
4754105 2281663 2281663 defendant Fyssher Richard brewer 593217 593217 Fyssher, Richard, of Wysebeche, brewer 0
4761662 2283992 2283992 defendant Roper Thomas husbandman 593217 593217 Roper, Thomas, of Wysebeche, husbandman 0
4761663 2283992 2283992 defendant Stegge Thomas husbandman 593217 593217 Stegge, Thomas, of Wysebeche, husbandman 1
4771370 2287028 2287028 defendant Bate Walter husbandman 593217 593217 Bate, Walter, of Wysebeche, husbandman 0
4771371 2287028 2287028 defendant Kent John husbandman 593217 593217 Kent, John, of Wysebeche, husbandman 1
4786474 2291816 2291816 defendant Salter William husbandman 593217 593217 Salter, William, of Wysebeche, husbandman 0
4790777 2293202 2293202 plaintiff Laurence William (legal representative) 593217 593217 Laurence, William, of Wysebeche, executors of 0
4810968 2299548 2299548 defendant Kepe John merchant 593217 593217 Kepe, John, of Wysebeche, merchant 0
4838431 2307935 2307935 defendant Lombe Simon yeoman 593217 593217 Lombe, Simon, of Wysebeche, yeoman 0
4847011 2310571 2310571 defendant Burwell Robert tailor 593217 593217 Burwell, Robert, of Wysebeche, tailor 1
4847012 2310571 2310571 defendant Roper Alan husbandman 593217 593217 Roper, Alan, of Wysebeche, husbandman 2
4849967 2311461 2311461 defendant Kepe John brewer 593217 593217 Kepe, John, of Wysebeche, brewer 0
4849990 2311468 2311468 defendant Kepe John brewer 593217 593217 Kepe, John, of Wysebeche, brewer 0
4874686 2319027 2319027 defendant Halle Richard husbandman 593217 593217 Halle, Richard, of Wysebeche, husbandman 0
4880810 2320905 2320905 defendant William John dyer 593217 593217 William, John, of Wysebeche, or of Hungerford, Berks, dyer 0
4891912 2324205 2324205 defendant Haltman Thomas husbandman 593217 593217 Haltman, Thomas, of Wysebeche, husbandman 0
4897125 2325756 2325756 defendant Haltman Thomas husbandman 593217 593217 Haltman, Thomas, of Wysebeche, husbandman 0
4901243 2326997 2326997 defendant Mannyng Simon husbandman 593217 593217 Mannyng, Simon, of Wysebeche, husbandman 0
4917493 2331985 2331985 defendant Maste William husbandman 593217 593217 Maste, William, of Wysebeche, husbandman 0
5038552 2368173 2368173 defendant Botiller William smith 593217 593217 Botiller, William, of Wysebeche, smith 0
5254513 2431533 2431533 defendant Dygby Robert tanner 593217 593217 Dygby, Robert, of Wysebeche, tanner 0
5316641 2450063 2450063 plaintiff Drake William   593217 593217 Drake, William, of Wysebeche 0
5346822 2459163 2459163 defendant Mey Thomas yeoman 593217 593217 Mey, Thomas, of Wysebeche, or of Walsoken, Norf, yeoman 3
5457706 2492203 2492203 plaintiff Drake John   593217 593217 Drake, John, of Wysebeche 0
5469545 2495815 2495815 defendant Laurence John yeoman 593217 593217 Laurence, John, of Wysebeche, yeoman 0
5469548 2495815 2495815 defendant Man Robert husbandman 593217 593217 Man, Robert, of Wysebeche, husbandman 3
5469550 2495816 2495816 plaintiff Drake John   593217 593217 Drake, John, of Wysebeche 0
5539156 2516731 2516731 defendant Style Thomas chaplain 593217 593217 Style, Thomas, of Wysebeche, chaplain 2
5621564 2550646 2550646 plaintiff Swone John   593217 593217 Swone, John, of Wysebeche 0
5636756 2555439 2555439 defendant Blower Thomas husbandman 593217 593217 Blower, Thomas, of Wysebeche, husbandman 2
5636757 2555439 2555439 defendant Averell Simon husbandman 593217 593217 Averell, Simon, of Wysebeche, husbandman 3

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);