names

132 rows where place_id = 589301

✎ 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
3597149 1866731 1866731 defendant Degon John husbandman 589301 589301 Degon, John, of Gillyngham, husbandman 4
3615816 1872587 1872587 defendant Broun William husbandman 589301 589301 Broun, William, of Gillyngham, husbandman 2
3620922 1874105 1874105 defendant Fysshe William laborer 589301 589301 Fysshe, William, of Gillyngham, laborer 3
3689213 1922792 1922792 defendant Trumper Thomas cordwainer 589301 589301 Trumper, Thomas, of Gillyngham, cordwainer 1
3769624 1948159 1948159 defendant Shorte William husbandman 589301 589301 Shorte, William, of Gillyngham, husbandman 3
3807734 1960307 1960307 defendant Sturland Geoffrey smith 589301 589301 Sturland, Geoffrey, of Gillyngham, smith 0
3950880 2007374 2007374 defendant Randall Thomas yeoman 589301 589301 Randall, Thomas, of Gillyngham, yeoman 0
4119674 2067323 2067323 defendant Cornyshe John, junior glover 589301 589301 Cornyshe, John, junior, of Gillyngham, glover 2
4413932 2169257 2169257 defendant Cokes Robert   589301 589301 Cokes, Robert, of Gillyngham 0
4420882 2171425 2171425 defendant Cok Robert   589301 589301 Cok, Robert, of Gillyngham 0
4436455 2176138 2176138 defendant Dene Arnald in the   589301 589301 Dene, Arnald in the, of Gillyngham 0
4460204 2188250 2188250 defendant Wyke John   589301 589301 Wyke, John, of Gillyngham 2
4471182 2191648 2191648 defendant Clerk Thomas   589301 589301 Clerk, Thomas, of Gillyngham 0
4475580 2193049 2193049 defendant Blake Robert   589301 589301 Blake, Robert, of Gillyngham 1
4499566 2200512 2200512 defendant Wyke John   589301 589301 Wyke, John, of Gillyngham 1
4499568 2200513 2200513 plaintiff Haym John forester 589301 589301 Haym, John, of Gillyngham, forester 0
4499569 2200513 2200513 defendant Leget John   589301 589301 Leget, John, of Gillyngham 0
4499571 2200513 2200513 defendant Hooper John   589301 589301 Hooper, John, of Gillyngham 2
4499573 2200513 2200513 defendant Hullecote John   589301 589301 Hullecote, John, of Gillyngham 4
4499574 2200513 2200513 defendant Taillour Walter   589301 589301 Taillour, Walter, of Gillyngham 5
4499575 2200513 2200513 defendant Coyt Walter   589301 589301 Coyt, Walter, of Gillyngham 6
4499578 2200513 2200513 defendant Lortevourne John   589301 589301 Lortevourne, John, of Gillyngham 9
4499583 2200513 2200513 defendant Shepherde John   589301 589301 Shepherde, John, of Gillyngham 14
4499584 2200513 2200513 defendant Pypes Nicholas   589301 589301 Pypes, Nicholas, of Gillyngham 15
4541679 2213292 2213292 defendant Wylmot John   589301 589301 Wylmot, John, of Gillyngham 1
4542078 2213415 2213415 plaintiff Wytan John   589301 589301 Wytan, John, of Gillyngham 0
4548582 2215496 2215496 defendant Gillyngham Alice   589301 589301 Gillyngham, Alice, of Gillyngham, formerly wife of William 0
4548583 2215496 2215496 defendant Gillyngham Robert   589301 589301 Gillyngham, Robert, of Gillyngham 1
4553574 2217049 2217049 defendant Clerk John   589301 589301 Clerk, John, of Gillyngham 1
4553581 2217050 2217050 defendant Clerk John   589301 589301 Clerk, John, of Gillyngham 1
4557244 2218199 2218199 defendant Bocher Henry   589301 589301 Bocher, Henry, of Gillyngham 0
4565628 2220819 2220819 defendant Kyng John   589301 589301 Kyng, John, of Gillyngham 0
4569074 2221915 2221915 plaintiff Warrewyk John   589301 589301 Warrewyk, John, of Gillyngham 0
4588102 2227677 2227677 defendant Sayer John   589301 589301 Sayer, John, of Gillyngham 0
4594820 2229633 2229633 defendant Child John   589301 589301 Child, John, of Gillyngham 5
4596566 2230162 2230162 defendant Pyrie Hamond   589301 589301 Pyrie, Hamond, of Gillyngham 0
4600531 2231388 2231388 defendant Pound Robert   589301 589301 Pound, Robert, of Gillyngham 0
4600532 2231388 2231388 defendant Clerk Rober   589301 589301 Clerk, Rober, of Gillyngham 1
4605954 2232976 2232976 defendant Wyke John   589301 589301 Wyke, John, of Gillyngham 0
4610132 2234253 2234253 defendant Wyke John   589301 589301 Wyke, John, of Gillyngham 0
4611779 2234746 2234746 defendant Lavent Walter   589301 589301 Lavent, Walter, of Gillyngham 3
4652157 2246612 2246612 defendant Wyke John   589301 589301 Wyke, John, of Gillyngham 0
4653332 2246982 2246982 plaintiff Beaufitz John   589301 589301 Beaufitz, John, of Gillyngham 0
4653335 2246983 2246983 plaintiff Beaufitz John   589301 589301 Beaufitz, John, of Gillyngham 0
4660934 2249246 2249246 defendant Seman Nicholas farmer 589301 589301 Seman, Nicholas, of Gillyngham,, farmer 0
4688103 2261849 2261849 plaintiff Symon Robert   589301 589301 Symon, Robert, of Gillyngham, vicar 0
4735428 2276225 2276225 plaintiff Symond Robert   589301 589301 Symond, Robert, of Gillyngham, vicar 1
4794791 2294512 2294512 defendant Cresshebien Christine widow 589301 589301 Cresshebien, Christine, of Gillyngham, widow 1
4794792 2294512 2294512 defendant Martyn John gent 589301 589301 Martyn, John, of Gillyngham, gent 2
4857975 2313862 2313862 defendant Edward alias Whitmore Mathew husbandman 589301 589301 Edward alias Whitmore, Mathew, of Gillyngham, husbandman 0
4889599 2323545 2323545 defendant Hengstrigge Walter gent 589301 589301 Hengstrigge, Walter, of Gillyngham, or of Wyke, Dorset, gent 0
4890178 2323698 2323698 defendant Edward Mathew tailor 589301 589301 Edward, Mathew, of Gillyngham, tailor 0
4891799 2324177 2324177 defendant Hamme William yeoman 589301 589301 Hamme, William, of Gillyngham, yeoman 0
4893544 2324682 2324682 defendant Wodham John laborer 589301 589301 Wodham, John, of Gillyngham, laborer 1
4897946 2326019 2326019 defendant Whitmore alias Edward Mathew yeoman 589301 589301 Whitmore alias Edward, Mathew, of Gillyngham, yeoman 0
4909541 2329521 2329521 defendant Clerk Simon husbandman 589301 589301 Clerk, Simon, of Gillyngham, husbandman 0
4938294 2338357 2338357 defendant Welde Ralph husbandman 589301 589301 Welde, Ralph, of Gillyngham, husbandman 0
4945083 2340446 2340446 defendant Bam or Bain Richard gent 589301 589301 Bam or Bain, Richard, of Gillyngham, gent 2
4954926 2343430 2343430 defendant Sandhyrst William yeoman 589301 589301 Sandhyrst, William, of Gillyngham, yeoman 0
4956582 2343923 2343923 defendant Trenchemere Nicholas laborer 589301 589301 Trenchemere, Nicholas, of Gillyngham, laborer 1
4956590 2343924 2343924 defendant Gose John husbandman 589301 589301 Gose, John, of Gillyngham, husbandman 3
4960877 2345215 2345215 defendant Welde Ralph yeoman 589301 589301 Welde, Ralph, of Gillyngham, yeoman 4
4963077 2345864 2345864 defendant Baron Robert dyer 589301 589301 Baron, Robert, of Gillyngham, dyer 1
4970858 2348227 2348227 defendant Levegrene William, senior husbabndman 589301 589301 Levegrene, William, senior, of Gillyngham, husbabndman 0
4970859 2348227 2348227 defendant Welde Ralph husbabndman 589301 589301 Welde, Ralph, of Gillyngham, husbabndman 1
4975222 2349544 2349544 defendant Martyn John gent 589301 589301 Martyn, John, of Gillyngham, gent 0
4987207 2353121 2353121 defendant Peverell John   589301 589301 Peverell, John, of Gillyngham, holy water clerk 3
4995537 2355505 2355505 defendant Stone John butcher 589301 589301 Stone, John, of Gillyngham, butcher 1
5009709 2359721 2359721 defendant Treweman John husbandman 589301 589301 Treweman, John, of Gillyngham, husbandman 4
5011390 2360194 2360194 defendant Lacy John   589301 589301 Lacy, John, of Gillyngham, husbandman, son of John Lacy 0
5029248 2365434 2365434 defendant Frere Ralph chaplain 589301 589301 Frere, Ralph, of Gillyngham, chaplain 3
5047948 2371005 2371005 defendant Fulbourn Richard   589301 589301 Fulbourn, Richard, of Gillyngham, franklin 0
5071127 2377857 2377857 defendant Smyth Henry smith 589301 589301 Smyth, Henry, of Gillyngham, smith 2
5121437 2392701 2392701 defendant Grenestede John gent 589301 589301 Grenestede, John, of Gillyngham, gent 0
5121438 2392701 2392701 defendant Thorp John gent 589301 589301 Thorp, John, of Gillyngham, gent 1
5243775 2428371 2428371 defendant Thorp John gent 589301 589301 Thorp, John, of Gillyngham, gent 0
5267987 2435751 2435751 defendant Rafe John clerk 589301 589301 Rafe, John, of Gillyngham, clerk 0
5267989 2435751 2435751 defendant Fery John laborer 589301 589301 Fery, John, of Gillyngham, laborer 2
5267990 2435751 2435751 defendant Broun William husbandman 589301 589301 Broun, William, of Gillyngham, husbandman 3
5277528 2438504 2438504 defendant Fery John laborer 589301 589301 Fery, John, of Gillyngham, laborer 1
5277529 2438504 2438504 defendant Godfrey Robert yeoman 589301 589301 Godfrey, Robert, of Gillyngham, yeoman 2
5277530 2438504 2438504 defendant Godfrey William husbandman 589301 589301 Godfrey, William, of Gillyngham, husbandman 3
5295250 2443603 2443603 defendant Bocher John butcher 589301 589301 Bocher, John, of Gillyngham, butcher 3
5302845 2445836 2445836 defendant Thorp Nicholas husbandman 589301 589301 Thorp, Nicholas, of Gillyngham, husbandman 2
5302846 2445836 2445836 defendant Pirrey John husbandman 589301 589301 Pirrey, John, of Gillyngham, husbandman 3
5310845 2448280 2448280 defendant Heyward Thomas husbandman 589301 589301 Heyward, Thomas, of Gillyngham, husbandman 3
5310846 2448280 2448280 defendant Manser Robert husbandman 589301 589301 Manser, Robert, of Gillyngham, husbandman 4
5310851 2448281 2448281 defendant Heyward Thomas husbandman 589301 589301 Heyward, Thomas, of Gillyngham, husbandman 3
5310852 2448281 2448281 defendant Manser Robert husbandman 589301 589301 Manser, Robert, of Gillyngham, husbandman 4
5312103 2448651 2448651 defendant Heyward Thomas husbandman 589301 589301 Heyward, Thomas, of Gillyngham, husbandman 1
5312104 2448651 2448651 defendant Roberd John laborer 589301 589301 Roberd, John, of Gillyngham, laborer 2
5312105 2448651 2448651 defendant Fyssh Walter laborer 589301 589301 Fyssh, Walter, of Gillyngham, laborer 3
5324021 2452273 2452273 defendant Godewyn William gent 589301 589301 Godewyn, William, of Gillyngham, gent 0
5344687 2458515 2458515 defendant Thorp Nicholas husbandman 589301 589301 Thorp, Nicholas, of Gillyngham, husbandman 0
5344688 2458515 2458515 defendant Grenehill William husbandman 589301 589301 Grenehill, William, of Gillyngham, husbandman 1
5344689 2458515 2458515 defendant Ram William husbandman 589301 589301 Ram, William, of Gillyngham, husbandman 2
5346543 2459067 2459067 defendant Bere Geoffrey husbandman 589301 589301 Bere, Geoffrey, of Gillyngham, husbandman 0
5364583 2464584 2464584 plaintiff Arnold Robert gent 589301 589301 Arnold, Robert, of Gillyngham, gent 0
5384936 2470764 2470764 defendant Baker Thomas husbandman 589301 589301 Baker, Thomas, of Gillyngham, husbandman 2
5385462 2470913 2470913 defendant Heyward Henry shipman 589301 589301 Heyward, Henry, of Gillyngham, shipman 0

Next page

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