names

67 rows where place_id = 586320

✎ 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
3588424 1864028 1864028 defendant Waller Thomas esq 586320 586320 Waller, Thomas, of Lamberherst, Sussex, esq 0
3590921 1864787 1864787 defendant Symond William clothmaker 586320 586320 Symond, William, of Lamberherst, Sussex, clothmaker 2
3597766 1866920 1866920 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
3600717 1867879 1867879 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
3603304 1868707 1868707 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
3615060 1872354 1872354 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 3
3622048 1874437 1874437 defendant Chevyn John gent 586320 586320 Chevyn, John, of Lamberherst, Sussex, gent 0
3706567 1928339 1928339 defendant Jeffrey John yeoman 586320 586320 Jeffrey, John, of Lamberherst, Sussex, yeoman 0
3838559 1969986 1969986 plaintiff Turke Gilbert   586320 586320 Turke, Gilbert, of Lamberherst, Sussex 0
3994632 2022830 2022830 defendant Darrell Thomas esq 586320 586320 Darrell, Thomas, of Lamberherst, Sussex, esq 0
4135140 2072885 2072885 defendant Dorrell Henry gent 586320 586320 Dorrell, Henry, of Lamberherst, Sussex, gent 0
4298814 2129673 2129673 defendant Numan Samuel yeoman 586320 586320 Numan, Samuel, of Lamberherst, Sussex, yeoman 0
4347331 2146320 2146320 defendant Henbery Julia widow 586320 586320 Henbery, Julia, of Lamberherst, Sussex, widow 2
4366475 2153054 2153054 defendant Vahan Wiat yeoman 586320 586320 Vahan, Wiat, of Lamberherst, Sussex, yeoman 1
4383958 2159340 2159340 defendant Austen Thomas tanner 586320 586320 Austen, Thomas, of Lamberherst, Sussex, tanner 3
4666173 2250890 2250890 defendant Aschebornham John esq 586320 586320 Aschebornham, John, of Lamberherst, Sussex, esq 0
4879367 2320476 2320476 defendant Mette William tailor 586320 586320 Mette, William, of Lamberherst, Sussex, tailor 0
4880420 2320785 2320785 defendant Burdon Thomas rypyer or fishmonger 586320 586320 Burdon, Thomas, of Lamberherst, Sussex, rypyer or fishmonger 1
4910899 2329919 2329919 defendant Waller John esq 586320 586320 Waller, John, of Lamberherst, Sussex, esq 1
4929193 2335547 2335547 defendant Waller John gent 586320 586320 Waller, John, of Lamberherst, Sussex, gent 1
4944275 2340184 2340184 defendant Ry- Stephen rypyer or fishmonger 586320 586320 Ry-, Stephen, of Lamberherst, Sussex, rypyer or fishmonger 2
4944279 2340185 2340185 defendant Rypyer Stephen rypyer or fishmonger 586320 586320 Rypyer, Stephen, of Lamberherst, Sussex, rypyer or fishmonger 2
5068123 2376970 2376970 defendant Courthope Sabina widow 586320 586320 Courthope, Sabina, of Lamberherst, Sussex, widow 2
5127958 2394655 2394655 defendant Rust Thomas   586320 586320 Rust, Thomas, of Lamberherst, Sussex, repyer, or One who carries fish inland to sell 0
5150169 2401190 2401190 defendant Baker John baker 586320 586320 Baker, John, of Lamberherst, Sussex, baker 2
5159048 2403761 2403761 defendant Clerk William rypyer 586320 586320 Clerk, William, of Lamberherst, Sussex, rypyer 0
5261578 2433733 2433733 defendant Aps William husbandman 586320 586320 Aps, William, of Lamberherst, Sussex, husbandman 0
5271153 2436659 2436659 defendant Alverygge Richard trugger or basket maker 586320 586320 Alverygge, Richard, of Lamberherst, Sussex, trugger or basket maker 1
5282823 2440037 2440037 defendant Calley alias Calwyn William husbandman 586320 586320 Calley alias Calwyn, William, of Lamberherst, Sussex, husbandman 0
5284237 2440410 2440410 defendant Aps William husbandman 586320 586320 Aps, William, of Lamberherst, Sussex, husbandman 0
5308161 2447468 2447468 defendant Alveryche Richard laborer 586320 586320 Alveryche, Richard, of Lamberherst, Sussex, laborer 1
5313907 2449180 2449180 defendant Fraunceys Agnes widow 586320 586320 (Fraunceys, Agnes, of Lamberherst, Sussex, widow 2
5318698 2450684 2450684 defendant Burdon Richard husbandman 586320 586320 Burdon, Richard, of Lamberherst, Sussex, husbandman 0
5319700 2450988 2450988 defendant Godfrey John   586320 586320 Godfrey, John, of Lamberherst, Sussex, "repyer" 3
5335311 2455630 2455630 defendant Burgees Thomas innholder 586320 586320 Burgees, Thomas, of Lamberherst, Sussex, innholder 1
5338963 2456757 2456757 defendant Godfrey John courser 586320 586320 Godfrey, John, of Lamberherst, Sussex, courser 1
5340308 2457175 2457175 defendant Wodeward John   586320 586320 Wodeward, John, of Lamberherst, Sussex, "repyer" 0
5344584 2458472 2458472 defendant Alveriche Richard laborer 586320 586320 Alveriche, Richard, of Lamberherst, Sussex, laborer 3
5372660 2467047 2467047 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex,yeoman 2
5373054 2467163 2467163 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 2
5376255 2468167 2468167 defendant Whateman John reaper 586320 586320 Whateman, John, of Lamberherst, Sussex, reaper 0
5379909 2469302 2469302 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
5379938 2469310 2469310 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
5383500 2470364 2470364 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
5387703 2471546 2471546 defendant Coppyng John laborer 586320 586320 Coppyng, John, of Lamberherst, Sussex, laborer 2
5391995 2472790 2472790 defendant Rowe John laborer 586320 586320 Rowe, John, of Lamberherst, Sussex, laborer 1
5400296 2475159 2475159 defendant Coppyng John laborer 586320 586320 Coppyng, John, of Lamberherst, Sussex, laborer 2
5402815 2475881 2475881 defendant Coppyng John laborer 586320 586320 Coppyng, John, of Lamberherst, Sussex, laborer 4
5405010 2476512 2476512 defendant Rowe John laborer 586320 586320 Rowe, John, of Lamberherst, Sussex, laborer 0
5408350 2477470 2477470 defendant Hotspore John yeoman 586320 586320 Hotspore, John, of Lamberherst, Sussex, yeoman 1
5413295 2478904 2478904 defendant Coppyng John laborer 586320 586320 Coppyng, John, of Lamberherst, Sussex, laborer 1
5415755 2479650 2479650 defendant Coppyng John laborer 586320 586320 Coppyng, John, of Lamberherst, Sussex, laborer 4
5427985 2483321 2483321 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
5427988 2483322 2483322 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
5432212 2484602 2484602 defendant Coppyng John laborer 586320 586320 Coppyng, John, of Lamberherst, Sussex, laborer 3
5453137 2490822 2490822 defendant Moyse John   586320 586320 Moyse, John, of Lamberherst, Sussex, inland fish seller 1
5455778 2491627 2491627 defendant Godfrey John   586320 586320 Godfrey, John, of Lamberherst, Sussex 4
5476625 2498003 2498003 defendant Morse John   586320 586320 Morse, John, of Lamberherst, Sussex, inland fish seller 1
5484276 2500221 2500221 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 1
5489523 2501747 2501747 defendant Crewe Thomas laborer 586320 586320 Crewe, Thomas, of Lamberherst, Sussex, laborer 3
5492499 2502670 2502670 defendant Sacre Thomas   586320 586320 Sacre, Thomas, of Lamberherst, Sussex 0
5505886 2506765 2506765 defendant Hotspore John yeoman 586320 586320 Hotspore, John, of Lamberherst, Sussex, yeoman 0
5512596 2508794 2508794 defendant Fewell Nicholas butcher 586320 586320 Fewell, Nicholas, of Lamberherst, Sussex, butcher 0
5514591 2509411 2509411 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex, yeoman 0
5582848 2529703 2529703 defendant Brodde Richard repier 586320 586320 Brodde, Richard, of Lamberherst, Sussex, repier 1
5609130 2537760 2537760 defendant Godfrey John yeoman 586320 586320 Godfrey, John, of Lamberherst, Sussex,yeoman 4
5625326 2551859 2551859 defendant Aschebornham John esq 586320 586320 Aschebornham, John, of Lamberherst, Sussex, esq 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);