names

56 rows where place_id = 587432

✎ 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
3591413 1864940 1864940 defendant Neuby Richard yeoman 587432 587432 Neuby, Richard, of Spillesby, yeoman 0
3609159 1870523 1870523 defendant Overey Thomas husbandman 587432 587432 Overey, Thomas, of Spillesby, husbandman 2
3609161 1870523 1870523 defendant Stafeley Brian draper 587432 587432 Stafeley, Brian, of Spillesby, draper 4
3815423 1962741 1962741 defendant Smyth Thomas mercer 587432 587432 Smyth, Thomas, of Spillesby, mercer 0
3824126 1965418 1965418 defendant Smyth Thomas mercer 587432 587432 Smyth, Thomas, of Spillesby, mercer 1
3834083 1968599 1968599 defendant Alster Henry husbandman 587432 587432 Alster, Henry, of Spillesby, husbandman 3
4124614 2069100 2069100 defendant Chubbes William butcher 587432 587432 Chubbes, William, of Spillesby, butcher 1
4127856 2070251 2070251 defendant Whyte Richard yeoman 587432 587432 (Whyte, Richard, of Spillesby, yeoman 1
4143792 2075988 2075988 defendant Shepley Christopher yeoman 587432 587432 Shepley, Christopher, of Spillesby, yeoman 1
4153431 2079297 2079297 defendant Chubb William butcher 587432 587432 Chubb, William, of Spillesby, butcher 1
4158200 2080937 2080937 defendant Coxon John shoemaker 587432 587432 Coxon, John, of Spillesby, shoemaker 2
4172872 2085966 2085966 defendant Hoode John mercer 587432 587432 Hoode, John, of Spillesby, mercer 0
4182137 2089230 2089230 defendant Shepley or Shipley Christopher carpenter 587432 587432 Shepley or Shipley, Christopher, of Spillesby, carpenter 0
4299005 2129738 2129738 defendant Almerye Nicholas yeoman 587432 587432 Almerye, Nicholas, of Spillesby, yeoman 2
4425392 2172765 2172765 plaintiff Malet Walter   587432 587432 Malet, Walter, of Spillesby 0
4425393 2172765 2172765 defendant Taverner William le   587432 587432 Taverner, William le, of Spillesby 0
4438485 2181325 2181325 plaintiff Straythefeld William de   587432 587432 Straythefeld, William de, of Spillesby, parson 1
4438486 2181325 2181325 defendant Cook Richard   587432 587432 Cook, Richard, of Spillesby 0
4527362 2208838 2208838 plaintiff Litster William   587432 587432 Litster, William, of Spillesby 0
4527364 2208839 2208839 plaintiff Litster William   587432 587432 Litster, William, of Spillesby 0
4655070 2247470 2247470 plaintiff Braytoft William   587432 587432 Braytoft, William, of Spillesby 0
4667322 2255508 2255508 defendant Warde John butcher 587432 587432 Warde, John, of Spillesby, butcher 0
4711870 2269044 2269044 plaintiff Scotton John master of the chantry 587432 587432 Scotton, John, of Spillesby, master of the chantry 0
4718779 2271217 2271217 plaintiff Baxster Thomas   587432 587432 Baxster, Thomas, of Spillesby 0
4726156 2273467 2273467 defendant Vygoly Joan   587432 587432 Vygoly, Joan, of Spillesby, servant 0
4787210 2292066 2292066 defendant Baxster Thomas baker 587432 587432 Baxster, Thomas, of Spillesby, baker 1
4798034 2295573 2295573 defendant Tewer Simon husbandman 587432 587432 Tewer, Simon, of Spillesby, husbandman 0
4798036 2295573 2295573 defendant Appulby William husbandman 587432 587432 Appulby, William, of Spillesby, husbandman 2
4884698 2322124 2322124 defendant Asshe John gent 587432 587432 Asshe, John, of Spillesby, gent 8
4891169 2323974 2323974 defendant Asshe John gent 587432 587432 Asshe, John, of Spillesby, gent 7
4909629 2329543 2329543 plaintiff Baxter Thomas   587432 587432 Baxter, Thomas, of Spillesby 1
4993480 2354921 2354921 defendant Baly Margaret   587432 587432 Baly, Margaret, of Spillesby, widow, formerly wife of Richard 1
5069041 2377238 2377238 defendant Burdon Robert husbandman 587432 587432 Burdon, Robert, of Spillesby, husbandman 1
5077975 2379895 2379895 defendant Croft William chaplain 587432 587432 Croft, William, of Spillesby, chaplain 0
5085897 2382265 2382265 defendant Cook William butcher 587432 587432 Cook, William, of Spillesby, butcher 0
5121861 2392827 2392827 defendant Meryman William yeoman 587432 587432 Meryman, William, of Spillesby, yeoman 0
5124739 2393712 2393712 defendant Coke Richard butcher 587432 587432 Coke, Richard, of Spillesby, butcher 0
5139539 2398051 2398051 defendant Merston John yeoman 587432 587432 Merston, John, of Spillesby, yeoman 0
5143323 2399186 2399186 defendant Cole Richard butcher 587432 587432 Cole, Richard, of Spillesby, butcher 0
5164176 2405261 2405261 defendant Merston John yeoman 587432 587432 Merston, John, of Spillesby, yeoman 1
5177940 2409254 2409254 defendant Coke Richard butcher 587432 587432 Coke, Richard, of Spillesby, butcher 0
5180407 2410011 2410011 defendant Cooke Richard, sen husbandman 587432 587432 Cooke, Richard, sen, of Spillesby, husbandman 0
5201188 2416106 2416106 defendant Coke Richard butcher 587432 587432 Coke, Richard, of Spillesby, butcher 0
5216930 2420692 2420692 defendant Merston John yeoman 587432 587432 Merston, John, of Spillesby, yeoman 0
5222887 2422408 2422408 defendant Pyllet John cooper 587432 587432 Pyllet, John, of Spillesby, cooper 1
5256061 2432021 2432021 defendant Meryman William yeoman 587432 587432 Meryman, William, of Spillesby, yeoman 1
5285586 2440806 2440806 defendant Fenne John husbandman 587432 587432 Fenne, John, of Spillesby, husbandman 2
5355830 2461897 2461897 defendant Swagge Richard laborer 587432 587432 Swagge, Richard, of Spillesby, laborer 2
5379262 2469108 2469108 defendant Motte Robert yeoman 587432 587432 Motte, Robert, of Spillesby, yeoman 1
5431364 2484334 2484334 defendant Whetelay Robert tailor 587432 587432 Whetelay, Robert, of Spillesby, tailor 1
5448219 2489360 2489360 defendant Whetelay Robert tailor 587432 587432 Whetelay, Robert, of Spillesby, tailor 1
5460580 2493107 2493107 defendant Whetelay Robert tailor 587432 587432 Whetelay, Robert, of Spillesby, tailor 1
5558436 2522415 2522415 defendant Warre John yeoman 587432 587432 Warre, John, of Spillesby, yeoman 0
5558437 2522415 2522415 defendant Madynwell Richard carpenter 587432 587432 Madynwell, Richard, of Spillesby, carpenter 1
5564982 2524345 2524345 defendant Aiscough Richard yeoman 587432 587432 Aiscough, Richard, of Spillesby, yeoman 1
5619467 2549936 2549936 plaintiff Pestod Simon   587432 587432 Pestod, Simon, of Spillesby 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);