names

51 rows where place_id = 676852

✎ 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
4024395 2033403 2033403 defendant Souche Edmund gent 676852 676852 Souche, Edmund, of Gillingham, gent 0
4032654 2036330 2036330 plaintiff Gere William yeoman 676852 676852 Gere, William, of Gillingham, yeoman 0
4082078 2053886 2053886 defendant Cornysshe John glover 676852 676852 Cornysshe, John, of Gillingham, glover 1
4119673 2067323 2067323 defendant Whatley Nicholas clothier 676852 676852 Whatley, Nicholas, of Gillingham, clothier 1
4137028 2073593 2073593 defendant Cornyshe John glover 676852 676852 Cornyshe, John, of Gillingham, glover 1
4137029 2073593 2073593 defendant Horne Nicholas fuller 676852 676852 Horne, Nicholas, of Gillingham, fuller 2
4157228 2080596 2080596 defendant Teryn Christopher chapman 676852 676852 Teryn, Christopher, of Gillingham, chapman 1
4188128 2091348 2091348 defendant Pillipps John baker 676852 676852 Pillipps, John, of Gillingham, baker 0
4211564 2099595 2099595 defendant Phillipps John baker 676852 676852 Phillipps, John, of Gillingham, baker 0
4275648 2121427 2121427 defendant Hamond John gent 676852 676852 Hamond, John, of Gillingham, gent 0
4374830 2156052 2156052 defendant Turner John yeoman 676852 676852 Turner, John, of Gillingham, yeoman 0
4397925 2163881 2163881 defendant Stagg Richard blacksmith 676852 676852 Stagg, Richard, of Gillingham, blacksmith 2
4398602 2164112 2164112 defendant Pearson Daniel   676852 676852 Pearson, Daniel, of Gillingham, brick maker 1
4589883 2228200 2228200 plaintiff Lovetot John   676852 676852 Lovetot, John, of Gillingham 0
4638572 2242817 2242817 defendant Hayron William   676852 676852 Hayron, William, of Gillingham 0
4711073 2268816 2268816 defendant Dygon Geoffrey   676852 676852 Dygon, Geoffrey, of Gillingham, bailiff 0
4731932 2275168 2275168 defendant Godfray William shingler 676852 676852 Godfray, William, of Gillingham, shingler 1
4807025 2298395 2298395 defendant Whytmore Mathew merchant 676852 676852 Whytmore, Mathew, of Gillingham, merchant 0
4986015 2352735 2352735 defendant Appulton William   676852 676852 Appulton, William, of Gillingham, vicar 0
4986016 2352735 2352735 defendant Lacy John laborer 676852 676852 Lacy, John, of Gillingham, laborer 1
4986017 2352735 2352735 defendant Frend Richard laborer 676852 676852 Frend, Richard, of Gillingham, laborer 2
4994788 2355300 2355300 defendant Broke Henry carpenter 676852 676852 Broke, Henry, of Gillingham, carpenter 0
4995088 2355389 2355389 defendant Ebryston William fuller 676852 676852 Ebryston, William, of Gillingham, fuller 0
5146718 2400179 2400179 defendant Whynchild Robert butcher 676852 676852 Whynchild, Robert, of Gillingham, butcher 1
5146719 2400179 2400179 defendant Vynyng William butcher 676852 676852 Vynyng, William, of Gillingham, butcher 2
5147869 2400519 2400519 defendant Gybbes Michael laborer 676852 676852 Gybbes, Michael, of Gillingham, laborer 3
5184553 2411226 2411226 defendant Thorpe Nicholas yeoman 676852 676852 Thorpe, Nicholas, of Gillingham, yeoman 0
5186517 2411805 2411805 defendant Heyward Stephen butcher 676852 676852 Heyward, Stephen, of Gillingham, butcher 0
5295560 2443691 2443691 defendant Thorp Nicholas yeoman 676852 676852 Thorp, Nicholas, of Gillingham, yeoman 0
5295561 2443691 2443691 defendant Crystyan William husbandman 676852 676852 Crystyan, William, of Gillingham, husbandman 1
5297749 2444347 2444347 defendant Pyrry William laborer 676852 676852 Pyrry, William, of Gillingham, laborer 1
5297750 2444347 2444347 defendant Broke Henry carpenter 676852 676852 Broke, Henry, of Gillingham, carpenter 2
5302443 2445697 2445697 defendant Pylaher Richard husbandman 676852 676852 Pylaher, Richard, of Gillingham, husbandman 1
5302843 2445836 2445836 defendant Thorp John gent 676852 676852 Thorp, John, of Gillingham, gent 0
5390412 2472322 2472322 defendant Trenchese Richard husbandman 676852 676852 Trenchese, Richard, of Gillingham, husbandman 0
5418363 2480418 2480418 defendant Thorp John gent 676852 676852 Thorp, John, of Gillingham, gent 0
5421996 2481515 2481515 defendant Ponseherst Thomas laborer 676852 676852 Ponseherst, Thomas, of Gillingham, laborer 0
5422013 2481521 2481521 plaintiff Arnold Robert gent 676852 676852 Arnold, Robert, of Gillingham, gent 0
5422015 2481522 2481522 plaintiff Arnold Robert gent 676852 676852 Arnold, Robert, of Gillingham, gent 0
5427519 2483183 2483183 defendant Idusherst Thomas husbandman 676852 676852 Idusherst, Thomas, of Gillingham, husbandman 0
5466397 2494886 2494886 defendant Grenestede John gent 676852 676852 Grenestede, John, of Gillingham, gent 0
5466399 2494887 2494887 defendant Grenestede John gent 676852 676852 Grenestede, John, of Gillingham, gent 0
5470507 2496098 2496098 defendant Roket William yeoman 676852 676852 Roket, William, of Gillingham, yeoman 0
5471096 2496297 2496297 defendant Grenested John   676852 676852 Grenested, John, of Gillingham 1
5471097 2496297 2496297 defendant Godfrey William yeoman 676852 676852 Godfrey, William, of Gillingham, yeoman 2
5471099 2496297 2496297 defendant Browne William husbandman 676852 676852 Browne, William, of Gillingham, husbandman 4
5471107 2496299 2496299 defendant Mannter (illegible) husbandman 676852 676852 Mannter, _, of Gillingham, husbandman 1
5471108 2496299 2496299 defendant Longe Henry husbandman 676852 676852 Longe, Henry, of Gillingham, husbandman 2
5471109 2496299 2496299 defendant Grenehill William husbandman 676852 676852 Grenehill, William, of Gillingham, husbandman 3
5471110 2496299 2496299 defendant Skelton Thomas shipman 676852 676852 Skelton, Thomas, of Gillingham, shipman 4
5529588 2513753 2513753 defendant Grenehill Thomas husbandman 676852 676852 Grenehill, Thomas, of Gillingham, husbandman 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);